ETL Consultant

Envision Technology Solutions

Montreal

On-site

CAD 90,000 - 140,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Envision Technology Solutions is seeking a data architecture and engineering professional in Montreal to design, implement, and optimize data systems that support complex business objectives. The role focuses on data modeling, warehousing, ETL, and governance across multiple teams.

You will collaborate with business and technical stakeholders, applying process engineering and mining to drive enhancements, ensure data integrity, and deliver scalable solutions in a bilingual environment.

Qualifications

  • 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.

Responsibilities

  • 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 SSIS.
  • Ensure data integrity and accessibility across integrated systems.
  • Review existing data architectures and identify opportunities for improvement.
  • 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.
  • 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.
  • 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.

Skills

Data architecture
Data engineering
ETL development
Data modeling
Data warehousing
Enterprise architecture reviews
Process engineering methodologies
Process mining tools
Technical program governance
Stakeholder management
Analytical skills
Problem solving
Bilingual English/French

Tools

Microsoft SQL Server
SSIS
Process mining tools

Job description

  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

RQ07956 - Sr Software Developer - ETL
RQ07956 - Sr Software Developer - ETL

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
RQ07957 - Sr. Software Developer - ETL
RQ07957 - Sr. Software Developer - ETL

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
ETL Lead
ETL Lead

BrainRidge Consulting • Toronto

On-site
CAD 120,000 - 190,000
RQ09197 - Software Developer - ETL - Senior
RQ09197 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 100,000
Data Engineering Developer
Data Engineering Developer

Osedea • Montreal

Hybrid
CAD 90,000 - 120,000
Competitive salary RRSP
Flexible hours
8 weeks remote work
+5
RQ08590 - Software Developer - ETL - Senior
RQ08590 - Software Developer - ETL - Senior

Rubicon Path • Toronto

On-site
CAD 85,000 - 105,000
Data Engineer
Data Engineer

Jliconsulting • Vaughan

On-site
CAD 80,000 - 100,000
RQ09315 - Software Developer - ETL - Senior
RQ09315 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
Business Intelligence Developer‑Analyst
Business Intelligence Developer‑Analyst

Dayforce • Quebec

On-site
CAD 90,000 - 130,000
Spécialiste des données
Spécialiste des données

Extia Group • Montreal

On-site
CAD 90,000 - 150,000
Great Place To Work