Job Description

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 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.
Key Responsibilities, Duties, and Tasks:

• 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.

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.

Skills Required