Senior Datawarehousing Developer ( ETL / BI / 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

Job Description

Join a large, data-rich organisation where business intelligence is at the heart of decision-making. As a Senior BI/DW Developer, you'll play a key role in shaping enterprise data solutions, developing scalable data warehouses, and delivering reporting capabilities that support multiple business functions. You'll work across modern and legacy environments, helping drive the evolution of the organisation's BI landscape while partnering closely with both business and technology stakeholders. If you enjoy data modelling, ETL development, architecture discussions and solving complex business problems through data, this is an opportunity to make a meaningful impact.

YOUR KEY 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

OUR REQUIRED EXPERTISE

• 5+ years' experience within Data Warehousing, Business Intelligence 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

TECHNICAL EXPERTISE

• Enterprise Data Warehousing and Data Modelling
• ETL tools (SSIS, DataStage, Informatica, ODI or similar)
• PL/SQL and/or T-SQL development
• Oracle and SQL Server environments
• Power BI, SSRS, SSAS or similar reporting tools
• Data integration and process automation
• Control-M or batch scheduling tools
• Large-scale transactional data environments
• Oracle APEX, Power Apps or similar low-code platforms
• Real-time data processing and streaming technologies

YOUR REWARD

• Competitive salary and benefits package
• Hybrid working environment (3 days in office p/w)
• Exposure to large-scale enterprise data platforms
• Opportunity to influence architecture and modernisation initiatives
• Collaborative and technically mature team
• Long-term career growth and stability

For more roles, please have a look at our website (www.60degrees.com) or follow us on LinkedIn (https://www.linkedin.com/company/10287263/)