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., BigQuery) 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., BigQuery) 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.
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 proactively measure and manage data quality (ideally automated) using SQL and related languages; coordinate remediation of data defects and data quality problems.
- Collaborate with the Data & Intelligence team to implement common data definitions and metadata documentation. Serve as an EDW and data-source subject matter expert.
You’re a good fit if you have:
- Bachelor’s degree in a related quantitative field, or 5 years of related insurance industry data experience.
- Strong, hands-on SQL proficiency — query authoring, performance tuning, and data validation.
- Microsoft Fabric experience (Google Cloud data architecture such as BigQuery accepted as an alternative platform background).
- Strong, hands-on SQL and Python proficiency — query authoring, performance tuning, data validation, and transformation/automation work in Microsoft Fabric notebooks.
- Power BI and DAX for reporting and dashboarding.
- Practical exposure to data warehousing, business intelligence, data modeling, and master data management concepts.
- Demonstrated SCRUM/Agile experience.
- Understanding of data governance, data integration, and master data management best practices.
- A consultative style that leverages both business and technical resources.
Strong assets (nice to haves):
- Familiarity with the EPIC broker management system.
- Exposure to NetSuite / NetSuite Analytics Warehouse.
By joining Specialty Program Group Canada, you’ll become part of a rapidly growing company focused on providing innovative insurance solutions to support independent brokers in Canada. As a member of our team, you’ll benefit from:
- Dental care
- Extended health care
- Paid time-off
- RRSP match
- Vision care
The expected salary range for this position is from $90,000 to $100,000 and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. Specialty Program Group Canada and affiliated brands are proud to offer comprehensive benefit and total compensation packages which include extended health and dental benefits, disability insurance, RRSP matching, paid time off benefits, and a variety of potential bonus opportunities.
