Posted 7 days ago
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.
