Back to job search
Envision Technology Solutions logo

ETL Consultant

  • Montréal, QC
  • On-site
  • Posted Nov 13, 2026
  • 1 position

Applications are currently unavailable for this posting.

Browse current jobs
Sign in to save this job
Employment type
Contract
Posting language
English
Application method
Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Design, implement, and optimize data architectures, models, data warehouses, and ETL processes using Microsoft SQL Server and SSIS, while improving workflows through process engineering and process mining. Coordinate project workstreams and governance, communicate recommendations to stakeholders, and document data and process solutions.

Job details

Key Responsibilities Data Architecture and Engineering Design and implement data architecture solutions that support business and technical requirements. Develop robust data models and data warehousing solutions. Develop, maintain, and optimize ETL processes using Microsoft SQL Server and SQL Server Integration Services (SSIS). Ensure data integrity and accessibility across integrated systems. Review existing data architectures and identify opportunities for improvement. Process Engineering and Optimization Assess existing workflows and identify process gaps, bottlenecks, and operational inefficiencies. Apply process engineering methodologies to improve workflows and service delivery. Use process mining tools to analyze operational processes and identify improvement opportunities. Collaborate with business and technical teams to implement process enhancements. Technical Program and Project Governance Oversee multiple project workstreams and coordinate dependencies across teams. Establish and maintain project governance practices aligned with client expectations. Monitor delivery progress, risks, issues, and dependencies. Ensure project outcomes meet agreed service delivery standards. Communicate project status and technical recommendations to stakeholders. Stakeholder Collaboration Work with cross-functional teams to translate business needs into data and process solutions. Support the integration of emerging technologies and digital platforms. Facilitate effective communication with English- and French-speaking stakeholders. Maintain clear documentation of architectures, workflows, ETL processes, and governance decisions. Required Skills and Experience Strong experience in data architecture and data engineering. Hands-on expertise in Microsoft SQL Server, SSIS, and ETL development. Solid understanding of data modeling and data warehousing. Experience conducting enterprise architecture reviews. Knowledge of process engineering methodologies and workflow optimization. Experience using process mining tools to evaluate operational efficiency. Experience in technical program governance and coordinating multiple project workstreams. Strong stakeholder management, analytical, and problem-solving skills. Bilingual proficiency in English and French. Ability to collaborate across business, technology, and delivery teams.

What you’ll do

Design, implement, and optimize data architectures, models, data warehouses, and ETL processes using Microsoft SQL Server and SSIS, while improving workflows through process engineering and process mining. Coordinate project workstreams and governance, communicate recommendations to stakeholders, and document data and process solutions.

Requirements

Requires strong experience in data architecture and engineering, hands-on SQL Server, SSIS, and ETL expertise, and knowledge of data modeling, warehousing, enterprise architecture reviews, and workflow optimization. Candidates should also have experience with process mining and technical program governance, strong collaboration and problem-solving skills, and proficiency in English and French.

Listed skills

  • Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Data Architecture
  • Data Engineering
  • Microsoft SQL Server
  • SQL Server Integration Services (SSIS)
  • ETL Development
  • Data Modeling
  • Data Warehousing
  • Enterprise Architecture Reviews
  • Process Engineering
  • Workflow Optimization
  • Process Mining
  • Technical Program Governance
  • Project Workstream Coordination
  • Stakeholder Management
  • Analytical Problem-Solving
  • English-French Bilingual Communication

Job areas

  • Data & Analytics
  • Technology
  • Consulting
  • Management & Leadership

More jobs from Envision Technology Solutions

See all jobs from Envision Technology Solutions