Junior Data Analyst

Krutham; Johannesburg; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A mission-driven research and consulting firm in Sandton is seeking a Junior Data Analyst. Ideal for a recent graduate or early-career professional, the role emphasizes data handling, analysis, and generating insights to support business strategies. Strong Excel skills and a BCom in IT, Data Science, or a related field are required. Join a collaborative team committed to social impact and professional growth.

Benefits

Collaborative work environment

Professional growth support

Qualifications

• Strong Excel skills including pivot tables, VLOOKUP/XLOOKUP, and chart creation.
• Basic understanding of data management principles.
• Exposure to research methodologies is a plus.

Responsibilities

• Prepare, clean, and manage datasets for research projects.
• Conduct data analysis and generate insights to support business decisions.
• Create, update, and maintain reports and dashboards primarily in Excel.

Skills

Advanced Excel skills

Problem-solving skills

Attention to detail

Eagerness to learn

Education

BCom in IT, Data Science, Statistics, or related field

Tools

Excel

Power BI

Tableau

Python

SQL

Job description

We are seeking a Junior Data Analyst to join our team, ideal for a recent graduate or early-career professional looking to grow their expertise in data management and research. This role focuses on data handling, analysis, and insights that inform strategy and decision-making, with a strong emphasis on advanced Excel skills.

Key Responsibilities:

• Prepare, clean, and manage datasets for research projects.
• Collect, clean, and organise datasets from various sources.
• Conduct data analysis and generate meaningful insights to support business decisions.
• Generate graphs and other meaningful insights based on the data including written explanations
• Create, update, and maintain reports, dashboards, and tracking tools (primarily in Excel, with exposure to other tools).
• Support business units with ad-hoc data queries and reporting needs.
• Support researchers with quantitative elements of studies.
• Ensure data quality, accuracy, and documentation.
• Collaborate with project teams to align data work with research objectives.
• Collaborate with cross-functional teams to improve data processes.

Requirements:

• BCom in IT, Data Science, Statistics, or related field (Undergraduate or Honours).
• Strong Excel skills (pivot tables, VLOOKUP/XLOOKUP, formulas, charts).
• Basic understanding of data management principles.
• Strong problem-solving skills and attention to detail.
• Eagerness to learn and adapt in a fast-paced environment.

Preferred (but not essential):

• Exposure to research methodologies.
• Exposure to data visualisation tools (Power BI, Tableau, etc.).
• Experience or coursework in basic programming (Python, SQL).

Why Krutham?

Krutham is a mission-driven research and consulting business focused on solving complex challenges in financial markets, development, and policy. We work with investors, financial institutions, and policymakers to generate high-impact outcomes in South Africa and other emerging markets. We are widely recognised for the quality of our work and the calibre of our team.

Our head office is in Sandton, and this role will be based there. You will be joining a high-performance team committed to social impact, and you will work closely with colleagues holding MBAs, CA and CFA designations, and PhDs.

We offer a collaborative, entrepreneurial environment where your contributions will be valued and your professional growth supported.

Interested?

Please submit a cover letter and CV. Applications close 26 August 2025, though the role may be filled sooner if the right candidate is identified.