Power BI / Insurance Analytics Developer
Apply on company site View on the company's website
Posted on the company's own website.
Can I apply?
- Remote from United States, Canada
- Work permit not stated
Power BI and SQL developer role building dashboards, DAX measures and dimensional models for insurance business users, with a preference for Property & Casualty insurance knowledge.
Requires 4-6 years of experience in business intelligence, reporting, or data analytics, plus hands-on Power BI and SQL in enterprise reporting.
Location is listed as Chicago, Illinois, United States; the description does not state whether the role is remote, onsite or hybrid, so confirm with the employer.
Work authorization, salary and employment type are not stated in the posting.
From the posting
- workplace
ATS workplace type: remote
- remote eligible countries
ATS location: Chicago, Illinois, United States; Canada
- locations
ATS location: Chicago, Illinois, United States; Canada
- years experience min
4-6 years of overall experience in business intelligence, reporting, or data analytics.
- seniority
4-6 years of overall experience in business intelligence, reporting, or data analytics.
- job function
Design, develop, and maintain interactive Power BI dashboards and reports for insurance business users.
- role family
Power BI / Insurance Analytics Developer
- skills
Strong hands-on experience with Power BI Desktop and Power BI Service.
- skills
Strong strong SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and complex transformations.
- actionable
Develop efficient DAX measures, calculated columns, KPIs, and data models to support analytical and reporting requirements.
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.
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.
Responsibilities
- 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.
Qualifications
- 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.
Seen on
- oraclecloud — fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com