Job Description

We are seeking an experienced Senior Data Modeller to join a leading banking institution in Sandton. We want a strategic thinker who understands both data and banking, with the ability to engage confidently with business stakeholders, challenge assumptions, and design scalable data models that deliver meaningful business insights.

In this role, you will lead the design and evolution of enterprise-grade dimensional models within a modern Enterprise Data Warehouse environment, ensuring trusted, high-quality data that supports reporting, analytics, and enterprise decision-making. This opportunity is ideal for a seasoned professional with strong Banking experience, advanced Kimball dimensional modelling expertise, and a passion for data quality, governance, and best practices.

What You'll Be Doing

Enterprise Data Modelling

• Lead the design and maintenance of enterprise-scale dimensional data models using Kimball methodology.
• Design robust fact tables, dimensions, conformed dimensions, and surrogate key strategies.
• Ensure data models are scalable, reusable, and aligned to enterprise reporting and analytics requirements.
• Continuously improve existing models to enhance performance, usability, and business value.

Data Warehouse & Analytics Excellence

• Develop and optimize complex SQL solutions within Amazon Redshift environments.
• Profile, analyse, and validate source data to support modelling decisions.
• Partner with Data Engineers, BI Developers, Analysts, and Architects to deliver high-quality analytical solutions.
• Drive best practices in data modelling, data quality, and enterprise reporting.

Business & Stakeholder Engagement

• Facilitate requirements gathering and data modelling workshops with business stakeholders.
• Translate banking business processes, KPIs, and reporting requirements into scalable dimensional models.
• Serve as a trusted advisor to business users and analytics teams, ensuring data is understood, trusted, and effectively utilized.
• Communicate complex technical concepts in a clear and business-friendly manner.

Governance & Leadership

• Establish and maintain modelling standards, naming conventions, and design frameworks.
• Support data governance initiatives, lineage, metadata management, and enterprise data consistency.
• Mentor junior team members and provide guidance on modelling and SQL best practices.
• Contribute to strategic data architecture and enterprise data management decisions.

Requirements

• 8–10 years of Data Modelling and Data Warehousing experience.
• Minimum 5 years of Banking and Telecommunications industry experience.

• Advanced expertise in Kimball Dimensional Modelling
• Extensive experience designing enterprise-scale dimensional models across multiple business domains.
• Strong understanding of Enterprise Data Warehousing concepts and architecture.
• Advanced SQL development and query optimization skills.
• Hands-on experience with Amazon Redshift or similar analytical database platforms.
• Strong understanding of ETL/ELT processes, data pipelines, and analytical data platforms.
• Experience working with large volumes of data in complex reporting environments.

Additional Advantageous Skills

• AWS Data Services including S3, Glue, and Athena.
• Data Governance, Metadata Management, and Data Catalog solutions.
• Business Intelligence platforms and semantic modelling layers.
• Agile delivery methodologies and product-based data teams.

If you are a senior banking data professional with a passion for enterprise data architecture, analytics, and modern data warehousing, we would like to hear from you.