AVP-Data Architect (Datawarehousing, BI, Data Modelling) recruitment

Responsibilities:
• To participate in the design, development and implementation of customer Data Warehouse (DWH) and Business Intelligence (BI) solutions
• To develop and maintain working relationships with key personnel on the client engagement, to ensure the client’s needs are met in a professional manner.
• To provide advice and consultation to internal user groups on all data warehouse (DWH) related matters
• To elicit manage DWH business requirements
• To develop DWH business requirements specification into system requirement specifications (high level design)
• To provide IT with business and application expertise

DWH Business Analysis
• Assist Business with Business Requirement Documents (BRD) and translate DWH related business requirements into detailed system/ functional requirement specifications (SRS) and traceability matrix
• Develop high level DWH design specifications
• Develop Use Cases assist in User workshops on an international level
• Maintain up-to-date development roadmap and documentation for the assigned project component
• Act as single point of contact for all issues and questions related to the assigned project component
• Manage requirements lifecycle with tool support
• Assist in designing test strategy, test plans and test cases
• Provide support to the users and assist other IT teams on critical issues and participate in IT taskforces
• Publish and maintain project documentation in accordance to Corporate Quality and Process definitions including but not limited to CMMi Level 3 standards

Relationship Management to Users and IT
• Facilitate resolution of functional points of contention between users and IT
• Understand user needs and advise them on the best way to get these needs met

Processes
• Support the Project Manager and business to clarify requirements and scope
• Moderate requirements gathering drives and workshops on a global scale
• Elicit and manage requirements in a structured manner
• Provide status updates and reports from the functional stream to project management
• To execute functional impact analysis on change requests and their impact on test cases

Requirements:

• Possess a degree in either Finance, Business Administration or IT
• Min 5-7 years of experience as a Business Analyst with DWH or BI implementation projects
• Min 3-5 years of experience in banking sector (as BA), preferably in Private Banking
• Good knowledge about (private) banking business and MIS
• Ability to pro-actively interact with other Business Engineers, Data Modellers and Business Users to understand and design technical solutions based on user requirements and offer recommendations/alternatives
• Possess an excellent understanding of DWH database design, architecture and data modelling
• SQL skills are essential and Technical expertise in Oracle, PowerCenter Informatica and Business Objects is of advantage
• Prefer to have someone with the ability to design and implement ETL and Reporting architectures and have extensive knowledge of DWH / BI techniques incl. Dimensional Modelling, Slowly changing dimensions, data aggregation, reconciliation, data quality

Role is initially offered on contract for 12 Months with a view to turning permanent.
 

If you would like to apply for this role or find out more, please apply online or contact Robert Walters on +65-62280200 or itcontracting@robertwalters.com.sg.