PMO Financial Analyst – Alto Project

Job summary

Support the PMO by analyzing business needs, ensuring the integrity of project financial data, and developing automated analysis models. Collaborate with stakeholders to create KPIs and optimize data flows for the ALTO infrastructure project.

Job details

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]. Workplace Type

What you’ll do

Support the PMO by analyzing business needs, ensuring the integrity of project financial data, and developing automated analysis models. Collaborate with stakeholders to create KPIs and optimize data flows for the ALTO infrastructure project.

Requirements

Requires a Bachelor's degree in a quantitative field and 2 to 3 years of experience in a similar financial or data analyst role. Proficiency in Excel, Power Query, Power Automate, and bilingualism in English and French are essential.

Listed skills

• SQL · Preferred
• Microsoft Excel · Preferred
• Financial analysis · Preferred
• data management · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Excel
• Data Management
• SQL
• Python
• Power Query
• Power Automate
• Financial Analysis
• KPI Development
• Data Modeling
• Bilingualism (English/French)
• Project Management Office (PMO)
• Data Quality Assurance

Job areas

• Finance & Accounting
• Data & Analytics
• Engineering
• Transportation
• Consulting