Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ingestion frameworks to support enterprise reporting and analytics needs.
- Integrate and consolidate data from a wide range of SaaS applications, operational systems, and external data sources.
- Transform and model raw data into high-quality, business-ready datasets that enable accurate reporting and data-driven decision-making.
- Architect, implement, and manage Lakehouse and Data Warehouse solutions within Microsoft Fabric.
- Develop robust semantic models and curated datasets that serve as the foundation for Power BI reporting and analytics.
- Collaborate closely with business stakeholders to gather requirements, define key metrics and KPIs, and translate business needs into scalable data solutions.
- Identify, investigate, and resolve data quality, integrity, reconciliation, and consistency issues across multiple systems.
- Provide technical leadership and make sound architectural decisions to ensure scalable, maintainable, and future-proof solutions.
- Monitor, troubleshoot, and optimise data pipelines to improve performance, reliability, and operational efficiency.
- Champion best practices in data engineering, governance, modelling, security, and analytics architecture.
Required Qualifications & Experience
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent practical experience.
- 57 years of hands-on experience in Data Engineering, Analytics Engineering, or similar data-focused roles.
- Proven experience delivering production-grade solutions using Microsoft Fabric, including Lakehouse, Warehouse, Dataflows, Pipelines, and Semantic Models.
- Advanced SQL skills, including query optimisation, performance tuning, and dimensional data modelling.
- Strong Python development experience for data transformation, automation, orchestration, and systems integration.
- Solid understanding of modern data platform architectures, including Data Warehousing and Lakehouse methodologies.
- Experience integrating and managing data from REST APIs, SaaS applications, and third-party systems.
- Hands-on experience designing and consuming semantic models within Power BI environments.
- Proficiency with Git-based source control and CI/CD practices for data and analytics projects.
- Strong analytical and problem-solving abilities, with exceptional attention to detail.
- Excellent communication and stakeholder management skills, with the ability to translate business requirements into technical solutions and clearly articulate design trade-offs.
- Comfortable working independently in fast-moving environments, navigating ambiguity, and balancing technical excellence with practical delivery outcomes.
Preferred Experience
- Exposure to Azure Data Factory, Azure Synapse Analytics, and/or Databricks.
- Experience implementing data quality, observability, monitoring, and reconciliation frameworks.
- Familiarity with operational SaaS platforms such as Zendesk, HubSpot, Zoho, Intercom, Aircall, or similar customer service and CRM solutions.
- Knowledge of modern analytics engineering tools and practices, including dbt and related technologies.
- Interest or experience in AI-driven analytics, automation, and intelligent data workflows.
- Understanding of data governance, privacy, security, and compliance best practices within regulated environments.
Technology Environment
Data & Analytics Platform
- Microsoft Fabric (Lakehouse, Warehouse, Dataflows, Pipelines, Semantic Models)
Cloud & Data Services
- Azure Data Factory (Preferred)
- Azure Synapse Analytics (Preferred)
- Databricks (Preferred)
Development Languages
Reporting & Visualisation
Data Modelling
- Dimensional Modelling
- Lakehouse Architecture
- Semantic Modelling
Integration Technologies
- REST APIs
- SaaS Connectors (Zendesk, HubSpot, Zoho, Intercom, Aircall, and similar platforms)
DevOps & Collaboration
- Git
- GitHub
- CI/CD Pipelines
- VS Code
- Slack
What's on Offer
We provide a competitive remuneration package, flexible working arrangements, and a collaborative, low-ego culture that values continuous learning, innovation, and work-life balance. Team members benefit from ongoing professional development opportunities, including access to training and certification budgets to support career growth.
While Cape Town is the preferred location for this role, we are open to remote or hybrid working arrangements across South Africa for the right candidate. This position is ideally suited to a full-time professional, although contract-to-permanent opportunities may also be considered.
Apply now!