Senior Data Modeller – Enterprise Data Warehouse (6-Month Contract)

Rosstone; Gauteng; On-site; ZAR 1,000,000 - 1,800,000; Full time

Job summary

Rosstone is seeking a Senior Data Modeller to lead the design and evolution of dimensional models within a large-scale Enterprise Data Warehouse built on Amazon Redshift.

You will design and maintain enterprise-grade dimensional models, develop fact and dimension tables, and optimize complex SQL queries while collaborating with data engineers, analysts, and business stakeholders.

Qualifications

• 8–10 years’ experience in data modelling and data warehousing.
• Strong expertise in Kimball dimensional modelling.
• Advanced SQL skills, especially on Amazon Redshift.
• Experience with AWS data tools: S3, Glue, Athena.
• Background in telecoms or banking environments.
• Proven stakeholder engagement and workshop facilitation.

Responsibilities

• Design and maintain enterprise-grade dimensional models (Kimball).
• Develop fact and dimension tables ensuring scalability.
• Optimize and write complex SQL queries on Redshift.
• Collaborate with data engineers, analysts, and business stakeholders.
• Facilitate workshops translating business requirements into data models.
• Ensure data quality, governance and consistency across the platform.
• Mentor junior team members and influence data architecture decisions.

Skills

Data modelling

Data warehousing

Kimball dimensional modelling

SQL proficiency

Stakeholder engagement

Workshop facilitation

Agile

Tools

Amazon Redshift

S3

Glue

Athena

Job description

We are looking for a Senior Data Modeller to lead the design and evolution of dimensional models within a large-scale Enterprise Data Warehouse built on Amazon Redshift.

Key Responsibilities:

• Design and maintain enterprise-grade dimensional models (Kimball methodology)
• Develop fact and dimension tables, ensuring scalability and performance
• Optimize and write complex SQL queries on Redshift
• Collaborate with data engineers, analysts, and business stakeholders
• Facilitate workshops to translate business requirements into data models
• Ensure data quality, governance, and consistency across the platform
• Mentor junior team members and influence data architecture decisions

Minimum Requirements:

• 8–10 years’ experience in data modelling / data warehousing
• Strong expertise in Kimball dimensional modelling
• Advanced SQL skills, particularly on Amazon Redshift
• Experience with AWS data tools (S3, Glue, Athena)
• Background in telecoms or banking environments
• Proven stakeholder engagement and workshop facilitation experience

Ideal to Have:

• Exposure to BI tools, semantic layers, and data governance tools
• Experience in Agile / product-based data teams