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.
