PMO Financial Analyst – Alto Project

SYSTRA Canada; Montreal (administrative region); On-site; CAD 70,000 - 90,000; Full time

Job summary

SYSTRA Canada seeks a data analytics professional to support PMO reporting and financial data standardization for the ALTO project. You will cleanse, transform, and model data, driving automation with Power Query and Power Automate while leveraging SQL and Python where needed.

You will collaborate with bilingual stakeholders, ensuring data quality and traceability, and contribute to analytics ecosystem evolution within a major Canadian infrastructure program.

Qualifications

• Bachelor’s degree required; Master’s degree considered an asset.
• 2 to 3 years of experience in a similar role.

Responsibilities

• Support the PMO in analyzing and improving data needs, including validation, cleansing, and transformation.
• Ensure consistency, integrity, and standardization of project financial data for weekly PMO reporting.
• Design, develop, and enhance analyses, models, and datasets.
• Automate processes using Power Query and Power Automate; leverage SQL/Python as needed.
• Collaborate on integrating new data sources, structured or unstructured, for analytics ecosystem evolution.
• Document, industrialize, and operationalize analyses and solutions delivered.

Skills

Excel proficiency

Data management

Data modeling concepts

Bilingual communication

Stakeholder collaboration

Education

Bachelor’s degree in related field

Tools

SQL

Python

Power Query

Power Automate

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 [email protected].