Intermediate BI/ Data Warehouse Developer

A leading retail client is seeking a dynamic Data Architect with a proven track record in designing and implementing enterprise-level data warehouses that meet modern Business Intelligence standards. This role collaborates closely with stakeholders and technical teams to define, design, and deliver actionable insights in an agile, fast-paced environment. The successful candidate will be responsible for developing robust data models, ETL processes, and reporting solutions that support multiple business units, while demonstrating strong analytical thinking, adaptability, and the ability to quickly grasp new business concepts.

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 and 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 NG60972 which is a Permanent Hybrid position based in the Western Cape offering a cost to company of up to R700k CTC negotiable on experience and ability. Contact Nokuthula at nokuthulag@ e-merge.co.za or call her on 011 463 3633 to discuss this and other opportunities.

Are you ready for a change of scenery? E-Merge IT recruitment is a specialist niche recruitment agency. We offer our candidates options so that we can successfully place the right developers with the right companies in the right roles. Check out the E-Merge website www.e-merge.co.za for more great positions.

Do you have a friend who is a developer or technology specialist? We pay cash for successful referrals!

Posted on 07 May 09:44, Closing date 6 Jul