Power BI, Insurance Analytics Developer

This is a fully remote position, open to applicants in United States, +2 more locations.

📋 Description

• Create, develop, and sustain interactive Power BI dashboards and reports tailored for insurance business users.

• Design efficient DAX measures, calculated columns, KPIs, and data models to fulfill analytical and reporting needs.

• Construct and optimize intricate SQL queries for data extraction, transformation, reconciliation, and analysis.

• Examine large datasets to uncover business trends, data challenges, and actionable insights.

• Collaborate with business stakeholders to comprehend requirements and convert them into reporting and analytical solutions.

• Conduct data validation, reconciliation, and root-cause analysis to guarantee the accuracy and consistency of reports.

• Build and sustain dimensional data models that support various reporting and analytics use cases.

• Work alongside data engineering, business, and analytics teams to integrate data from diverse source systems.

• Utilize insurance domain expertise to interpret business data and create meaningful KPIs and reporting solutions.

• Assist in optimizing report performance, resolving production issues, implementing enhancements, and addressing ongoing reporting needs.

⛳️ Requirements

• 4-6 years of comprehensive experience in business intelligence, reporting, or data analytics.

• Practical experience with Power BI and SQL in enterprise reporting settings.

• Previous experience with an insurance carrier, broker, MGA, or insurance analytics organization is highly preferred.

• Familiarity with Azure, Snowflake, Databricks, or SQL Server would be beneficial.

• Extensive hands-on experience with Power BI Desktop and Power BI Service.

• Solid understanding of DAX, Power Query, data modeling, relationships, drill-through, bookmarks, filters, and best practices in visualization.

• Experience in developing complex dashboards and executive or business reporting solutions.

• Knowledge of Power BI performance optimization and data model design principles.

• Proficient SQL skills, including joins, CTEs, subqueries, window functions, aggregations, and intricate transformations.

• Experience in analyzing and reconciling data across various tables and data sources.

• Strong grasp of relational databases, dimensional modeling, and data warehousing concepts.

• Capability to investigate data-quality issues and conduct independent root-cause analysis.

• Good understanding of insurance data and business processes, ideally within Property & Casualty insurance.

• Familiarity with policy, coverage, exposure, premium, claims, losses, reserves, limits, deductibles, brokers or agents, and underwriting.

• Ability to comprehend insurance KPIs and translate business inquiries into analytical reports and dashboards.

• Excellent analytical thinking, problem-solving, and communication abilities.

• Proficient in interacting with business stakeholders and independently transforming requirements into technical solutions.

• Bachelor's Degree.

🏝️ Benefits

• Comprehensive health and wellness benefits.

• Opportunities for professional development and growth.

• Flexible work arrangements and a supportive work environment.