Job description

Job Title: Power BI Developer / Data Analyst P&C Insurance Location: Hybrid in Warren New Jersey Type: Contract Duration: 6 Job Summary We are seeking a highly skilled Power BI Developer / Data Analyst with hands-on experience in data visualization, analytics, and reporting within the Property & Casualty (P&C) insurance domain. The ideal candidate will design, develop, and maintain insightful Power BI dashboards and reports to support underwriting, claims, actuarial, and financial analysis functions. Key Responsibilities • Design and develop interactive Power BI dashboards and reports using DAX, Power Query, and data modeling best practices. • Collaborate with business users from P&C lines (Underwriting, Claims, Policy Admin, Actuarial, Finance) to understand KPIs, data requirements, and analytical objectives. • Connect and integrate data from multiple sources such as SQL Server, Azure Data Lake, Guidewire, Duck Creek, Data Warehouse systems, or policy admin systems. • Develop and optimize data models, measures, and calculations for performance and usability. • Implement row-level security, data refresh automation, and governance standards within Power BI Service. • Support data validation, reconciliation, and data quality initiatives. • Work closely with data engineering teams to improve ETL pipelines feeding Power BI datasets. • Document report logic, data lineage, and ensure version control for deliverables. Required Qualifications • 5+ years of experience in data analytics, business intelligence, or reporting. • 3+ years of hands-on experience with Power BI (Desktop & Service). • Strong command of DAX, Power Query (M), and Data Modeling principles. • Experience with P&C insurance data domains such as policy, claims, premiums, losses, exposures, reinsurance, etc. • Familiarity with insurance systems like Guidewire, Duck Creek, or equivalent policy/claims systems. • Strong SQL querying and performance tuning skills. • Experience with ETL / data preparation tools (e.g., Azure Data Factory, SSIS, Databricks). • Excellent communication skills and ability to translate business questions into analytical insights. Preferred Qualifications • Experience with Azure Synapse / Snowflake / Databricks or similar cloud-based data platforms. • Understanding of loss triangles, incurred vs. paid claims, earned premium metrics, or other insurance actuarial measures. • Experience with data governance / Power BI administration. • Prior experience in a consulting or analytics COE (Center of Excellence) environment. Flexible work from home options available.

Requirements