Azure Data Engineer — 12-Month On-Site (Sandton)

Watershed Consulting; Gauteng; On-site; ZAR 661,000 - 1,102,000; Full time

Job summary

Watershed Consulting is seeking 4 experienced Azure Data Engineers to join our client in Sandton, Johannesburg on a 12-month on-site contract. The role demands a minimum 7 years total IT experience with 3–4 years at expert level in Azure data engineering.

Responsibilities include designing scalable Azure data pipelines, T-SQL analysis, Python ETL in Databricks, and Data Vault 2.0 modeling. The engagement includes potential permanent openings with Zensar for top performers.

Qualifications

• Minimum 7 years total IT experience with 3–4 years in an Azure Data Engineer role at expert level.
• Demonstrated experience with Azure Data Factory, Azure Databricks, Azure Synapse Analytics and Azure Data Lake Storage Gen2.
• Excellent data analysis and exploration skills using T-SQL and advanced SQL programming.
• Proficiency in Python for ETL development and Databricks.
• Experience writing automated tests for data pipelines and validating data quality.
• Strong understanding of Data Vault 2.0 and Kimball dimensional modelling.
• Experience with Git, Azure DevOps and CI/CD deployment pipelines.
• Awareness of data governance tools such as Azure Purview and data policies.

Responsibilities

• Design, build and maintain scalable Azure-based data pipelines and ETL solutions.
• Perform data analysis and exploration using T-SQL to support requirements, profiling and troubleshooting.
• Develop ETL and data transformation code in Python, primarily using Azure Databricks.
• Implement and maintain automated tests for data pipelines to ensure data quality and reliability.
• Design and optimize data warehouse models using dimensional modelling and Data Vault 2.0.
• Ingest, store and process data using Azure Data Factory, Azure Databricks, Azure Synapse Analytics and Azure Data Lake Storage Gen2.
• Optimize performance and ensure robustness of ETL processes and data solutions.
• Use source control and Azure DevOps to manage code, CI/CD pipelines and deployments.
• Apply data governance tools and practices (for example, Azure Purview) and ensure compliance with data policies.
• Collaborate with stakeholders, document technical designs, and provide guidance to development and data teams.

Skills

Azure Data Factory

Azure Databricks

Azure Synapse Analytics

T-SQL

Python

Data Vault 2.0

Data warehousing

Git

CI/CD pipelines

Data governance

Azure Purview

Tools

Git

Azure DevOps

Job description

Watershed Consulting is seeking 4 experienced Azure Data Engineers to join our client in Sandton, Johannesburg on a 12-month on-site contract. The role demands a minimum 7 years total IT experience with 3–4 years at expert level in Azure data engineering.

Responsibilities include designing scalable Azure data pipelines, T-SQL analysis, Python ETL in Databricks, and Data Vault 2.0 modeling. The engagement includes potential permanent openings with Zensar for top performers.