Senior BI & Data Warehouse Architect (Hybrid)

ATS Client; Cape Town; Hybrid; 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

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.