Senior Consultant - P&C Insurance Insights and Reporting

EXL; Gurugram District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

EXL in India seeks a Senior Consultant for Property and Casualty Insights and Reporting to lead requirements, design, and delivery of advanced reporting for Claims. You will own the full Power BI lifecycle across 40+ live reports and partner with stakeholders to map an optimized insights roadmap.

The role demands 8+ years in data analytics or BI, deep insurance domain knowledge, strong stakeholder engagement, and a proven ability to translate complex needs into production-grade dashboards with

Qualifications

• Bachelor's degree or higher in Statistics, Data Science, CS, or related field.
• 8+ years in data analytics, BI, or claims reporting with end-to-end improvements.
• Deep insurance/claims domain knowledge including lifecycle, reserving, metrics.
• Hands-on Power BI across full lifecycle: DAX, modelling, deployment.
• Elicit requirements from senior stakeholders and translate to designs.
• Strong data governance, analytics design, and trustworthy outputs.
• Experience owning BI roadmaps or insight strategies (preferred).
• Independently challenge business constructs and set direction.
• Senior stakeholder engagement and data storytelling to drive actions.

Responsibilities

• Elicit and document requirements from senior Claims stakeholders.
• Define and own a target-state insights roadmap for reporting.
• Lead Power BI development across lifecycle for 40+ live reports.
• Act as senior reporting lead for Claims; manage expectations.
• Conduct structured business analysis to validate needs.
• Embed data governance across all reporting deliverables.
• Translate analytics into insight narratives and exec presentations.
• Collaborate with analysts to optimise workload and delivery.
• Support ad hoc requests and drive process improvements.
• Improve reporting processes, standards, and data quality.

Skills

Power BI

DAX

Data modelling

Data governance

Stakeholder engagement

Requirements elicitation

Storytelling with data

Project ownership

BI strategy

Education

Bachelor's degree or higher in Statistics, Data Science, Computer Science, Business Analytics, or related field

Tools

Power BI Desktop

Power BI Service

SQL

DAX

Job description

Job Description - Senior Consultant – Property and Casualty Insurance Insights and Reporting

Role & Responsibilities:

• Independently elicit and document requirements from senior Claims business stakeholders, translating complex business needs into precise, actionable reporting specifications.
• Define and own a target-state insights capability roadmap — identifying missing analytics, prioritising enhancements with the business, and mapping the path from current state to an optimal reporting solution.
• Deliver hands‑on Power BI development across the full lifecycle, from wireframing and rapid prototyping through to finalised, production-grade report builds and enhancements across an established suite of 40+ live reports.
• Act as the senior reporting lead and single credible partner for the Claims team, setting direction, managing expectations, and proactively driving delivery forward.
• Conduct structured business analysis sessions to challenge assumptions, ask probing questions, and distinguish true business needs from surface-level requests.
• Develop and maintain high-quality reporting standards, embedding data governance principles and output trustworthiness across all claims reporting deliverables.
• Translate analytical output into clear insight narratives and business presentations that enable the Claims function to make informed, data-driven decisions.
• Partner with technical analysts and BI developers to optimise workload distribution — leading requirements and stakeholder engagement while enabling hands‑on team members to focus on build delivery.
• Support medium-sized ad hoc reporting requests alongside the core roadmap programme, maintaining responsiveness to shifting business priorities.
• Contribute to continuous improvement of reporting processes, design standards, and data quality practices within the Claims reporting function.

Candidate Profile:

• Bachelor's degree or higher in Statistics, Data Science, Computer Science, Business Analytics, or a related field (Required).
• 8+ years of experience in data analytics, business intelligence, or claims reporting, with a demonstrated track record of leading reporting improvements end-to-end (Required).
• Deep insurance and claims domain knowledge, including familiarity with claims lifecycle, loss development, reserving, and operational claims metrics (Required).
• Hands‑on Power BI expertise across the full delivery lifecycle — DAX authoring, data modelling, wireframing, and production‑grade report development and deployment (Required).
• Proven ability to independently elicit requirements from senior business stakeholders, shape solutions, and translate complex needs into high‑quality reporting designs (Required).
• Strong data modelling, analytics design, and data governance skills, with a track record of ensuring reporting outputs are accurate, trustworthy, and fit for business decision‑making (Required).
• Experience defining and owning BI roadmaps or insight capability strategies in a consulting or senior individual contributor capacity (Strongly preferred).
• Demonstrated ability to work independently, challenge the business constructively, and set direction without close supervision in a high‑visibility environment (Required).
• Outstanding senior stakeholder engagement and communication skills — capable of building rapport with Claims leaders and storytelling with data in a way the business will act on (Required).
• Experience supporting or leading a mature Power BI environment with multiple reports in active production use across a business function (Preferred).
• Familiarity with data quality frameworks, reporting governance standards, and best‑practice BI development processes (Preferred).
• Strong project ownership and prioritisation skills — able to manage a programme roadmap alongside ongoing ad hoc requests with minimal oversight (Required).
• Prior experience in a consulting, managed services, or analytics delivery environment is advantageous (Preferred).