Business Analyst

MyCareerCraft; Sandton; On-site; ZAR 300 000 - 500 000; Full time

Job summary

A leading consulting firm based in Sandton is seeking a highly analytical and detail-oriented Business Analyst to support its healthcare and retirement consulting teams. This key internal role focuses on data analysis, trend reporting, and insights that enhance consulting outcomes. Responsibilities include analyzing data, building advanced Excel models, and preparing presentations. Candidates should have a relevant degree and 2–4 years of experience in a similar analytical role. Excellent Excel and analytical skills are essential, along with the ability to work independently.

Qualifications

• 2–4+ years experience in data analytics or business analysis, ideally within healthcare consulting.
• Experience with data extraction, cleaning and manipulation.
• Understanding of retirement funds and healthcare plans is a strong advantage.

Responsibilities

• Analyse retirement fund, benefits and healthcare data for trends.
• Build and maintain advanced Excel models.
• Prepare clear and concise PowerPoint reports.
• Support consulting teams with market research and insights.
• Extract, clean, and manipulate datasets from multiple sources.

Skills

Advanced Excel skills (VLOOKUP/XLOOKUP, pivot tables, Power Query, macros)

Strong PowerPoint skills

Analytical thinking and attention to detail

Education

Bachelor's degree in Business Analytics, Economics, Finance, Statistics, Actuarial Science

Job description

Experience & Qualifications

• Bachelors degree in Business Analytics, Economics, Finance, Statistics, Actuarial Science, or a related field.

• Graduate in mathematical related fields OR

• 2–4+ years experience in data analytics, business analysis or a similar analytical role, ideally within employee benefits, retirement funds, healthcare consulting or financial services.

• Advanced Excel skills (VLOOKUP/XLOOKUP, pivot tables, Power Query, macros desirable).

• Strong PowerPoint skills with a track record of creating executive-level presentations.

• Experience with data extraction, cleaning and manipulation.

• Excellent analytical thinking, attention to detail and ability to present data clearly.

• Understanding of retirement funds, healthcare plans and benchmarking is a strong advantage.

• Ability to work independently and manage multiple priorities.

Were looking for a highly analytical and detail-oriented Business Analyst to support our healthcare and retirement consulting teams. This is a key support role focused on data analysis, trend reporting, benchmarking and insights that help consulting and sales teams deliver stronger outcomes for clients. Youll work with large datasets, build models in Excel, prepare high-quality PowerPoint reports and contribute to research that informs recommendations. This is not a client-facing position, but rather a critical internal role that supports consultants with the data and analytics they need to succeed

Key Responsibilities

• Analyse retirement fund, benefits and healthcare data to identify trends, support benchmarking and inform strategic recommendations.

• Build and maintain advanced Excel models, including dashboards, data visualisations and forecasting tools.

• Prepare clear and concise PowerPoint reports for internal use and consultant presentations.

• Support the consulting teams with market research, competitor analysis and industry insights.

• Extract, clean and manipulate datasets from multiple sources to produce accurate analysis.

• Produce regular reporting on key metrics, trends and benchmarking results for use in consulting engagements.

• Collaborate closely with consultants to understand requirements and translate them into actionable analytics.

• Assist with ad-hoc analytical requests and special projects related to employee benefits and retirement fund performance.