Context

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 current railway line, increasing the capacity of the existing infrastructure, privatization of a railway.

Understand better who we are by visiting www.systracanada.com.

Missions/Main Duties

- Support the Project Management Office (PMO) in analyzing and improving the performance of its business needs, including the validation, cleansing, and transformation of data.
- Ensure the consistency, integrity, and standardization of project financial data to meet the PMO’s weekly requirements.
- Design, develop, and enhance analyses, models, and datasets.
- Automate processes and promote data management best practices using tools such as Power
- Query and Power Automate, as well as other data engineering or data science tools as needed.
- Collaborate on the integration of new data sources, whether structured or unstructured, and contribute to the evolution of the analytics ecosystem.
- Document, industrialize, and operationalize the analyses and solutions delivered.
- Support the development of financial analyses and key performance indicators (KPIs) for PMO management and project teams.
- 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.

Profile/Skills

Education: Bachelor’s degree required (Master’s degree considered an asset) in business analytics, business intelligence, finance, mathematics, engineering, computer science, or a related field.

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

Technical skills:

- Excellent command of Excel, including advanced functions, formulas, and analytics.
- Strong skills in data management, structuring, and quality assurance.
- Good understanding of data modeling and data manipulation concepts (SQL, Python, or equivalent tools).
- Proficiency in Power Query and Power Automate.
- Interest in or knowledge of finance, organizational performance, or financial processes.
- Experience producing reports for the Project Management Office (PMO) and Project Management teams.
- Strong verbal and written communication skills in both French and English.*

*Bilingualism is required because you will have the opportunity to collaborate with a wide range of project stakeholders. Bilingualism is essential for building strong relationships with clients, understanding their specific needs, and communicating effectively in their preferred language.

Interpersonal skills:

- Ability to adapt in evolving environments and respond to a variety of team requests.
- Open-mindedness and the ability to collaborate with stakeholders with diverse needs.
- Responsiveness and the ability to adjust quickly based on team priorities and requests.

📌 PMO Financial Analyst - Alto Project (Montreal)
🏢 SYSTRA
📍 Montreal