About the position
Job Description: Snr Data Modelling - Enterprise Data Warehouse
Location: Johannesburg, Gauteng
Duration: 6 Months
More about the Area & Team:
We are seeking Senior Data Modelling to lead the design and evolution of dimensional data models for a large-scale enterprise data warehouse built primarily on Amazon Redshift.
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.
Job Description / 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 optimized 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 optimize 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 optimization 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 data governance and best-practice frameworks
Leadership & Mentorship
- Provide guidance and mentoring to junior modelers and analysts
- Review data models and SQL developed by others
- Influence architectural and design decisions across the data platform
Background and experience required:
- Years' experience
- Industry experience
- 8 - 10 years' experience within a Data role
- Telecommunications experience 5+ years' experience
- Banking experience 5+ years' experience
- 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 teams
Must-have Skills (Mandatory Skills):
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 optimizing 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
Beneficial Skills (Desired Skills):
- 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 teams
??????Mandatory Skills:
- Extensive experience in enterprise data warehousing
- Advanced expertise in Kimball dimensional modelling
- Proven experience designing models used at scale across multiple business domains
- Advanced SQL skills, with a strong focus on Amazon Redshift and other data/analytic platforms
- Experience optimizing queries for performance in columnar data warehouses
- Solid understanding of ELT/ETL processes and data pipelines
- Proven ability to run effective modelling and requirements workshops.
Desired Skills:
- 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 teams
Desired Skills:
- Enterprise Data Warehousing
- Kimbali Dimensional Modelling
- SQL
- AMAZON Redshift
