Enterprise Data Analyst

INTRODUCTION

At Specialty Program Group Canada (SPG Canada), we are insurance entrepreneurs united by a bold vision: to aggregate strengths and deliver unmatched value as Canada’s largest Delegated Underwriting Authority Enterprise (DUAE).

We exist to satisfy insurance needs in our target markets faster, better, and even where others might not. We do this by uniting leading underwriting talent and specialty insurance brands under one coast-to-coast platform, delivering speed, service, and expertise at a national scale.

But what truly sets us apart is our people. At SPG Canada, you will be part of a collaborative, growing team that values innovation, professional development, and shared success. Our culture is built on entrepreneurial thinking, open communication, and a strong sense of purpose. We believe in empowering our employees to take ownership, contribute ideas, and grow their careers within a supportive and dynamic environment.

Our legacy MGA brands include Cansure, i3 Underwriting, Totten Insurance Group, Beacon, Anderson McTague & Associates, Mode, and Avro. Our value to our partners is further enhanced through our in-house claims management team, Specialty Claims Canada.

Together, we are building more than a market leader — we are building a place where talented professionals can thrive.

We are looking for an
Enterprise Data Analyst
to join our
Data & Intelligence team
.

Strong SQL skills and hands-on experience with
Microsoft Fabric
are core to this role, along with
Power BI
. Experience with Google Cloud data architecture (e.g., Big Query) is an accepted alternative platform background. Experience in the insurance industry is preferred.

The
Enterprise Data Analyst
will work collaboratively with business partners in technology and operations, along with the field, to gather information, analyze results, investigate and identify risks and processes, and drive new and existing data products in the SPGC ecosystem.

This role sits within the Strong SQL skills and hands-on experience with
Microsoft Fabric
are core to this role, along with
Power BI
. Experience with Google Cloud data architecture (e.g., Big Query) is an accepted alternative platform background. Experience in the insurance industry is preferred.

The
Enterprise Data Analyst
will work collaboratively with business partners in technology and operations, along with the field, to gather information, analyze results, investigate and identify risks and processes, and drive new and existing data products in the SPGC ecosystem.

This role sits within the Data & Intelligence team, which is responsible for the data used by products delivered in partnership to the field. The Analyst will work cross-functionally to drive improvements in our Data-as-a-Product solutions and will support data testing, data quality, and data governance projects as directed.

This is a hybrid position based in our Vancouver, BC office.

RESPONSIBILITIES

In this position you will:

- Support various data warehouse and platform enhancement initiatives — new subject areas, improved data quality, faster data availability, internal compliance, and simplified usage — contributing to the regular, iterative release of data within the SPGC ecosystem.
- Liaise with IT and Operations teams to ensure technical and business solutions fully meet stakeholder needs for BI reporting, ad-hoc extracts, data science projects, and customer relationship management.
- Support business, contractual, and compliance data needs by creating and maintaining reporting pipelines and delivering one-off reports to internal and external partners.
- Perform data profiling; plan, execute, and review user acceptance test (UAT) cases. Establish minimum viable product and acceptance criteria for development sprints and undertake UAT for data-related projects.
- Execute data projects assigned by your line manager, ensuring business requirements are properly understood and user stories are well crafted to enable efficient, accurate ETL/ELT development.
- Develop and prioritize development stories, participate in Agile ceremonies, and contribute to after-action reviews for data projects.
- Establish programmatic processes to…