Data Engineer - Data Warehouse & Data Modelling

Data Engineer with focus on Data Warehousing and Data Modelling

Seniority: Medior (around 6 years of experience)

Assignment Overview

As a Data Engineer with focus on Data Warehousing and Data Modelling, you will play a central role in designing, developing, and maintaining curated data structures that support analytical, regulatory, and business use cases in a banking context.

You will work in close collaboration with:

• Data Engineers Leads
• Other Data Engineers (Platform, integration & lake-focused)
• Data Analysts and BI Developers
• Tech Leads and Product Owners
• Finance, Risk, and Compliance stakeholders

Your work will bridge business context and deep technical implementation, ensuring that data models are scalable, governed, and aligned with platform standards.

Key Responsibilities:

• Design, develop, and maintain Data Warehouse and Data Mart solutions on the AWS-based data platform
• Develop and evolve data models that support financial, risk, and regulatory reporting
• Translate business requirements into robust, well-structured analytical models
• Collaborate with integration-focused teams to ensure clean and reliable upstream data
• Build and maintain transformation pipelines using modern tooling and best practices
• Contribute to platform-level design decisions and architectural discussions
• Apply DevOps principles to ensure solutions are reliable, testable, and maintainable
• Actively participate in solution design, code reviews, and continuous improvement

Competency profile

Must Have experience/expertise:

• Experience in Data Warehousing and Data Modeling (DW/DM)
• Understanding of banking domain data, preferably within Finance, Risk, or Compliance
• Strong SQL skills and ability to reason about complex data structures
• Experience building data solutions on cloud-based data platforms (AWS or similar)
• Ability to understand and connect business context with technical implementation
• Experience working in cross-functional, agile delivery teams

Note: Experience with a specific warehouse technology (e.g. Redshift) is valuable, but the role is not tied to a single engine.

Technical Competence - Strongly Preferred / Added Value to have experience with:

• Data modelling methodologies (e.g. dimensional modelling, data marts)
• Infrastructure as code (IaC), e.g. Terraform
• Modern table formats, e.g. Apache Iceberg
• Orchestration frameworks, e.g. Apache Airflow
• Transformation tools, e.g. dbt
• CI/CD pipelines, preferably using GitHub Actions
• Understanding of access management and network infrastructure in cloud environments
• Banking or financial services

• Structured, analytical, and quality-oriented mindset
• Self-driven and proactive, with a strong sense of ownership
• Collaborative and communicative, comfortable working across technical and business roles
• Ability to explain complex data concepts to non-technical stakeholders
• Excellent English communication skills (written and spoken)

Good to have:

• Experience with legacy DW technologies such as Oracle RDBMS or Informatica
• Familiarity with SAFe or other agile frameworks

As part of the recruitment process, the client will conduct background checks on candidates who progress to later stages.

If you're interested in this consultancy opportunity, click 'apply now' to forward an up-to-date copy of your CV. We are looking forward to receiving your application and to speaking further with you.