PMO Financial Analyst – Alto Project

SYSTRA; Montreal (administrative region); On-site; CAD 65,000 - 85,000; Full time

Benefits offered by this job

Powerful data tools

Job summary

SYSTRA Canada seeks a data analytics professional to support the PMO by validating, cleansing, transforming, and standardizing project data. You will design analyses, build models, and automate processes to improve reporting and decision-making for major infrastructure projects.

With 2–3 years of experience and strong SQL/Python, you will collaborate with bilingual stakeholders, enhance data quality, and contribute to the analytics ecosystem across the PMO and project teams.

Qualifications

• Bachelor’s degree required in business analytics, business intelligence, finance, mathematics, engineering, computer science, or a related field.
• 2 to 3 years of experience in a similar role.
• Excellent command of Excel with advanced functions, formulas, and analytics.
• Strong data management, structuring, and quality assurance.
• Good understanding of data modeling and data manipulation concepts (SQL, Python, or equivalent).
• Proficiency in Power Query and Power Automate.
• Bilingualism in French and English is required for collaboration with stakeholders.

Responsibilities

• Support the PMO in analyzing and improving performance of business needs, including data validation, cleansing and transformation.
• Ensure consistency, integrity, and standardization of project financial data for weekly PMO reports.
• Design, develop, and enhance analyses, models, and datasets.
• Automate processes and promote data management best practices using Power Query and Power Automate.
• Collaborate on integrating new data sources and evolving the analytics ecosystem.
• Document, industrialize and operationalize analyses and solutions delivered.
• Support development of financial analyses and KPIs for PMO management and project teams.
• Collaborate with stakeholders to identify data needs and propose solutions.
• Ensure documentation and traceability of processes and data flows for auditing.

Skills

Bilingual (FR/EN)

Strong communication

Adaptability

Team collaboration

Education

Bachelor's degree required

Master's degree asset

Tools

Excel advanced

SQL

Python

Power Query

Power Automate

SharePoint

Data modeling

PMO reporting tools

Job description

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.

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

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 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.

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 [e-mail].

Workplace Type