Power BI / Insurance Analytics Developer
Chicago, Illinois, United States
- Pay
- Pay not listedSimilar roles state $94K–$143K
- 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 postingDesign, 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.
Tools in this posting
- SQL
- Azure
- Databricks
- Power BI
- Power Query
- Snowflake
- SQL Server
Source — Tool mentions in context
- 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.
Posting record
Report an errorActively hiringFirst seen by us 6 days ago, still listed, and not a repost of an earlier posting.
- Status in our records
- Live
- First seen by us
- Oct 23, 2026 · 6 days ago
- Recorded sightings
- 43
- Last seen by us
- Oct 29, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
- Ask the employer about the pay range before committing time to the process.
Complete your application on fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com. The employer’s form will show what is required.
Already applied? Track this application
Job 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.
- 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.
- 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
Source notes
Source excerptsSelected 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.
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.