Hybrid Enterprise BI & Data Warehouse Developer

ATS Client; Cape Town; Hybrid; ZAR 630,000 - 770,000; Full time

Job summary

ATS Client in Western Cape seeks a seasoned data warehouse professional to design, develop, and implement enterprise-grade BI solutions. You will partner with stakeholders and technical teams to deliver robust data models, ETL processes, and reporting services across multiple business units.

The role emphasizes strong analytical thinking, adaptability, and rapid understanding of business concepts within an agile environment.

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

Data Warehousing

ETL Development

SQL

Data Modelling

Stakeholder Engagement

Agile SCRUM

Batch Processing

Tools

SSIS

Informatica

IBM DataStage

ODI

Job description

ATS Client in Western Cape seeks a seasoned data warehouse professional to design, develop, and implement enterprise-grade BI solutions. You will partner with stakeholders and technical teams to deliver robust data models, ETL processes, and reporting services across multiple business units.

The role emphasizes strong analytical thinking, adaptability, and rapid understanding of business concepts within an agile environment.