Business Analyst (Employee benefits)

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

Job summary

A consulting firm in Sandton seeks a detail-oriented Business Analyst to support healthcare and retirement consulting teams. The role involves data analysis, trend reporting, and benchmarking. Candidates should possess a degree in Business Analytics or related fields, and 2-4 years of relevant experience. Responsibilities include building models in Excel and preparing PowerPoint reports. Strong analytical skills and advanced Excel proficiency are required. This is a key internal support role without client-facing duties.

Qualifications

• 2–4+ years experience in data analytics, business analysis or a similar analytical role.
• Understanding of retirement funds and healthcare plans is a strong advantage.

Responsibilities

• Analyse retirement fund, benefits and healthcare data to identify trends.
• Build and maintain advanced Excel models, including dashboards and forecasting tools.
• Prepare clear PowerPoint reports for internal use and presentations.
• Support consulting teams with market research and industry insights.
• Collaborate closely with consultants to understand requirements.

Skills

Advanced Excel skills

Analytical thinking

Strong PowerPoint skills

Data extraction and manipulation

Attention to detail

Education

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

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.