PMO Data Analyst

SYSTRA Canada is part of the SYSTRA group, an international consulting and engineering group, a world leader in the design of transport infrastructures. SYSTRA Canada is an engineering and consulting firm whose primary focus is to offer transportation solutions, whether for passengers or goods: feasibility studies of building a new railway line, increasing the capacity of the existing infrastructure, privatization of a railway.

Context

The ALTO project is a major infrastructure initiative in Canadian history, aimed at developing over 1,000 km of new passenger rail service between major urban centers, including Toronto, Ottawa, Montreal and Quebec City.

Missions/Main Duties

• Support the Project Management Office (PMO) in its data management tasks, including data transformation, structuring, and analysis.
• Ensure the consistency, integrity, and standardization of project data to meet the PMO’s needs.
• Automate processes and promote best practices in data management using tools such as Power Query and Power Automate.
• Develop financial analyses and key performance indicators (KPIs) for PMO leadership and project teams.
• Design analytical visualizations (metadata) using Power BI to assess the current status, target objectives, and progress of data assets.
• Collaborate with stakeholders to identify data needs and propose appropriate solutions. Ensure the documentation and traceability of processes and data flows to facilitate auditing and maintenance.
• Optimize existing tools (Excel, SharePoint, etc.) to improve team efficiency and data quality.
• Ensure data security and compliance with internal policies and applicable regulations.

Profile/Skills

Education: Bachelor’s degree in data science, engineering, computer science, statistics, or a related field.

Years of experience: 2 to 3 years of experience in a similar role.

Technical Skills

• Excellent proficiency in Excel: features, advanced formulas, and analysis.
• Skills in data management, structuring, and ensuring data reliability.
• Knowledge of databases and workflows.
• Proficiency in Power Query and Power Automate.
• Experience producing reports for the Project Management Office (PMO) and Project Management.
• Ability to communicate clearly both verbally and in writing, in French and English*
• Reasons for the bilingual requirement: You will have the opportunity to collaborate with various project stakeholders; bilingualism is essential for building strong relationships with our clients, understanding their specific needs, and communicating effectively in their preferred language.

Interpersonal Skills

• Ability to adapt to changing environments and to the team’s varied requests.
• Open-mindedness and the ability to collaborate with people who have diverse needs.
• Responsiveness and the ability to adjust quickly based on the team’s priorities and requests.

SYSTRA Canada is committed to having a diverse and inclusive workforce. We are an Equal Opportunity Employer that values applications from all and offers employment equity based on the merits and abilities of candidates and personnel.

Note: In this description, the masculine gender is used for easy reading purposes and includes the feminine.

We use AI-enabled tools in our recruitment platform (iCIMS) for tasks like resume parsing and candidate matching. These tools do not make hiring decisions; all applications are reviewed by a human recruiter, and final decisions are made by our hiring team.

For questions about our hiring process or AI tools, please contact [email protected].