Job Description

To lead the design, development, and governance of the company's enterprise data infrastructure, transitioning from the current SSIS-based ETL environment to a modern, scalable, Azure-based cloud data warehouse.
This role is strategic and collaborative, requiring close engagement with business leaders, BI developers, analysts, and IT teams to ensure data solutions are business-aligned, governance-compliant, and ready for advanced analytics.
As a senior member of the team, the role will mentor junior data engineers, influence architectural decisions, and champion best practices across the organisation.
Key Performance Areas (Core, essential responsibilities -outputs of the position)
1.
Data Warehouse Architecture & Leadership

Lead the architectural design and implementation of the new Azure-based data warehouse.

Oversee the optimisation of the existing SSIS-based ETL environment during the transition phase.

Establish long-term data platform strategy in collaboration with BI and IT leadership.
2.
Data Governance & Compliance

Own the data governance framework, ensuring standards for data quality, security, lineage, and access control are embedded in all solutions.

Partner with compliance and legal teams to meet regulatory requirements for data storage and processing.

Champion the use of data cataloguing and metadata management tools.
3.
Collaboration & Stakeholder Engagement

Work directly with senior stakeholders across business units to translate needs into actionable technical solutions.

Serve as the primary point of contact between the BI team, engineering, and external vendors for data infrastructure matters.

Facilitate workshops, architectural reviews, and cross-team solution design sessions.
4.
Technical Delivery & Mentorship

Lead the build, testing, and deployment of robust ETL/ELT pipelines for multi-source integration.

Ensure smooth migration of historical and real-time data to the new warehouse with minimal downtime.

Mentor and support junior and mid-level engineers in technical best practices and solution delivery.
5.
Performance Monitoring & Continuous Improvement

Implement platform monitoring solutions to track and optimise performance.

Drive continuous improvement in architecture, tooling, and governance processes.
Company Description
A healthcare company dedicated to improving lives through innovative pharmaceutical solutions and a fast-growing pharmaceutical company in South Africa, committed to delivering high-quality medications that meet pressing patient needs. They're governed by principles of honesty, integrity, and a passion for customers.

Skills Required