Data Engineer

Eastern Personnel Consultants / Oostelike Personeel Konsultante; Centurion; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A recruitment firm is seeking a Data Engineer to design, implement, and maintain reporting database architecture. Candidates should have a strong background in data engineering, with skills in SQL, ETL development, and data modelling. The position requires a minimum of three years of relevant experience and a degree in Information Systems or a related field. The ideal candidate will have excellent project management and communication skills, with the ability to work under pressure and meet deadlines.

Qualifications

• Three years of experience in data engineering or related field.
• Strong understanding of data modelling and data warehouse design.
• Ability to create entity relationship diagrams (ERDs).
• Exposure to cloud platforms is an added advantage.

Responsibilities

• Design, implement, and maintain the reporting database architecture.
• Build and optimize ETL pipelines.
• Develop and maintain semantic models.
• Support business projects through reporting.

Skills

Data Engineering

Project management

Good communication skills

Analytical skills

Education

Diploma / Degree in Information Systems or related field

Tools

MS SQL

SSIS

ETL pipeline development

NoSQL

Python

Power BI

Microsoft 365 suite

Job description

Overview

Job Purpose: Design, implement, and maintain the reporting database architecture; Build and optimize ETL pipelines; Develop and maintain semantic models; Support business projects through reporting.

Responsibilities

• Design, implement, and maintain the reporting database architecture
• Build and optimize ETL pipelines
• Develop and maintain semantic models
• Support business projects through reporting

Qualifications and Experience

• Three years of experience in data engineering or related field
• MS SQL and SSMS
• NoSQL
• SSIS and ETL pipeline development
• Diploma / Degree in Information Systems, computer science or related field
• Strong understanding of data modelling and data warehouse design
• Ability to create entity relationship diagrams (ERDs)
• Exposure to cloud platforms is an added advantage
• Microsoft 365 suite

Beneficial

• Python
• R (programming language)
• Power BI
• Microsoft Power Automate
• Microsoft Forms
• Microsoft Dataverse
• Working knowledge of other BI technologies

Skills, Knowledge and Attributes

• Project management skills
• Good communication skills
• Analytical skills (Information processing)
• Interpersonal skills
• Good understanding of IT infrastructure
• Good understanding of Microsoft applications and SQL Databases
• Experience with APIs
• Experience with data warehousing and architecture
• Ability to take ownership of a data problem or project from beginning to completion
• Excellent written, communication and presentation skills
• Excellent organizational and follow-up skills
• Competent in problem solving (problem analysis)
• Ability to create, update, and maintain technical documentation with an architectural focus, including ETL processes and ERDs
• Pay attention to detail
• Monitoring
• Record keeping and documentation
• Planned change control knowledge
• Ability to work in a team
• Ability to work under pressure
• Deadline orientated
• Apply company ISO policies relating to data
• Self-starter
• Intrinsic motivation
• Ability to work on their own without constant supervision
• Driven
• Teachable
• Open to feedback and to constructive criticism
• Confident in their area of knowledge
• Ability to make decisions
• Adapts well to change