Intermediate Data Engineering Advisor

Onepoint

. Design, develop, and maintain the data pipelines and infrastructure required to support analytics, reporting, and decision-making .

Posted 10/9/2026full-timeMontreal • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in data engineering and analytics solution development, with a strong focus on Microsoft Fabric, Azure tools, and data integration strategies within healthcare systems. Proficient in ETL/ELT processes, data quality controls, and collaboration across technical teams.

Highest-signal resume keywords

Data EngineeringMicrosoft FabricAzure DevOpsSQLBusiness Intelligence

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 IntegrationETLData Quality ControlsT-SQLDAXJSONPythonPower BISparkData Modeling

Soft Skills

CollaborationCommunicationProblem-Solving

Tools & Technologies

Azure Data Lake Storage Gen2Data FactoryMicrosoft PurviewGitGitHub

Certifications & Qualifications

Specialized Certification in Information Technology

Industry Keywords

Healthcare NetworkClinical Information SystemsAnalytics SolutionsData GovernanceMetadata Management

Tech Stack

Tools & technologies

AzureETLFluxPythonSparkSQL

About the role

Key responsibilities & impact

Design, develop, and maintain the data pipelines and infrastructure required to support analytics, reporting, and decision-making
Analyze data sources, define integration logic (ETL/ELT), and apply recommended design patterns
Develop high-performance workflows in Microsoft Fabric and structure data using appropriate models
Implement data quality controls and contribute to unit and integration testing
Ensure the integration, security, and confidentiality of clinical and administrative data
Manage code, traceability, and deployments using Azure DevOps and CI/CD practices
Document solutions, share knowledge, and support the operationalization of data products
Collaborate with architecture, security, operations, and stakeholder teams
Define data integration and interoperability strategies across source systems, Microsoft Fabric, and analytics products
Design event-driven and metadata-driven integration patterns, as well as batch and near-real-time processing mechanisms
Define rules for data flow, transformation, traceability, reconciliation, and error management
Design technical governance, classification, lineage, and access-control mechanisms
Ensure solution alignment with Microsoft Fabric, Azure, Microsoft Purview, Azure DevOps, and CI/CD standards
Produce workflow models, data contracts, technical decisions, integration standards, and templates
Analyze dependencies between clinical and administrative sources and recommend approaches for sustainable integration
Review solutions proposed by development teams and ensure end-to-end consistency
Assess performance, resilience, scalability, and operationalization considerations
Guide teams in implementing strategic directions and resolving complex technical challenges.

Requirements

What you’ll need

Proficiency in spoken and written French
Bachelor’s degree in information technology, business administration, management, or a related field
MIFI equivalency assessment required for any diploma obtained outside Quebec
Specialized certification issued by a competent and recognized authority in the field of information technology
Five (5) years of experience in data engineering
More than four (4) years of experience in business intelligence, including three (3) years in data engineering within Quebec’s healthcare network
One (1) year of experience with Fabric or Databricks
Demonstrated active participation in at least two (2) projects involving the development of analytics solutions integrating provincial clinical information systems and healthcare facilities (e.g., Clinibase, SIURGE, Med-urge, BDCU, MED-ECHO, Opera, SIMASS, SILP)
Tools and languages: Git/GitHub, SQL, Python, Power BI
Knowledge of Microsoft Fabric (Lakehouse, Data Warehouse, Direct Lake, pipelines, notebooks) and Spark environments
Proficiency in T-SQL, DAX, and JSON formats
Knowledge of Azure tools/platforms (e.g., Azure Data Lake Storage Gen2, Data Factory) and governance/metadata tools (e.g., Microsoft Purview)
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, etc.
Annual IT equipment budget
A balanced work environment with flexible working hours
Career development: training and certifications, online or in-person learning, Wepoint Academy, etc.
An international community of experts ready to share their knowledge
A company culture focused on individuals’ needs and their belonging to a strong community.