Develop and maintain Power BI dashboards, reports, DAX measures, KPIs, and dimensional data models for insurance stakeholders. Write complex SQL for data extraction, transformation, reconciliation, and analysis. Investigate data-quality issues, validate reporting accuracy, optimize performance, and translate insurance business requirements into actionable analytics solutions. Collaborate with engineering, business, and analytics teams across multiple data sources.
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.
Similar Jobs
.png){kind=logo}
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Senior Data Scientist responsible for translating product and machine learning goals into actionable data specifications. The role oversees dataset curation, filtering, processing, pipeline quality, and behavioral data integrity for production machine learning. It requires collaboration with ML engineers, product engineers, TPMs, and annotation teams, along with strong data science, mathematical, analytical, communication, and cross-functional leadership skills.
Top Skills:
ConfluenceExperiment Tracking FrameworksGitJIRAMachine LearningPythonSlackUnix Shell
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Manage a ~40-account mid-market portfolio to drive net-new growth and expansion. Own full sales cycle, develop account/territory plans, lead cross-functional deal teams, build C‑suite relationships, qualify and close complex multithreaded deals using outcome-based selling, forecast pipeline, and collaborate with channel, product, and customer success. Occasional travel for customer meetings and team events.
Top Skills:
CloudConfluenceCRMJira Service ManagementJira SoftwareSaaS
Cloud • Security • Software • Cybersecurity • Automation
Owns public sector account growth across Canadian provincial, municipal, and post-secondary organizations. Responsibilities include building account plans, managing complex procurement and contracting cycles, developing pipelines, closing and expanding business, advising senior stakeholders, and partnering with system integrators, resellers, and internal technical and customer success teams. The role requires positioning GitLab’s AI-powered DevSecOps platform for software modernization, security, compliance, and infrastructure initiatives.
Top Skills:
AICi/CdDevsecopsGitlab
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
