Data Engineer

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

Qualifications and or Experience:

• Three years of experience in data engineering or related field

• MS SQL and SSMS

• No

SQL

• 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 entity relationship diagrams (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