Samaha Consulting
Data Engineer Backend
Data Engineer (Backend) at Samaha Consulting in Johannesburg: designs and builds ETL pipelines, reusable data products and reporting automation on the Azure data stack (Data Factory, Databricks, Fabric, Synapse, ADLS Gen2), with deep SQL Server/T-SQL work, REST API integrations, Data Vault/Kimball modelling, and Git/Azure DevOps CI/CD.
- Compensation
- Not disclosed
- Location
- Johannesburg, South Africa
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Must have
- Strong data engineering, ETL, integration and data product development experience using Azure Data Factory, Databricks, Fabric, Synapse Analytics and ADLS Gen2
- Proven ability to design, build and operationalise reusable data products (trusted, governed, consumable)
- Excellent SQL skills, including T-SQL, stored procedures, functions and optimisation
- Extensive experience with SQL Server and SSIS
- Hands-on experience integrating with REST APIs (authentication, pagination, error handling, performance optimisation)
- Experience building resilient ETL, orchestration and scheduled reporting automation
- Strong knowledge of data modelling methodologies including Data Vault 2.0 and dimensional (Kimball) modelling
- Experience building and maintaining Azure Analysis Services models (tabular and multidimensional)
- Strong non-functional design skills: monitoring, alerting, reconciliation, resilience, evidence capture, performance tuning
- Experience using source control (Git preferred) and CI/CD tooling such as Azure DevOps
- Understanding of deployment pipelines and infrastructure-as-code concepts
Full description
- Strong data engineering, ETL, integration and data product development experience using Azure Data Factory, Databricks, Fabric, Synapse Analytics and ADLS Gen2.
- Proven ability to design, build and operationalise reusable data products that provide trusted, governed and consumable data for analytics, reporting, controls and downstream platform use cases.
- Excellent SQL skills, including T-SQL, stored procedures, functions and optimisation.
- Extensive experience with SQL Server and SSIS.
- Hands-on experience integrating with REST APIs, including authentication, pagination, error handling and performance optimisation.
- Experience building resilient ETL, orchestration and scheduled reporting automation.
- Strong knowledge of data modelling methodologies including Data Vault 2.0 and dimensional (Kimball) modelling.
- Experience building and maintaining Azure Analysis Services models (tabular and multidimensional).
- Strong non-functional design skills: monitoring, alerting, reconciliation, resilience, evidence capture and performance tuning.
- Experience using source control (preferably Git) and CI/CD tooling such as Azure DevOps.
- Understanding and experience of deployment pipelines and infrastructure-as-code concepts.