About this role
We are looking for a Data Engineer to design and maintain scalable data solutions that support applications, reporting and analytics. The role includes developing data pipelines, contributing to data architecture and supporting data engineering projects.
-
Translate business requirements into data solutions, reports and dashboards.
-
Design, develop and maintain ETL processes and data pipelines using Azure Data Factory.
-
Build and manage data warehouses and data models, including facts, dimensions and relational structures.
-
Write complex SQL and T-SQL queries, views and stored procedures.
-
Develop Power BI reports, dashboards and semantic models using DAX.
-
Integrate data across legacy and modern systems, and automate batch processing and scheduled tasks.
-
Deploy and manage data solutions on Azure.
-
Monitor and optimise data solutions for performance, reliability, scalability and cost.
-
Troubleshoot data issues and provide support for existing BI solutions.
-
Maintain technical documentation and participate in architecture, design and code reviews.
-
Contribute to modernising data platforms and support relevant Azure and AI initiatives.
Requirements
-
Qualifications and experience
-
Matric is essential.
-
A degree in Computer Science, Engineering, Mathematics or a related field, or at least 10 years of relevant experience in place of a degree.
-
Approximately 4–5 years of relevant experience. A postgraduate qualification with a relevant practical component may substitute for some experience.
-
Technical skills
-
Data pipeline and ETL development, including Azure Data Factory.
-
Data warehousing, including dimensional, multidimensional and relational modelling.
-
Advanced SQL and T-SQL, including joins, views and stored procedures.
-
Power BI, including dashboards, semantic models, DAX and cubes.
-
Azure cloud solutions and integration between on-premise, legacy and modern systems.
-
Process automation, batch processing and scheduling.
Benefits
- Hybrid working option