Retail Data mart Consultant

5 to 8 years to support the implementation/upgrade/maintenance of Retail Data Mart.

Responsibilities
Functional Specification

• Responsible to analyse and define detailed functional specifications based on the functional and non-functional requirements document
• Collaborate with Functional Business Analyst to clarify functional and non-functional requirements
• Define and ensure traceability from functional specifications to business requirements

Technical Design

• Responsible to create technical design
• Ensure technical design adheres to architectural roadmap Development practices and security requirements
• In case of vendor implementation: Ensure vendor resources create technical design document
• Collaborate with developers and infrastructure teams to clarify functional specification and technical design during build test and deployment phase
• Collaborate with Production Support to establish IT operations procedures and document as part of Tech Design
• Coordinate execution of threat modelling process with assistance of Security Architect to ensure implementation of safeguards is comprehensive in accordance with threats

Testing & Scope Management

• Clarify test findings escalated by Test Manager and classify the findings accordingly (either as a defect or change request)
• Provide input to impact assessment and estimation for Project Change Request
• Work with Test Manager to review test plan and functional test scope

Requirements:

• Commitment and a have a team environment mindset
• Expertise in logical and physical data modelling
• Proficient in data modelling profiling
• SQL skills and ability to work with datasets.
• Understanding of data warehousing, and data integration techniques

Key Domain

Technical Skills:

• Experience with Hadoop, SQL.
• Private Banking/Treasury (Fixed Income, Derivatives)
• Data modelling, or data management, in the banking industry