Senior Data Modeler: Redshift Enterprise DW (Kimball)

Indsafri India Private Limited; South Africa; Hybrid; ZAR 700,000 - 900,000; Full time

Job summary

Indsafri India Private Limited is seeking a highly experienced Senior Data Modeler to lead the design, development, and evolution of dimensional data models for a large-scale enterprise data warehouse on Amazon Redshift.

This critical role involves optimizing data models, writing complex SQL queries, and collaborating with data engineers and analysts to align data modeling with implementation strategies.

Applicants should possess 8-10 years of experience in data modeling and data warehousing, along with advanced skills in SQL and extensive knowledge of Kimball methodologies.

Qualifications

• 8-10 years of progressive experience in data modelling and data warehousing roles.
• Extensive experience in enterprise data warehousing and expertise in Kimball dimensional modelling methodologies.
• Proven experience designing and implementing dimensional models at scale across multiple business domains.
• Advanced SQL skills with a strong focus on Amazon Redshift and other data/analytic platforms.

Responsibilities

• Lead the design and maintenance of enterprise-grade dimensional models.
• Ensure data models are optimized for Amazon Redshift performance.
• Review and refactor existing data models.
• Write and optimize complex SQL queries for analysis.

Skills

ETL

data validation

data quality

SQL

Agile Methodologies

communication

AWS Glue

Mentorship

Requirements Gathering

Data Warehousing

Data Modeling

Metadata Management

Data Governance

ELT

amazon redshift

kpis

data profiling

Performance Optimization

Stakeholder Collaboration

AWS S3

AWS Athena

Data Lineage

Banking Industry

Business Translation

Kimball Dimensional Modeling

Advisory Role

Business Intelligence (BI) Tools

Semantic Layer Concepts

Data Catalog Tools

Telecommunications Industry

Education

8-10 years of experience in data modelling and data warehousing

Tools

Amazon Redshift

AWS Glue

AWS S3

AWS Athena

Job description

Indsafri India Private Limited is seeking a highly experienced Senior Data Modeler to lead the design, development, and evolution of dimensional data models for a large-scale enterprise data warehouse on Amazon Redshift.

This critical role involves optimizing data models, writing complex SQL queries, and collaborating with data engineers and analysts to align data modeling with implementation strategies.

Applicants should possess 8-10 years of experience in data modeling and data warehousing, along with advanced skills in SQL and extensive knowledge of Kimball methodologies.