Data Analyst

SUMMARY:
Three years of experience in data engineering or related field. MS SQL, SSIS, ETL, Python, Power BI

POSITION INFO:

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