Senior Data Modeller (6-Month Contract) at DeARX Services (Pty) Ltd

• 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.