Senior BI Developer

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.

PPI is pleased to provide employees with the flexibility of a hybrid work environment.This role is eligible for working from home up to 3 days per week.

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

Senior Business Intelligence (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.

Key Responsibilities:

Data Architecture and Development

• Collaborate with data analysts to understand data needs and translate them into technical solutions.
• Design, develop, and maintain scalable data architectures and pipelines.
• Implement data warehouses and data lakes using SQL Server (on-prem) and Azure cloud technologies.
• 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 and 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.
• Engage in actions that encourage, reflect and align with PPIs ESG (Environmental, Social and Governance) commitments to our Advisors, their clients and our employees.

Education, Experience and Skills:

Education and Experience

• Bachelors or masters degree in computer science, Information Systems, or related field.
• 5+ years of experience in data engineering and business intelligence development.

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.
• Strong 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 and 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.