Senior Data Engineering Advisor

Onepoint

. Design and develop data pipelines .

Posted 10/9/2026full-timeMontreal • CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced proficiency in data engineering and business intelligence, with a strong focus on the Microsoft Fabric platform and healthcare data integration. Possesses expertise in data quality, compliance, and analytics architecture design, along with a solid command of relevant programming languages and tools.

Highest-signal resume keywords

Microsoft Fabric Data Engineer Associate Certification (DP-700)Advanced Knowledge of Microsoft Office 365 SuiteIn-Depth Knowledge of Power BI and Power PlatformProficiency in T-SQL, Python, and Data Modeling TechniquesExperience in Healthcare Data Integration within Quebec's Network

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Pipeline DevelopmentData Integration AcceleratorsData Quality and ComplianceT-SQLPythonPower BIData Modeling TechniquesMicrosoft FabricETL/ELTEvent-Driven Architectures

Soft Skills

Meticulous and Detail-OrientedTeam CoordinationProject ManagementTechnical Guidance

Tools & Technologies

Microsoft AzureAzure Data Lake Storage Gen2Data FactoryMicrosoft PurviewSparkDockerKubernetesMS SQL ServerOracleNoSQL Databases

Certifications & Qualifications

Microsoft Fabric Data Engineer Associate Certification (DP-700)

Industry Keywords

Healthcare Data IntegrationISO 27001GDPRSOC 2HL7/PHIREClinical Information SystemsData GovernanceAccess ManagementCryptographyCI/CD

Tech Stack

Tools & technologies

AzureDockerETLKubernetesMS SQL ServerNoSQLOraclePythonSparkSQLSSIS

About the role

Key responsibilities & impact

Design and develop data pipelines
Create data integration accelerators
Ensure data quality and compliance
Ensure security and confidentiality
Participate in the design of modern analytics architectures
Develop tools for BI and AI
Optimize queries and data models
Participate in tool selection and implementation
Support users and continuous improvement
Contribute to data governance

Requirements

What you’ll need

Advanced proficiency in spoken and written French
Bachelor’s degree in Information Technology, Business Administration, Management, or a related field
MIFI equivalency is required for any degree obtained outside Quebec
Completion of at least three Microsoft Applied Skills assessments directly related to Fabric, or possession of the Microsoft Fabric Data Engineer Associate certification (DP-700)
Eight (8) years of experience in data engineering
More than five (5) years of business intelligence experience, including three (3) years of data engineering experience within Quebec’s healthcare network
Active participation in at least three (3) mandates involving the development of analytics solutions integrating provincial clinical information systems and healthcare facilities
Advanced knowledge of the Microsoft Office 365 suite
Advanced knowledge of the Fabric platform (Lakehouse, Data Warehouse, Direct Lake, Pipelines, notebooks)
Hands-on experience managing Fabric workspaces and Spark environments
Proficiency in Fabric development environments, including advanced use of Notebooks
In-depth knowledge of Power BI and the Power Platform (Power Automate, Power Apps, Copilot Studio)
Excellent command of T-SQL, M, R, JSON, Python, DAX, Docker, and Kubernetes
Proficiency in data modeling techniques and model optimization in Fabric
Demonstrated advanced knowledge of the clinical and administrative systems used in Quebec’s healthcare network
Good knowledge of YAML and configuration files for automated deployments (CI/CD)
In-depth knowledge of MS SQL Server, Oracle, DB2, Sybase, Dataverse, NoSQL databases, Spark, ELT, ETL, APIs, and JSON
Experience with event-driven architectures and real-time data processing
Practical knowledge of Microsoft Purview, Microsoft Azure, Azure Data Lake Storage Gen2, Data Factory, and Azure Machine Learning
Strong experience with SSIS, SSAS, SSRS, and HL7/PHIRE data integration
Knowledge of ISO 27001, GDPR, and SOC 2 standards, as well as cryptography and access management
Meticulous and detail-oriented
Ability to work as part of a team, coordinate multiple projects simultaneously, and provide guidance on technical best practices
Only candidates legally authorized to work for any employer in Canada will be considered

Benefits

Comp & perks

Minimum of 3 weeks of vacation starting from the first year
Comprehensive group insurance with a generous employer contribution
Employer contribution to a group RRSP
Full remote work flexibility: Hybrid, Remote, or On-site
A warm, bright, and welcoming office offering fresh fruit, coffee, beverages, occasional meals, and more
Annual IT equipment budget
A balanced work environment with flexible working hours
Career development: training and certifications, online or in-person learning, Wepoint Academy, and more
An international community of experts ready to share their knowledge
A company culture focused on individuals’ needs and their sense of belonging to a strong community