ETL Consultant

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.