Data Analyst

SI HR; Centurion; On-site; ZAR 300,000 - 600,000; Full time

Job summary

A dynamic opportunity has arisen for a Data Engineer at a leading company based in Centurion. You will be responsible for designing and maintaining database architectures, building ETL pipelines, and supporting reporting needs. Candidates should have at least three years of experience in data engineering, with strong skills in MS SQL, ETL development, and data modeling.

Qualifications

• Three years of experience in data engineering or related field.
• Understanding of data modelling and data warehouse design.
• Ability to create entity relationship diagrams (ERDs).

Responsibilities

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

Skills

Data modelling

ETL pipeline development

Database knowledge

Teamwork

Resilience

Education

Diploma / Degree in Information Systems

Tools

MS SQL

SSMS

NoSQL

SSIS

Python

R

Power BI

Job description

Position available for a Data Engineer based in Centurion. The purpose of the position is to :

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

MINIMUM 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 :

Position available for a Data Engineer based in Centurion. The purpose of the position is to :

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

MINIMUM 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

RESPONSIBILITIES :

Data set development :

Understanding of data requirements

Knowledge of database structure and where relevant data resides

Envision optimal structure for reporting

Data warehousing appropriate to report requirements

Create and maintain ETL pipelines

Knowledge of current dataset portfolio

Ability to update / improve current data for various functions

Report development :

Understanding of report requirements

Appropriate report UI development

Documentation of report requirements and usage / explanation

Continuous feedback / communication and confirmation of report relevance

Knowledge of current reporting portfolio – ability to update / improve current reports for various functions

General and Task Management :

Ability to take ownership of a task until its resolution.

Engage with task owners to ensure the task has been completed in the desired way

Update and maintain the task lists or boards used to keep track of tasks

Consult or brainstorm on issue items where necessary

Participate in planning for the future discussions

Understanding infrastructure required for company systems

Advanced working knowledge of different data bases within the company

Learn a skill the company needs to accomplish a task

Project management

Self-Management :

Support, comply and ensure compliance with the Health and Safety regulations, all the Companies policies and procedures, Quality and Environmental policies and procedures, etc.

Support, encourage team members

Proactively contribute to creating a good team atmosphere

Anticipate and overcome obstacles

Embrace personal challenges and growth

Self-awareness

Resilient, optimistic, and open to change

Have an adult, collaborative approach to others

Self-starter, motivated and able to positively motivate others

Focused and target driven with positive, can-do attitude

Create a job alert for this search