Senior BI Developer

ia; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

PPI, an independent subsidiary of iA Financial, is seeking a mid-senior to senior-level BI Developer to scale our analytics, bridging business and IT. You will work across data engineering, analysis, and dashboarding to build a robust data backend and governance capable of supporting analysts and stakeholders.

Collaborate with IT and security teams, leverage Azure, Snowflake, and Power BI, and contribute to SDLC-compliant data initiatives that enable trusted insights and decision making.

Qualifications

• Experience designing scalable data architectures and pipelines.
• Experience with ETL/ELT, data warehousing and governance.
• Strong SQL skills and cloud data platforms, e.g. Azure and Snowflake.

Responsibilities

• Design, develop, and maintain scalable data architectures and pipelines.
• Migrate and integrate data using SQL Server on-prem and Azure cloud.
• Govern data quality, security, and master data governance across platforms.
• Collaborate with IT and business stakeholders to enable Power BI dashboards.
• Lead and implement data governance programs and SDLC practices.

Skills

Data architecture

ETL/ELT

SQL

Azure

Snowflake

Power BI

SDLC

Azure DevOps

Education

Bachelor's degree in a related field

Tools

Azure Databricks

Snowflake

ADF

Power Platform

Job description

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.

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:

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

Bachelo