Spécialiste BI (Développeur ETL) / BI Specialist (ETL Developer)

Smardt•Dorval, QC

75d•Hybrid

About The Position

Reporting to the BI Manager as part of the Group IT VP (CIO), the BI Specialist (ETL Developer) will be responsible for designing, developing, implementing and supporting the ETL processes required for the Datawarehouse and its different subjects. This person will act as part of a team who is responsible of the BI deliverables. The ideal candidate will have strong experience in building, maintaining, and optimizing data integration pipelines, with a focus on Microsoft technologies (SQL Server, Azure, etc.). In this role, you’ll collaborate with the BI team to deliver high-quality data solutions that drive business insights.

Requirements

Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
5+ years of experience working with SQL Server or other relational databases.
Proven experience as a BI Specialist (ETL Developer)
Strong experience with ELT/ETL tools such as SSIS, Azure Data Factory, or equivalent.
Experience working with data warehouses, data lakes, and business intelligence environments.
Proficiency in SQL for writing and optimizing queries, procedures, and triggers.
Advanced SQL development and optimization skills.
Experience with Microsoft technologies (SQL Server, Azure SQL, SSIS, ADF).
Familiar with ETL for Star schemas, Cubes and Datalake concepts
Familiar with Star Schema modeling
Familiarity with cloud-based data services (e.g., Azure Data Lake, Azure Synapse).
Experience implementing controls on ETL processes, ensuring data accuracy, and detecting potential issues early.
Knowledge of data governance and security best practices.

Nice To Haves

Certifications in Microsoft SQL Server, Azure, or Data Engineering are a plus.
Experience with Azure Synapse Analytics, Power BI, or other data visualization tools is a plus.
Experience with API calls.
Knowledge of programming languages like Python, PowerShell, or .NET (optional, but a plus).
Experience or familiarity with ERP data, with a preference for those with experience in Microsoft Dynamics Navision.

Responsibilities

Design, develop, and maintain ETL processes using Azure Data Factory (ADF).
Ensure data is extracted, transformed, and loaded into our data warehouse from various sources efficiently.
Collaborate with the team to implement rigorous controls and validations to ensure data quality and consistency.
Work with complex SQL queries and stored procedures, optimizing performance and ensuring the integrity of the data.
Collaborate with the BI team to ensure smooth data integration and help shape BI data models.
Monitor and troubleshoot data workflows, ensuring data loads run smoothly and efficiently.
Develop and maintain robust data pipelines, with a focus on continuous improvement and automation.
Leverage experience with ERP systems, especially Microsoft Dynamics Navision, to ensure smooth data integration and support reporting needs.
Ensure compliance with data governance and security standards across all data processes.
Develop and update technical documentation