Data Analyst

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