Power BI, Insurance Analytics Developer

🔥 0 minutes ago

🌐 United States, Canada – Remote

🇺🇸 United States – Remote 🇨🇦 Canada – Remote

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 11%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

EXL

WebsiteLinkedInAll Job Openings

10,000+ employees

🏥 Healthcare

🛡️ Insurance

📦 Logistics

💰 $2M Venture Round on 2015-01

Healthcare • Insurance • Logistics

EXL is a business consulting and services firm that focuses on leveraging data to enhance business operations and decision-making. With a strong emphasis on collaboration and adaptability, EXL partners with organizations to address their unique needs and culture while integrating data science and technology solutions. The company's areas of expertise include operations management, decision analytics, digital transformation, and various industries such as healthcare, finance, and insurance. EXL's mission is to help clients drive business evolution and maintain competitive advantage through tailored solutions and effective use of data.

📋 Description

• 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.

🎯 Requirements

• 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 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, 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. • 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. • Strong analytical thinking, problem-solving, and communication skills. • Ability to interact with business stakeholders and independently convert requirements into technical solutions. • Bachelor's Degree.