Position Details

Type Full-Time

Experience mid

Exp. Years 3-5 years

Education Bachelor's degree in Business Administration, Finance, or a closely related field; or Master's degree in these fields

Category Data & Analytics

About this role

Partner with business teams to design and implement analytics-driven data solutions across the insurance business. Build value-based analytics, data integration, dashboards, and reports to meet evolving business demands.

Key Responsibilities

Develops complex analytics solutions for quality, business process functionality, or strategic initiatives
Collaborates with cross-functional teams to identify analytics requirements
Liaises between IT, data science/R&D and Product Management for analytics models and data solutions
Develops and implements enterprise-wide data integration strategies using data marts and data warehouse applications
Creates detailed documentation and business plans; develops dashboards and reports to meet business demands

Technical Overview

Focus on analytics and data solutions using SQL, Excel, and Power BI; work with data warehouses/marts and liaise with IT and data science; support UAT and testing.

Ideal Candidate

The ideal candidate is a mid-level data analytics professional with 3+ years of experience in the P&C insurance domain, strong SQL, Excel, and Power BI capabilities, and a proven ability to translate business needs into analytics solutions.

Must-Have Skills

P&C insurance experienceSQLPivot TablesData ValidationWhat-If AnalysisScenario AnalysesExcel Data Management ToolsData TablesNested FormulasArray FormulasPower BI Dashboards

Nice-to-Have Skills

Data governanceData modelingETL processesAdvanced Excel (macros)Additional BI toolsSQL optimizationProject management

Tools & Platforms

Power BIMicrosoft ExcelMicrosoft Office

Required Skills

SQLPivot TablesData ValidationWhat-If AnalysisScenario AnalysesExcelMicrosoft ExcelMicrosoft OfficePower BIPower BI DashboardsData CleaningData TablesNested FormulasArray FormulasP&C insuranceInsurance industryData AnalyticsData Management Tools

Hard Skills

SQLStructured Query LanguagePivot TablesData ValidationWhat-If AnalysisScenario AnalysesMicrosoft ExcelMicrosoft OfficePower BIPower BI DashboardsData CleaningData TablesNested FormulasArray Formulas

Soft Skills

communicationstakeholder managementcollaborationproblem-solvingattention to detailanalytical thinkingtime managementdocumentation

Industry & Role

Industry Insurance

Job Function Partner with business teams to design and implement analytics-driven data solutions that enable business outcomes.

Role Subtype Business Analyst

Tech Domains Power BI, SQL / PostgreSQL

Keywords for Your Resume

P&C insuranceSQLPower BIPower BI DashboardsPivot TablesData ValidationWhat-If AnalysisScenario AnalysesExcelData TablesMicrosoft ExcelMicrosoft OfficeData CleaningData Management ToolsP&C Insurance ExperienceBusiness Solutions AnalystHybridWoodland HillsCA

Deal Breakers

No P&C insurance experience, No SQL experience, No degree in related field

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile