Posted 2 days ago
ETL Consultant
@ Envision Technology Solutions
Montréal, Quebec
Overview
Envision Technology Solutions is hiring an ETL Consultant on a contract basis to design data architecture, build and optimize SSIS-based ETL processes, and lead process improvement and project governance work. The role requires bilingual English and French communication with stakeholders and strong data engineering experience.
Responsibilities:
- Design data architecture and warehousing solutions
- Develop and optimize ETL processes in SQL Server and SSIS
- Analyze and improve operational workflows and processes
- Coordinate project workstreams and governance
- Communicate status to English and French stakeholders
Requirements summary:
- Strong data architecture and data engineering experience
- Hands-on SQL Server, SSIS and ETL development
- Process engineering and process mining experience
- Technical program governance experience
- Bilingual English and French proficiency
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- 2026-11-11
- First seen by our source
- 2026-11-14
- Source record updated
- 2026-11-14
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Software development |
| Work setting | Office, Client sites |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English, French |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Envision Technology Solutions
| Field | Value |
|---|---|
| Open jobs on Jobsy | 7 |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.