Senior BI Developer

Job Description

PPI company overview

PPI (an independent subsidiary of iA Financial) is an Insurance Marketing Organization that sits between independent advisors and insurance companies. From coast-to-coast, we provide value-added services and support such as digital tools, education, marketing, and processing, to help advisors elevate and grow their business with a socially responsible mindset.

At PPI, each day you have the opportunity to make a meaningful difference when you support our independent insurance advisors in providing financial security and peace of mind to their clients : Canadian families and businesses.

When you join PPI you will be part of a diverse, inclusive and equitable place to work that values different perspectives. You will benefit from a culture that is people-focused, inclusive and collaborative with opportunities to learn and develop your skills, develop your career and make a meaningful impact.

Our people drive our progress through innovative ideas and a commitment to excellence. We work hard and always ensure we have fun along the way.

For more information about PPI visit : www.ppi.ca.

Senior BI Developer

We are seeking a mid-senior to senior-level BI Developer who will play a pivotal role in scaling up our business intelligence operations. This role is meant as a bridge between business and IT, with functions overlapping data engineering, data analysis and dashboarding. It aims at building a robust data backend that will greatly enable the work of data analysts as well as move the team further along data governance and IT compliance. The ideal candidate will have a strong understanding of both on-premises and cloud data environments, with expertise in MS SQL Server / SSIS, Azure services, Snowflake, and Power BI. They will collaborate with and work in partnership with IT, security, and technology teams to ensure alignment with best practices, technical solutioning and security in addition to business requirements following SDLC practices.

Key Responsibilities

• Collaborate with data analysts to understand data needs and translate them into technical solutions.
• Design, develop, and maintain scalable data architectures, tables and pipelines.
• Implement, build and extract data in warehouse / data lake using SQL Server (on-prem) and Azure cloud technologies, in collaboration with IT.
• Collaborate and assist in new data acquisition and examinations.
• Design and develop data integration packages in the pursuance of ETL / ELT.
• Document processes and development.
• Actively share knowledge and promote best practices related to data architecture, acquisition, integration, warehousing and governance, including but not limited to creating documentation, holding training sessions, and participating in cross-functional team meetings to ensure that all teams and technical counterparts are aligned with the latest methodologies and technologies.

Cloud Integration

Data Governance

Technical Support & Collaboration

Business Intelligence Enablement

Business Acumen

Education, Experience and Skills

Education & Experience

Technical Skills

Soft Skills

Tools & Software

Business Knowledge

We thank all applicants for applying, however, only those selected for an interview will be contacted. Your resume may be used for other vacancies.

Location(s)

Calgary, Alberta

Company

PPI Management Inc.

Posting End Date

2026‑01‑23

Company Overview

iA Financial Group

With over $200 billion in assets and half a billion invested in technological innovation, we’re a key player in the financial services industry in Canada and the United States. The secret to our success? Investing in you, one person at a time. Because, for over 125 years, we have believed that it’s by supporting our employees and surrounding ourselves with the most reputable leaders in the industry, we will continue to innovate.

At iA, we’re invested in you.

Our Commitment to Diversity and Inclusion

At iA Financial Group, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.

Please note that if you need help or assistance to make the recruitment process more accessible for you, Contact us here.

#J-18808-Ljbffr