Junior Data Analyst

The Focus Group; Johannesburg; Hybrid; ZAR 200,000 - 300,000; Full time

Job summary

A leading insurance company is looking for a Junior Data Analyst to support their business intelligence and reporting team. The ideal candidate will have experience with Power BI, SQL, and will work collaboratively to maintain and enhance reporting tools. This role is perfect for detail-oriented individuals who enjoy teamwork and learning in a dynamic environment.

Qualifications

• 1–2 years’ experience in a reporting or data analysis environment.
• Solid understanding of Power BI and basic data modelling concepts.
• Basic to intermediate SQL knowledge.
• Proficiency in Excel for data analysis tasks.

Responsibilities

• Maintain and update existing reports and dashboards in Power BI.
• Assist with data extractions and execute defined SQL queries.
• Perform data validation and reconciliations between reporting layers.
• Work closely with the analytics and engineering teams.
• Support documentation of reports and data definitions.

Skills

Power BI

SQL

Excel

Collaboration

Communication

Tools

Power BI

SQL

Job description

Employment Details

• Reports To: Chief Information Officer
• Employment Status: Full Time (with possibility of Hybrid)
• Location: Gauteng or Cape Town

Overview

Company Overview:
We are an exciting insurance company, with over 25 years of experience in nontraditional sectors, looking for a Junior Data Analyst to join our team. We are focused on client centricity and solving needs for South Africans with innovation, unique and creative solutions, and products.

Role Description

We are looking for a Junior Data Analyst to support the business intelligence and reporting team in an established company in the financial and insurance industry. The ideal candidate will assist with report maintenance, data quality checks, and documentation while gaining exposure to enterprise data tools and practices. This role is ideal for someone who enjoys working within a collaborative team environment and supporting the upkeep of business-critical reports.

Key Responsibilities, Duties, and Tasks

• Maintain and update existing reports and dashboards in Power BI to reflect evolving business requirements.
• Assist with data extractions and execute defined SQL queries.
• Perform data validation and reconciliations between reporting layers.
• Work closely with the analytics and engineering teams to resolve data discrepancies.
• Support documentation of reports, dashboards, and data definitions.
• Participate in data testing and user feedback processes.

Experience Required

• 1–2 years’ experience in a reporting or data analysis environment.
• Solid understanding of Power BI and basic data modelling concepts.
• Basic to intermediate SQL knowledge.
• Proficiency in Excel for data analysis tasks such as filtering, pivot tables, formulas, and formatting.

Non-Technical Skills

• Strong collaboration and ability to work as part of a team.
• Eager to learn and grow within a structured environment.
• Detail-oriented with good time management skills.
• Clear communicator, both written and verbal.