Data Engineer
Posted Updated 1
view
Description
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