Senior BI Developer

**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.* 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.* 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.* 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.* 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.* Bachelor’s or master’s degree in computer science, Information Systems, or related field.* 5+ years of experience in data engineering and business intelligence development.* 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.* 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.* Proficient with Microsoft Office Suite: Outlook, Teams, PowerPoint, Excel, Word.* Familiarity with other BI tools and programming languages is a plus.Let us know you’re interested
#J-18808-Ljbffr