Back to jobs

Power BI / Insurance Analytics Developer

Chicago, Illinois, United States

Actively hiring, first seen by us 13 days ago
Pay
Pay not listedSimilar roles state $95K–$144K
Work setting
Remote — work setting source
Work setup in the employer’s posting: Work From Home
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design, develop and maintain Power BI dashboards and reports for insurance business users

  • Write and optimize complex SQL for extraction, transformation and reconciliation

  • Perform data validation, reconciliation and root-cause analysis for reporting accuracy

  • Develop and maintain dimensional data models and DAX measures and KPIs

  • Translate business stakeholder requirements into reporting and analytical solutions

From the employer’s posting
Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
Write and optimize complex SQL queries for data extraction, transformation, reconciliation, and analysis.
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.
Work with business stakeholders to understand requirements and translate them into reporting and analytical solutions.
Apply at EXL Service

Posting record

Report an error

Actively hiringFirst seen by us 13 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Oct 23, 202613 days ago
Recorded sightings
50
Last seen by us
Nov 5, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$94.7K–$144K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 1,811 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 13

Similar jobs usually come down between day 5 and day 41.

At EXL Service, jobs usually come down by about day 17.

From 11,032 similar postings that came down, and 218 of EXL Service’s. Coming down is not always a hire.

EXL Service is hiring

202 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Takes jobs down at a usual pace
  • 4% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Databricks
  • Power BI
  • Power Query
  • Snowflake
  • SQL Server
Where the posting names them
- 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.
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.
- 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.
- 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.
- 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.
Power BI - Strong hands-on experience with Power BI Desktop and Power BI Service.
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
- 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.
- 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.

Your next step

Complete your application on fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com. The employer’s form will show what is required.

Applying through Oracle Recruiting

  • Applying starts by asking for your email address.
  • Each employer sets which files it accepts, so read the note beside the upload field.

Already applied? Track this application

About EXL Service

People
About 65,000 in 2025, up 9% from the year before.Annual report (SEC Form 10-K)
Company
Listed as EXLS.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 19% over the last 5 weeks compared with the 5 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of October 26. The fewest in a week was 965, the most 1,388, and the latest week had 1,365.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 5 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Job description

View original posting ↗

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.
Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Chicago, Illinois, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.