Data Analyst

HR Genie; Centurion; On-site; ZAR 500,000 - 800,000; Full time

Job summary

A leading company is seeking a Data Engineer in Centurion to design and maintain robust reporting architectures and ETL pipelines. The role requires a minimum of three years' experience in data engineering, with a strong focus on SQL, data modeling, and collaboration. Applicants should be proactive, with a background in Information Systems, and be ready to contribute to a dynamic team environment.

Qualifications

• Three years of experience in data engineering or related field required.
• Strong understanding of data modeling and database structures.
• Ability to create entity relationship diagrams (ERDs).

Responsibilities

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

Skills

Data Modelling

SQL

ETL Development

Data Warehouse Design

Python

R

Power BI

NoSQL

Education

Diploma / Degree in Information Systems or related field

Tools

MS SQL

SSMS

SSIS

Microsoft 365

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: 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 databases within the company
• Learn a skill the company needs to accomplish a task
• Project management

Self-Management :

• Support, comply and ensure compliance with health and safety regulations, company policies, quality and environmental policies
• Support and encourage team members
• Contribute proactively to creating a positive team atmosphere
• Anticipate and overcome obstacles
• Embrace personal challenges and growth
• Maintain self-awareness
• Be resilient, optimistic, and open to change
• Maintain a collaborative approach to others
• Be a self-starter, motivated, and able to motivate others
• Be focused and target-driven with a positive, can-do attitude