Senior Data Analyst

The Focus Group; Johannesburg; Hybrid; ZAR 600,000 - 900,000; Full time

Job summary

A leading insurance company is seeking a Senior Data Analyst to lead the reporting and data analysis team. The role involves maintaining reports, writing SQL queries, and collaborating with data engineers. Candidates should have at least 5 years of experience, proficiency in SQL and Power BI, and strong analytical skills. This position offers a full-time opportunity with potential for hybrid work.

Qualifications

• Minimum 5 years’ experience in data analysis or BI reporting roles.
• Strong experience in designing and maintaining data models.
• Excellent verbal and written communication skills.

Responsibilities

• Maintain and enhance existing reports and dashboards.
• Translate business needs into report specifications.
• Design and write advanced SQL queries.

Skills

SQL

DAX (Power BI)

Advanced Excel

Data quality validation

Collaboration

Tools

Power BI

Microsoft Fabric

Job description

Overview

Reports To: Chief Information Officer
Employment Status: Full Time (with possibility of Hybrid)
Location: Gauteng or Cape Town
Company Overview: We are an exciting insurance company, with over 25 years of experience in nontraditional sectors, looking for a Senior 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 seeking a highly experienced Senior Data Analyst to take the position as team lead for the reporting and data analysis team in an established company in the financial and insurance industry. The successful candidate will be responsible for interpreting business requirements, maintaining and enhancing existing reports, ensuring data quality, and delivering actionable insights through data models and dashboards. The role requires strong collaboration with data engineers, business users, and fellow analysts.

Responsibilities

• Maintain and enhance existing reports and dashboards to ensure continued accuracy and relevance.
• Translate business needs into report specifications and data requirements.
• Design and write advanced SQL queries across normalized and star-schema databases.
• Develop and maintain Power BI semantic models and reports (including embedded models).
• Collaborate with Data Engineers to ensure optimal data architecture and pipeline integrity.
• Validate data between layers (e.g., bronze, silver, gold) to ensure accuracy.
• Lead the implementation of data security rules, including Row-Level Security.
• Create and maintain exception-based reports and trend visualizations.
• Support user acceptance testing and provide training as needed.

Qualifications

• Experience: Minimum 5 years’ experience in data analysis or BI reporting roles; Proficient in SQL and DAX (Power BI). Strong experience in designing and maintaining data models and reporting environments. Familiarity with modern data platforms and concepts (e.g., data lakes, CI/CD, and modern data warehousing). Experience with Microsoft Fabric will be an advantage. Advanced Excel capabilities including pivot tables, lookup functions, Power Query, and data reconciliation. Experience with business rule documentation and data quality validation.
• Non-Technical Skills: Strong collaboration and teamwork abilities; Excellent verbal and written communication; Able to take initiative and work independently when needed; High attention to detail and strong analytical thinking; Adaptable and proactive in problem-solving.