Description d’emploi 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 chance 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:

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:

Data Architecture & Development 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

Utilize Azure services (ADLS, Databricks, ADF) and Snowflake to centralize and enhance data availability. Migrate on‑prem data solutions to cloud platforms where applicable.

Data Governance

Ensure data quality, integrity, and security across all platforms. Work with leadership to ensure the proper controls are being managed and reviewed for all data integrations. Develop and maintain a data inventory in the analytics warehouse, which includes a full list of available data models, model attributes, statistical reporting inventory, ad hoc data marts,



and user access Own the single source of truth conceptual model in the data warehouse and ensure that all enrichments adhere to the model design principles. Collaborate with IT to ensure privacy / security and access to data is properly aligned to organizational standards. Provide thought leadership and support executive decision making around the use of data, setting enterprise standards, and enforcing data governance policies across the organization Implement best practices for data governance and compliance. Provide project management for the implementation of data strategy and governance projects.

Technical Support & Collaboration

Provide technical guidance and support to the BI team and other stakeholders. In collaboration with IT, leverage Azure DevOps for version control, CI/CD pipelines, and project tracking.

Business Intelligence Enablement

Support the analysis, design, development and implementation of new reporting requirements. Assist with development and optimization of Power BI dashboards, reports, and data models. Assist in the design, development and implementation of Microsoft Power Platform solutions.

Business Acumen

Apply industry knowledge of life insurance, financial reporting, and brokerage to inform data solutions. Communicate effectively with technical and non‑technical stakeholders to align solutions with business goals and corporate strategy.

Education, Experience and Skills

Education & Experience Bachelor’s or master’s degree in computer science, Information Systems, or related field. 7-10 years of progressive experience in data engineering, business intelligence, and analytics development, including experience leading complex initiatives, mentoring technical resources, and influencing cross‑functional teams.

Technical Skills

Proficient in SQL Server, SSIS and T‑SQL programming. Experience with Azure services: Azure Data Lake Storage (ADLS), Azure Databricks, Azure Data Factory (ADF). Expertise in Snowflake data warehousing. Strong skills in Power BI development. Familiarity with Azure DevOps and agile methodologies. Experience with Version Control Systems or Source Code Management tools such as GitHub for version control, collaboration, and code management. Knowledge of data modeling, ETL processes, and data warehousing concepts.

Soft Skills

Excellent communication skills in English; proficiency in French is a plus. Solid problem‑solving abilities and attention to detail. Ability to work collaboratively in a team environment and support cross‑functional teams. Collaborate with other team members in planning, reviews and retrospectives. Demonstrated supervisory skills an asset. PowerPoint and presentation skills.

Tools & Software

Proficient with Microsoft Office Suite: Outlook, Teams, PowerPoint, Excel, Word. Familiarity with other BI tools and programming languages is a plus.

Business Knowledge

Understanding of life insurance, financial reporting, and brokerage industries is highly desirable.

This role is for a new position.



The expected salary range for this position starts at $100,000 and will be commensurate with the candidate’s experience and skill set. We thank all applicants for applying, however, only those selected for an interview will be contacted. Your resume may be used for other vacancies.

Principal lieu de travail

North York/ 2235 Sheppard Avenue E Autre(s) lieu(x) de travail possible(s) Edmonton, 5241 Calgary Trail NWCalgary / 205 Quarry Park Boulevard SE Compagnie PPI Management Inc.

Date de fin de l’affichage

Profil de l'organisation

iA Groupe financier*, c’est la force d’une société de taille à dimension humaine qui compte plus de 8 000 employés. Ensemble, nous avons gagné la confiance de plus de 4 millions de clients et 25 000 représentants qui nous ont choisis pour leurs assurances, leur épargne et la gestion de leur patrimoine. Avec plus de 200 milliards de dollars d’actifs et un demi‑milliard de dollars de prévu en investissement pour l’innovation technologique, nous sommes un joueur clé dans le domaine des services financiers au Canada et aux États-Unis. Le secret de notre réussite? S’investir, une personne à la fois. Parce que depuis plus de 125 ans, nous croyons que c’est en soutenant chacun de nos employés et en nous entourant de leaders parmi les plus réputés de l’industrie que nous pouvons continuer d’innover. Chez iA, on s’investit, pour vous.

* iA Groupe Financier inclus les entités suivantes: iA Services financiers, iA assurance auto et habitation, iA Gestion privée de patrimoine, PPI Management, Investia, iA Gestion de placements, Prysm, iA Clarington, Michel Rhéaume et associés, Garanties Nationales, WGI Manufacturing, WGI Service Plan Division, Lubrico, iA Financement auto

Notre engagement en matière de Diversité et inclusion

Chez iA Groupe financier, nous appuyons et nous célébrons la diversité. Nous nous efforçons de fournir un milieu de travail reconnu comme inclusif pour tous, sans égard à l’origine ethnique, la nationalité, la langue, les croyances religieuses, le genre, l’orientation sexuelle, l’âge, l’état matrimonial, la situation familiale ou un handicap physique ou mental. Notez que si vous avez besoin d’aide ou d’assistance pour rendre le processus de recrutement plus accessible pour vous, veuillez Nous joindre ici. Une personne de notre équipe se fera un plaisir de répondre à vos besoins.

Reflet de l'appréciation et du engagement de nos employés, iA se distingue, cette année encore, parmi les meilleurs employeurs au Canada selon Forbes. En 2026, iA Groupe financier se classe d’ailleurs au 1er rang parmi les grands assureurs canadien cotés en bourse. Chez iA Groupe financier, nos différences nous rendent uniques. Nous tenons à soutenir et à célébrer la diversité, car nous croyons que c’est en unissant nos différences que nous serons plus fort(e)s. Le bien‑être de nos employé(e)s étant une priorité pour iA, nous nous engageons également à créer un environnement de travail stimulant et sécuritaire, en plus d’offrir une réelle conciliation travail‑vie personnelle grâce à notre modèle de travail flexible. Reflet de l’appréciation de nos employé(e)s, iA s’est d’ailleurs classé parmi les meilleurs employeurs au Canada en 2023 selon Glassdoor et selon Forbes. Vous aussi aimeriez faire partie de la grande famille iA, mais aucun poste présentement affiché ne semble correspondre à votre profil? Manifestez nous votre intérêt dès maintenant!

#J-18808-Ljbffr

📌 Senior BI Developer (Toronto)
🏢 Iaawg
📍 Toronto