Job opportunity
ETL Consultant
Envision Technology Solutions
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.
#J-18808-Ljbffr
Apply on source site 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.
#J-18808-Ljbffr