Junior Data Analyst

KPMG South Africa; Johannesburg; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading consulting firm in South Africa is seeking a Junior Data Analyst who will collaborate with a team to perform ETL processes, ensuring data quality and developing data models for analytics. The ideal candidate should have a Senior Certificate, skills in SQL, and a strong analytical mindset. This position offers opportunities for professional growth in a dynamic environment.

Qualifications

• Proficient in using MS Office suite.
• Data and/or analytics-related certification/degree in engineering/mathematics and/or computer science is beneficial.
• Basic understanding of data management concepts.

Responsibilities

• Collaborate with a team to perform ETL of data from various sources.
• Troubleshoot and debug ETL components including SQL stored procedures.
• Provide quality assurance over imported data.
• Design and develop data models for analytics purposes.
• Create and interpret data visualizations.

Skills

Analytical mind

Problem-solving

Attention to detail

Team player

Education

Senior Certificate with matric exemption

Tools

MS SQL Server

T-SQL

Alteryx

Power BI

Power Query

Azure Data Studio

Job description

Title: Junior Data Analyst

Business Unit: Clara Analytics National

Reporting to: Head of Data & Analytics – Ruan van Rooyen

Purpose Of The Job

The Junior Data Analyst will work collaboratively with a team to assist the Data & Analytics Centre in executing the ETL (Extract, Transform, Load) process of data. This process involves extracting data from various sources, transforming it to fit operational needs, and loading it into the end target. The role aims to develop data models for analytics and communicate the results to Audit teams, thereby enhancing audit quality.

Key Job Duties Or Responsibilities

• Collaborate with a team to perform the Extraction, Transformation, and Loading (ETL) of data from various sources.
• Troubleshooting and debugging of ETL components used including SQL stored procedures to resolve ETL errors.
• Provide quality assurance over imported data and implement data quality checks and balances.
• Design and develop data models for analytics purposes.
• Querying data sets with T-SQL.
• Create and interpret data visualisations.
• Provide basic operational support for Data and Analytics solutions including database administration, database backup and restore.
• Document working papers to document the processes followed to perform ETL, data quality assurance and data analytics results.

Critical Interpersonal Or Interactive Skills

• A self-starter and take initiative.
• An analytical mind and inclination for problem-solving.
• Attention to detail.
• Ability to work under pressure and meet deadlines.
• Team player with good interpersonal skills.
• Ability to communicate complex data insights in a clear and understandable manner to non-technical stakeholders.
• Willingness to continuously learn and stay updated with the latest trends and best practices in data analysis.
• The ability to manage multiple tasks and projects simultaneously and deliver results in a timely manner.

Minimum Required Qualifications And Experience

Senior Certificate with matric exemption.

Proficient in using MS Office suite.

Beneficial Qualifications And Experience

• Data and/ or analytics-related certification/ degree in engineering/ mathematics and/or computer science.
• Understanding of MS SQL Server and T-SQL language, Alteryx, Power BI, and Power Query.
• Experience using Azure Data Studio in the ETL process.
• Certifications related to MS SQL Server and/ or Alteryx.
• Basic understanding of data management concepts, to allow for information lifecycle management.