Senior Data Engineer

Hr On Site; Gauteng; On-site; ZAR 600 000 - 900 000; Full time

Job summary

A technology service provider in South Africa seeks a Data Engineer to design and maintain data solutions. The ideal candidate will have a bachelor's degree and at least 5 years of experience in data engineering, particularly in cloud environments like Azure. Responsibilities include developing data pipelines and optimizing data architectures. Candidates with skills in SQL, ETL processes, and various DBMS are encouraged to apply for this vital role.

Qualifications

• Bachelor's degree with a focus on data management.
• Minimum 5 years of experience as a data engineer.
• Advanced proficiency in SQL and query optimization.

Responsibilities

• Design, develop, schedule, and monitor data pipelines.
• Produce ad-hoc queries and develop reports.
• Engage with business representatives regarding data initiatives.

Skills

Data pipeline design and development

SQL proficiency

Data processing engines

Data management principles

ETL implementation

Education

Bachelor's degree in Information Systems or similar

Tools

SSIS

Azure Data Factory

Talend

Informatica

Job description

Role Overview

The role operates within a cross-functional, agile development team working across various technologies.

The key responsibilities of this role will focus on creating and maintaining data solutions, including development activities such as the implementation of ETL processes, the creation of reports, and ensuring high levels of data availability and integrity.

We are seeking an energetic and committed individual who is a self-starter and works well independently as well as within a team context.

Your knowledge of and experience in this area, together with your ability to learn new technologies, will be invaluable to ensure progress and the successful implementation of these solutions.

Duties & Responsibilities

• Design, develop, schedule, deploy, and monitor data pipelines
• Optimize, improve, and validate data pipelines
• Design and deploy data table structures, forms, reports, and queries
• Produce ad-hoc queries and develop reports to support business needs
• Develop security-aware cloud data solutions
• Process data into various storage formats such as Parquet, JSON, Avro
• Apply appropriate engines to data processing such as Graph, Relational, NoSQL
• Create and maintain technical documentation
• Help inform and drive data architecture initiatives and strategies
• Engage with business representatives regarding data solution initiatives

Desired Experience & Qualifications

• Bachelor's degree with a focus on data management (e.g. Information Systems, Statistics, Data Engineering)
• A minimum of 5 years' experience working as a data engineer utilizing visual pipeline designers such as SSIS, Talend, Informatica, or Azure Data Factory
• A minimum of 2 years of data engineering in a commercial cloud environment like Azure
• Advanced proficiency in SQL; SQL query optimization skills
• Experience in at least two DBMS's such as Postgres, MySQL, or MSSQL
• Experience in loading data from diverse sources
• Experience in the development, implementation, and monitoring of ETL processes
• Experience in database administration, maintenance, and optimization
• A sound understanding of data management principles including data quality assurance and data governance
• Experience in source code and version control systems
• Experience in master data management and its implementation and maintenance
• Experience in Azure data technologies, database administration, Bash or PowerShell scripting, and data engineering certifications from Google, Azure, or AWS is advantageous
• Demonstrated interest in the claims and healthcare IT space

Interested?

We encourage all candidates to read through the job description clearly and properly before applying and submitting your CV for perusal.

We appreciate all submissions and will reply to each one as soon as possible.