PMO Financial Analyst - Alto Project

Systra; Montreal (administrative region); On-site; CAD 65,000 - 90,000; Full time

Job summary

SYSTRA Canada, a leader in transport infrastructure consulting, is seeking a Data Analyst to support the PMO through data cleansing, transformation, and performance analysis. You will design models, automate processes, and ensure data integrity across weekly PMO reports.

The role requires strong Excel capabilities, SQL/Python knowledge, and bilingual French-English collaboration. You will work with stakeholders to evolve the analytics ecosystem, document processes, and optimize data flows while

Qualifications

• Bachelor’s degree required; Master’s degree considered an asset.
• 2–3 years of experience in a similar role.
• Strong Excel skills with advanced functions and analytics.
• Good data modeling, management, and quality assurance.
• Proficiency with SQL, Python, or equivalent tools.
• Proficiency in Power Query and Power Automate.
• Fluent in French and English; bilingualism essential for collaboration.
• Experience producing PMO/project reports.

Responsibilities

• Support PMO in analyzing and improving data-driven business needs.
• Ensure consistency and quality of project financial data for weekly PMO reports.
• Design, develop, and enhance analyses, models, and datasets.
• Automate processes using Power Query, Power Automate, and related tools.
• Integrate new data sources (structured/unstructured) into analytics ecosystem.
• Document, industrialize, and operationalize analyses and solutions.
• Support development of PMO KPIs and financial analyses.
• Collaborate with stakeholders to identify data needs and provide solutions.
• Ensure traceability of processes and data flows for auditing.
• Optimize Excel and SharePoint use to boost team efficiency and data quality.

Skills

Excel (advanced)

Data management

SQL

Python

Power Query

Power Automate

Finance/PMO reporting

Bilingual (FR/EN)

Education

Bachelor’s degree

Master’s degree (asset)

Tools

Power Query

Power Automate

SharePoint

Job description

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