Job Description

About the Role
We’re looking for a Senior Data Warehouse Analyst / Data Model Owner to join our team and support the growth of our cloud-based Data Warehouse platform.

This is a hands-on role where you’ll help improve and scale our data model so it can support new integrations, reporting needs, and better decision-making across the business.

What You’ll Do

You’ll ensure the Data Warehouse evolves in line with business needs while maintaining strong technical foundations. Your main responsibilities will include:

• Data Model Ownership: Analyze, maintain, and improve the Data Warehouse model, ensuring consistency, usability, and scalability.

• Dimensional Modeling & Data Marts: Design and manage logical and dimensional models (Star Schema, Snowflake) for Data Marts supporting regulatory and management reporting.

• Source System Integration: Collaborate with teams across Core Banking, Loan Origination, Digital Banking, CRM, and other systems to understand data structures and ensure smooth, scalable integration.

• Data Mapping Review: Validate and align data mappings and extraction logic with overall Data Warehouse standards and reporting needs.

• Collaboration with Development Teams: Provide clear functional requirements and data modeling guidance for implementation of DWH structures, ETL/ELT processes, and Data Marts.

• Regulatory Reporting Support: Contribute to integrating new regulatory requirements by defining necessary model enhancements.

• Data Quality & Validation: Define and support data quality rules, validation checks, and reconciliation processes.

• Business & Technical Liaison: Act as a bridge between business and technical teams, translating business needs into structured data solutions.

• Documentation & Governance: Maintain clear documentation and ensure strong governance of data models and business rules.

What We’re Looking For

• 3+ years of experience in Data Warehousing and Data Modeling within the banking sector

• Solid background in banking or financial services

• Familiarity with core banking systems (e.g., FCUBS or similar)

Technical Skills

• Strong expertise in dimensional modeling (Star Schema, Snowflake, Data Marts)

• Proficiency in SQL (Oracle or Microsoft SQL Server)

• Good understanding of ETL/ELT concepts

• Hands-on experience with key DWH concepts (SCD Type 2, surrogate keys, fact & dimension tables)

Domain Knowledge

• Strong understanding of banking data (loans, deposits, transactions, accounts, exposures, etc.)

• Basic knowledge of regulatory frameworks (Basel, IFRS)

Key Competencies

• Ability to translate business requirements into effective data models

• Strong attention to detail, especially around data quality

• Collaborative mindset across business and technical teams

• Ability to maintain and enforce Data Warehouse standards

Nice to Have

• Experience with Microsoft Azure Data Platform

• Exposure to regulatory reporting and compliance

• Experience integrating multiple banking systems into a DWH

• Hands-on experience with ETL tools or database development

• Experience using data modeling tools