Senior Data Modeller
Absa
n/a - n/a
R900–1,100 per hour
Auckland Park, City of Johannesburg Metropolitan Municipality, 2092
Contract
Stakeholder Engagement
SQL
Amazon Redshift
Data Governance
Data Modelling
Role
Role Overview
We are seeking a Senior Data Modeller to lead the design and evolution of dimensional data models for a large-scale enterprise data warehouse built primarily on Amazon Redshift.
This role requires deep expertise in Kimball dimensional modelling, strong hands-on SQL querying skills, and the ability to confidently engage business stakeholders and data knowledge workers to translate analytical needs into robust, performant data models.
You will play a key role in shaping the analytical layer of the enterprise platform and ensuring that data is trusted, well-structured, and fit for decision-making.
Key Responsibilities
Senior Data Modelling & Design
• Lead the design and maintenance of enterprise-grade dimensional models using Kimball standards
• Design fact tables, dimensions, conformed dimensions, and surrogate key strategies
• Ensure models are optimised for Redshift performance (distribution styles, sort keys, query patterns)
• Review and refactor existing models to improve usability, performance, and scalability
Hands-on SQL & Redshift Expertise
• Write and optimise complex SQL queries on Amazon Redshift for analysis, validation, and performance tuning
• Profile source data to validate assumptions and inform modelling decisions
• Support downstream analytics and BI teams with query optimisation and model usage guidance
• Partner with data engineers and analysts to align modelling decisions with ELT implementation
Stakeholder Engagement & Workshops
• Facilitate requirements and modelling workshops with business stakeholders and data knowledge workers
• Translate business concepts, KPIs, and metrics into well-defined dimensional structures
• Act as a trusted advisor to business and analytics teams on data interpretation and usage
• Communicate complex data concepts clearly to non-technical audiences
Data Quality, Governance & Standards
• Define and enforce modelling standards, naming conventions, and design patterns
• Document data definitions, business rules, and assumptions
• Support data lineage, impact analysis, and enterprise data consistency
• Contribute to data governance and best-practice frameworks
Leadership & Mentorship
• Provide guidance and mentoring to junior modellers and analysts
• Review data models and SQL developed by others
• Influence architectural and design decisions across the data platform
Required Skills & Experience
Core Expertise
• Extensive experience in enterprise data warehousing
• Advanced expertise in Kimball dimensional modelling
• Proven experience designing models used at scale across multiple business domains
• Strong understanding of analytical and reporting use cases
Technical & Querying Skills
• Advanced SQL skills, with a strong focus on Amazon Redshift and other data/analytic platforms
• Experience optimising queries for performance in columnar data warehouses
• Strong data profiling and validation skills
• Solid understanding of ELT/ETL processes and data pipelines
Stakeholder & Communication Skills
• Proven ability to run effective modelling and requirements workshops
• Experience working closely with data knowledge workers, analysts, and decision-makers
• Ability to challenge requirements constructively and propose better modelling approaches
Desirable (Nice to Have)
• Experience with AWS data ecosystem (S3, Glue, Athena, etc.)
• Familiarity with BI tools and semantic layers • Exposure to data governance, metadata, or data catalog tools
• Experience in Agile / product-oriented data team
We are seeking a Senior Data Modeller to lead the design and evolution of dimensional data models for a large-scale enterprise data warehouse built primarily on Amazon Redshift.
This role requires deep expertise in Kimball dimensional modelling, strong hands-on SQL querying skills, and the ability to confidently engage business stakeholders and data knowledge workers to translate analytical needs into robust, performant data models.
You will play a key role in shaping the analytical layer of the enterprise platform and ensuring that data is trusted, well-structured, and fit for decision-making.
Key Responsibilities
Senior Data Modelling & Design
• Lead the design and maintenance of enterprise-grade dimensional models using Kimball standards
• Design fact tables, dimensions, conformed dimensions, and surrogate key strategies
• Ensure models are optimised for Redshift performance (distribution styles, sort keys, query patterns)
• Review and refactor existing models to improve usability, performance, and scalability
Hands-on SQL & Redshift Expertise
• Write and optimise complex SQL queries on Amazon Redshift for analysis, validation, and performance tuning
• Profile source data to validate assumptions and inform modelling decisions
• Support downstream analytics and BI teams with query optimisation and model usage guidance
• Partner with data engineers and analysts to align modelling decisions with ELT implementation
Stakeholder Engagement & Workshops
• Facilitate requirements and modelling workshops with business stakeholders and data knowledge workers
• Translate business concepts, KPIs, and metrics into well-defined dimensional structures
• Act as a trusted advisor to business and analytics teams on data interpretation and usage
• Communicate complex data concepts clearly to non-technical audiences
Data Quality, Governance & Standards
• Define and enforce modelling standards, naming conventions, and design patterns
• Document data definitions, business rules, and assumptions
• Support data lineage, impact analysis, and enterprise data consistency
• Contribute to data governance and best-practice frameworks
Leadership & Mentorship
• Provide guidance and mentoring to junior modellers and analysts
• Review data models and SQL developed by others
• Influence architectural and design decisions across the data platform
Required Skills & Experience
Core Expertise
• Extensive experience in enterprise data warehousing
• Advanced expertise in Kimball dimensional modelling
• Proven experience designing models used at scale across multiple business domains
• Strong understanding of analytical and reporting use cases
Technical & Querying Skills
• Advanced SQL skills, with a strong focus on Amazon Redshift and other data/analytic platforms
• Experience optimising queries for performance in columnar data warehouses
• Strong data profiling and validation skills
• Solid understanding of ELT/ETL processes and data pipelines
Stakeholder & Communication Skills
• Proven ability to run effective modelling and requirements workshops
• Experience working closely with data knowledge workers, analysts, and decision-makers
• Ability to challenge requirements constructively and propose better modelling approaches
Desirable (Nice to Have)
• Experience with AWS data ecosystem (S3, Glue, Athena, etc.)
• Familiarity with BI tools and semantic layers • Exposure to data governance, metadata, or data catalog tools
• Experience in Agile / product-oriented data team
Apply
Share