Senior BI & Data Warehouse Developer - Hybrid ETL/Oracle

ATS Client; Cape Town; On-site; ZAR 600,000 - 900,000; Full time

Job summary

ATS Client in Cape Town is seeking a Senior BI/DW Developer to shape enterprise data solutions, build scalable data warehouses and deliver reporting that supports multiple business functions. You will work across modern and legacy environments, driving data modelling, ETL development and BI architecture discussions, and partnering with business and technology stakeholders.

If you enjoy solving complex data problems and shaping BI strategy, this role offers a meaningful opportunity with long-term

Qualifications

• 5+ years of experience in Data Warehousing, BI or ETL environments.
• Strong data modelling and reporting experience.
• Experience building enterprise BI and data warehouse solutions.
• Strong stakeholder engagement and requirements gathering capability.
• Architectural mindset with a passion for scalable data solutions.
• Agile/Scrum experience.

Responsibilities

• Design, develop and maintain enterprise data warehouse solutions
• Build and optimise ETL processes and data integration services
• Develop dimensional, relational and multidimensional data models
• Translate business requirements into scalable BI solutions
• Champion data quality, integrity and reliability
• Develop reporting and self-service BI capabilities
• Support batch processing, scheduling and operational BI environments
• Collaborate with business users to define requirements and deliver insights
• Contribute to BI architecture, technical reviews and modernisation initiative

Skills

Data modelling

5+ years BI/DW/ETL

Reporting experience

Stakeholder engagement

Agile/Scrum

Data warehouse design

ETL development

Tools

SSIS

DataStage

Informatica

ODI

PL/SQL

T-SQL

Oracle

SQL Server

Power BI

SSRS

SSAS

Control-M

Job description

ATS Client in Cape Town is seeking a Senior BI/DW Developer to shape enterprise data solutions, build scalable data warehouses and deliver reporting that supports multiple business functions. You will work across modern and legacy environments, driving data modelling, ETL development and BI architecture discussions, and partnering with business and technology stakeholders.

If you enjoy solving complex data problems and shaping BI strategy, this role offers a meaningful opportunity with long-term