Description

Build and maintain reporting data warehouse solutions for Risk and Compliance using dimensional data models and data integration techniques.

This role is on-site.

Responsibilities

• Design, develop, and debug ETL integration code based on defined source-to-target mappings.
• Build, maintain, and govern the Hadoop data layer to ensure data consistency.
• Collaborate with Data Modelers to structure requirements into data warehouse models for analytics.
• Execute and troubleshoot complex report SQL and build database objects to meet stakeholder requirements.
• Implement physical modeling solutions in collaboration with Data Architects to mitigate performance impacts.

Required Skills

• 8+ years of software engineering experience.
• Expertise in designing and building dimensional data models.
• Advanced SQL development and troubleshooting skills.
• Experience with ETL design and complex integration requirements.
• Proficiency with GitHub and SDLC processes.
• Hands-on experience building and governing Hadoop data layers.
• Ability to perform unit testing to ensure data accuracy against back-end systems.
• Experience defining data security roles, groups, and policies.

Preferred Skills

• Experience with Risk and Compliance data domains.

Key Skills

Education

Any Graduate