Senior BI / Data Warehouse Developer - Cape Town - up to R800k per annum

ATS Client; Cape Town; On-site; ZAR 480,000 - 800,000; Full time

Job summary

ATS Client in the Western Cape seeks an experienced data warehouse specialist to deliver enterprise-scale BI and analytics solutions. You will shape requirements with business partners, design scalable DW architectures, and drive data quality and self-service BI in an agile environment.

You will implement ETL pipelines, data modelling (Kimball), and robust reporting, collaborating across legacy and modern systems while engaging stakeholders to translate business needs into technical specs.

Qualifications

• Minimum 5 years experience in Data Warehousing and/or ETL development
• Strong architectural mindset
• Data and report modelling expertise
• Batch processing and scheduling experience
• Strong stakeholder engagement and relationship management
• Experience translating business requirements into technical specifications
• Enterprise Data Warehousing (Kimball methodology)
• ETL tools (SSIS, IBM DataStage, Informatica, ODI, or similar)
• PL/SQL or T-SQL scripting and optimization
• Agile delivery experience (SCRUM)

Responsibilities

• Champion BI and Data Warehouse architecture
• Promote data quality, integrity, and reliability within BI solutions
• Contribute to and participate in architectural forums
• Data modelling (dimensional, multidimensional, and relational)
• Design and implement ETL architecture
• Process automation and architectural design
• PL/SQL development and optimization
• Report development and support
• Promote and enable self-service BI
• IT and business process optimization
• Data integration across legacy and modern systems
• Collaborate with business users to gather and define requirements
• Develop ad-hoc scripts to support analytical queries
• Batch processing support and scheduling
• Agile documentation

Skills

BI & Data Warehousing

ETL architecture

Data modelling (Kimball)

PL/SQL / T-SQL

Batch processing & scheduling

Agile SCRUM

Stakeholder engagement

Requirements translation

Tools

SSIS

IBM DataStage

Informatica

ODI

Job description

Our client is looking for an experienced and driven professional with a demonstrated history of delivering enterprise-scale data warehouse solutions that support contemporary Business Intelligence practices. The role collaborates closely with both business partners and technology teams to shape requirements, design scalable solutions, and provide valuable insights in an agile delivery environment.

This position involves creating and maintaining reliable data structures, data integration workflows, and analytical reporting capabilities across multiple business areas. The ideal candidate will display strong problem-solving skills, flexibility, and the ability to quickly understand complex business processes and data needs.

Responsibilities

• Champion BI and Data Warehouse architecture
• Promote data quality, integrity, and reliability within BI solutions
• Contribute to and participate in architectural forums
• Data modelling (dimensional, multidimensional, and relational)
• Design and implement ETL architecture
• Process automation and architectural design
• PL/SQL development and optimization
• Report development and support
• Promote and enable self-service BI
• IT and business process optimization
• Data integration across legacy and modern systems
• Collaborate with business users to gather and define requirements
• Develop ad-hoc scripts to support analytical queries
• Batch processing support and scheduling
• Agile documentation

Qualifications & Experience

• Minimum 5 years experience in Data Warehousing and/or ETL development
• Strong architectural mindset
• Data and report modelling expertise
• Batch processing and scheduling experience
• Strong stakeholder engagement and relationship management
• Experience translating business requirements into technical specifications
• Enterprise Data Warehousing (Kimball methodology)
• ETL tools (SSIS, IBM DataStage, Informatica, ODI, or similar)
• PL/SQL or T-SQL scripting and optimization
• Agile delivery experience (SCRUM)

The Reference Number for this position is NG60971 which is a Permanent Hybrid position based in Western Cape offering a cost to company of up to R800k CTC negotiable on experience and ability. Contact Nokuthula at [email protected] or call her on 011 463 3633 to discuss this and other opportunities.