OpeningsFirst
How it worksPricingLog in
OpeningsFirst › Jobs in the United States › Jobs in Chicago, Illinois › Data / BI Analyst jobs in Chicago, Illinois

Power BI / Insurance Analytics Developer

EXL (ExlService Holdings, Inc.) · exlservice.com
ChicagoMid level4–6 yrs
Apply on EXL (ExlService Holdings, Inc.)’s site
Posted 24 days ago. 19 more Data / BI Analyst jobs in Chicago, Illinois went up on company career pages this week. See the newer ones

Share this job on LinkedIn · X

Straight from the company’s own careers site.

The job in short

Building Power BI insurance analytics reports.

SQLSnowflakeDatabricksAzurePower BIInsuranceUnderwriting

Details

Found
23 d ago · posted 2026-10-23
Location
Chicago, Illinois

Full description

Power BI • Strong hands-on experience with Power BI Desktop and Power BI Service. • Strong knowledge of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and visualization best practices. • Experience building complex dashboards and executive or business reporting solutions. • Understanding of Power BI performance optimization and data model design. SQL and Data • Strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations. • Experience analyzing and reconciling data across multiple tables and data sources. • Good understanding of relational databases, dimensional modeling, and data warehousing concepts. • Ability to investigate data-quality issues and independently perform root-cause analysis. Insurance Analytics • Good understanding of insurance data and business processes, preferably within Property & Casualty insurance. • Familiarity with policy, coverage, exposure, premium, claims, losses, reserves, limits, deductibles, brokers or agents, and underwriting. • Ability to understand insurance KPIs and translate business questions into analytical reports and dashboards. • Experience working with policy, claims, underwriting, or premium-related datasets is preferred. • Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users. • Develop efficient DAX measures, calculated columns, KPIs, and data models to support analytical and reporting requirements. • Write and optimize complex SQL queries for data extraction, transformation, reconciliation, and analysis. • Analyze large datasets to identify business trends, data issues, and actionable insights. • Work with business stakeholders to understand requirements and translate them into reporting and analytical solutions. • Perform data validation, reconciliation, and root-cause analysis to ensure reporting accuracy and consistency. • Develop and maintain dimensional data models supporting reporting and analytics use cases. • Collaborate with data engineering, business, and analytics teams to integrate data from multiple source systems. • Apply insurance domain knowledge to interpret business data and develop meaningful KPIs and reporting solutions. • Support report performance optimization, production issues, enhancements, and ongoing reporting needs. • 4-6 years of overall experience in business intelligence, reporting, or data analytics. • Hands-on experience with Power BI and SQL in enterprise reporting environments. • Prior experience with an insurance carrier, broker, MGA, or insurance analytics organization is highly desirable. • Exposure to Azure, Snowflake, Databricks, or SQL Server would be an advantage. • Strong analytical thinking, problem-solving, and communication skills. • Ability to interact with business stakeholders and independently convert requirements into technical solutions.

Data / BI Analyst jobs in the United States · All EXL (ExlService Holdings, Inc.) jobs

Get jobs like this every morning

Jobs in India · Jobs in the US · Who’s hiring in India · Who’s hiring in the US · Browse all jobs · Companies · How OpeningsFirst works · Free jobs widget · Leadership jobs in India · Leadership jobs in the US · Senior jobs in India · Senior jobs in the US · Fresher jobs in India · Entry-level jobs in the US · Remote jobs in the US · Jobs paying $150k+ · Leadership hiring this week · Guides
OpeningsFirst · Use with AI · Terms · Privacy · Refunds · Contact · Follow us on LinkedIn · X