Data Analyst at AIICO Insurance

Job Summary

• The Data Analyst role balances technical modeling skills with business-facing insight delivery.
• It requires designing and optimising BI models and SQL queries, while also working closely with executives and business units to translate requirements into scalable reporting solutions.
• The complexity lies in ensuring data is not only accurate and well-modeled but also presented in a way that drives decisions, making the role central to the organisation’s goal of embedding a data-driven culture.

Responsibilities

• Data Analysis & Insight Generation:Support with analysing diverse insurance datasets (claims, policies, production, renewals, payments) to uncover patterns, risks, and opportunities. Conduct root-cause analysis on challenges such as early policy surrenders, delayed claims, or low persistency, while also performing customer sentiment analysis to identify satisfaction drivers.
• Reporting & Visualization:Support with building and maintaining interactive Power BI dashboards and reports using DAX and Power Query/M Query, translating complex datasets into clear, actionable insights. Deliver periodic (monthly/quarterly) and ad-hoc reports to management with strong narratives behind the numbers.
• Strategic Business Impact:Support leadership with evidence-based recommendations that improve customer satisfaction, boost loyalty, reduce compliance risks, and enable data-driven decision-making across SBUs.
• Collaboration & Business Engagement:Partner with Claims, Underwriting, Customer Service, and Finance teams to address business needs, design KPIs, and provide guidance on interpreting dashboards and reports.
• Quality & Assurance:Uphold high data quality standards through validation and consistency checks, ensuring reliable insights that inform critical business actions. Continuously enhance reporting processes for greater clarity, efficiency, and business relevance.
• Culture Building:Champion data-driven culture by empowering teams to interpret and act on analytics, fostering an environment where decisions are guided by facts rather than guesswork.

Requirements

• HND / B.Sc Degree in Computer Science or any related discipline.
• Knowledge of SQL & Power BI is an added advantage
• Minimum of 1 - 2 years experience.