Senior Data Warehouse Analyst
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