E

EXL

Analyzes business data and runs outsourced operations

Power BI / Insurance Analytics Developer

Business IntelligenceConfirmed live in the last 24 hours
Full-timeNo salary listedIn-person

About the Job

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.
  • Understanding of Power BI performance optimization and data model design.
  • Strong SQL skills, including joins, common table expressions, 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.
  • 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 key performance indicators and translate business questions into analytical reports and dashboards.
  • Four to six years of overall experience in business intelligence, reporting, or data analytics.
  • Hands-on experience with Power BI and SQL in enterprise reporting environments.
  • Strong analytical thinking, problem-solving, and communication skills.
  • Ability to interact with business stakeholders and independently convert requirements into technical solutions.

Responsibilities

  • Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
  • Develop efficient DAX measures, calculated columns, key performance indicators, 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 key performance indicators and reporting solutions.
  • Support report performance optimization, production issues, enhancements, and ongoing reporting needs.

Desired Qualifications

  • Experience working with policy, claims, underwriting, or premium-related datasets.
  • Prior experience with an insurance carrier, broker, managing general agent, or insurance analytics organization.
  • Exposure to Azure, Snowflake, Databricks, or SQL Server.

About the Company

EXL

Analyzes business data and runs outsourced operations

EXL analyzes business data and runs outsourced operations for insurers, healthcare payers, banks, retailers, and other large organizations. Its teams combine industry expertise with data engineering and AI to handle tasks such as claims processing, payment reviews, customer service, and finance within existing technology environments. The company also builds software, including LifePRO, which manages insurance policies, and EXLdata.ai, which connects fragmented data for use in AI systems. Clients pay for consulting projects, ongoing managed services, and software delivered through the cloud. EXL was founded in 1999 and is headquartered in New York City.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1999

Recently Posted Jobs

Explore more opportunities at EXL

See more jobs