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 Dev Ops and agile methodologies.
* Experience with Version Control Systems or Source Code Management tools such as Git Hub 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