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.

AtPPI, each day you have the opportunitytomake a meaningful difference when you supportourindependent insurance advisors in providing financial security and peace of mindtotheir clients: Canadian families and businesses.

When you join PPI you will bepartof a diverse, inclusive and equitable placetoworkthat values different perspectives. You will benefit from a culture that is people-focused, inclusive and collaborative with opportunitiestolearnand develop your skills, develop your career and make a meaningful impact.

Ourpeople driveourprogress through innovative ideas and a commitmenttoexcellence. Weworkhard and always ensure we have fun along the way.

PPI is pleasedtoprovideemployeeswith the flexibility of a hybridworkenvironment.This role is eligible for working fromhomeupto3 daysperweek.

For more information about PPIvisit:www.ppi.ca

Senior Business Intelligence (BI) Developer

We are seeking a mid-seniortosenior-level BI Developer who will play a pivotal role in scaling upourbusiness 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 theworkof data analysts as well as move the team further along data governance and IT compliance. Theidealcandidate will have a strong understanding of both on-premises and cloud data environments, with expertise inMSSQL Server / SSIS, Azure services, Snowflake, and Power BI.

Key Responsibilities:

Data Architecture and Development

• Collaborate with data analyststounderstand 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 relatedtodata architecture, acquisition, integration, warehousing and governance, including but not limitedtocreating documentation, holding training sessions, and participating in cross-functional team meetingstoensure that all teams and technical counterparts are aligned with the latest methodologies and technologies.

Cloud Integration

• Utilize Azure services (ADLS, Databricks, ADF) and Snowflaketocentralize and enhance data availability.
• Migrateon-prem data solutionstocloud platforms where applicable.

Data Governance

• Ensure data quality, integrity, and security across all platforms.Workwith leadershiptoensure 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, statisticalreportinginventory, ad hoc data marts, and user access.
• Own the single source of truth conceptual model in the data warehouse and ensure that all enrichments adheretothe model design principles.
• Collaborate with ITtoensure privacy / security and accesstodata is properly alignedtoorganizational standards.
• Provide thought leadership and supportexecutivedecision 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.
• Provideprojectmanagement for the implementation of data strategy and governance projects.

Technical Support and Collaboration

• Provide technical guidance and supporttothe BI team and other stakeholders.
• In collaboration with IT, leverage Azure DevOps for version control, CI/CD pipelines, andprojecttracking.

Business Intelligence Enablement

• Support the analysis, design, development and implementation of newreportingrequirements.
• 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, financialreporting, and brokeragetoinform data solutions.
• Communicate effectively with technical and non-technical stakeholderstoalign solutions with business goals and corporate strategy.
• Engage in actions that encourage, reflect and align with PPIs ESG (Environmental, Social and Governance) commitmentstoourAdvisors, their clients andouremployees.

Education, Experience and Skills:

Education and Experience

• Bachelors or mastersdegreein computer science, Information Systems, or related field.
• 5+yearsof 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 aplus.
• Strong problem-solving abilities and attentiontodetail.
• Abilitytoworkcollaboratively 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 aplus.

Business Knowledge

• Understanding of life insurance, financialreporting, and brokerage industries ishighlydesirable.

The expectedsalaryrange for this position startsat$105,000 and will be commensurate with the candidates experience and skill set.

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