About the role
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
Reporting into the Reporting Lead, the Reporting Coordinator is responsible for delivering all aspects of reporting for the project. This involves working with key stakeholders to define and develop meaningful reports – including dashboards and other analytics products, hold regular performance reviews, and enable diverse stakeholder audiences to use those products allowing for data-driven decision making on the project.
Missions/Main Duties
- Work with client and all functional teams such as scheduling, cost/accounting, risk, communication, Health & Safety, construction and others to gather their reporting needs and locate their data.
- Create data connections and transform data from various ERP sources such as Unifier, P6, EcoSys and Aconex. Design and implement apps, forms and lists to gather non-ERP and non-structured data.
- Support the design and develop fully automated PowerBI dashboards reporting on project performance.
- Support the assembly, review, editing and submission of all reporting outputs, not limited to the PowerBI reports, including the monthly and quarterly progress reports and other ad hoc reports as may be required.
- Assisting Management in interpreting the Project and Program report information.
- Work with the Management of the cross-functional teams to develop and introduce continuous improvements to enhance report quality.
- Any additional duties, as deemed necessary to support the deliverables and Key Activities during ASP.
Profile/Skills
- A solid background in project controls of large capital engineering and construction projects, with at least 3 years of experience in calculating project controls key performance indicators (KPIs) from raw data and design of reports.
- Minimum 3 years' experience with extract, transform and load (ETL) process and data visualization with Power BI. 1 year experience with the rest of the Power Platform such as Power Automate, Dataverse and Power Apps is a major asset. Knowledge of Python (Matplotlib) and R Script visualization is a major asset.
- Bachelor’s degree or College Diploma in a related field with a minimum of 5 years of experience in project controls.
- Working experience with Primavera P6, MS Project and other Earned Value and PMIS tools is an asset.
- Have or are working towards professional accreditation with PMI and AACE.
- Advanced skills with relational and multidimensional database schemas. Experience with Data Warehouse architecture and OLAP data source is an asset.
- Experience with 3D BIM is an asset.
- Familiarity with reporting and business intelligence platforms in the Construction industry is an asset.
SYSTRA Canada is committed to having a diverse and inclusive workforce.
« SYSTRA Canada has an equal access employment program and encourages women, Indigenous peoples, visible minorities, and people with disabilities to apply. »
Note: In this description, the masculine gender is used for easy reading purposes and includes the feminine.
About SYSTRA Canada
SYSTRA Canada, membre du groupe SYSTRA, est une firme d’ingénierie et de consultation, principalement dédiée au transport des personnes et des marchandises.
Notre offre de services est groupée en trois marchés.
- Transport : dédié principalement au marché canadien du transport de passagers.
- Matériel roulant : offre des solutions clé en main pour les voitures de passagers, les wagons et les locomotives.
- Intercités et ferroviaire lourd : fournit des solutions spécifiquement adaptées au rail classique, à la fois pour le transport de passagers et des ressources minières et de marchandises.
SYSTRA Canada est une firme innovante qui fournit des services de consultation, d’ingénierie et de gestion de projets dans tous les secteurs du transport, dont la voie et l’infrastructure, le matériel roulant, l’exploitation ferroviaire, la signalisation et les télécommunications, les études économiques et financières, la commercialisation, le domaine institutionnel et les services d’appoint.
SYSTRA Canada, part of the SYSTRA group, is an engineering and consulting firm whose primary focus is to offer transportation solutions for passengers or goods.
Our service offer is grouped into three markets.
- Transit: focusing on the Canadian passenger mobility market.
- Rolling Stock: offering turnkey solutions for passenger cars, wagons and locomotives.
- Intercity & Heavy Rail: providing our clients with specific conventional rail solutions for transportation of both passengers and freight/mining resources.
We deliver innovative consulting, engineering and project management services in all fields of transportation, including track and infrastructure, rolling stock, railway operations, signalling and telecommunications, economic and financial studies, marketing, institutional and management consulting, as well as support services.
About the role
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
Reporting into the Reporting Lead, the Reporting Coordinator is responsible for delivering all aspects of reporting for the project. This involves working with key stakeholders to define and develop meaningful reports – including dashboards and other analytics products, hold regular performance reviews, and enable diverse stakeholder audiences to use those products allowing for data-driven decision making on the project.
Missions/Main Duties
- Work with client and all functional teams such as scheduling, cost/accounting, risk, communication, Health & Safety, construction and others to gather their reporting needs and locate their data.
- Create data connections and transform data from various ERP sources such as Unifier, P6, EcoSys and Aconex. Design and implement apps, forms and lists to gather non-ERP and non-structured data.
- Support the design and develop fully automated PowerBI dashboards reporting on project performance.
- Support the assembly, review, editing and submission of all reporting outputs, not limited to the PowerBI reports, including the monthly and quarterly progress reports and other ad hoc reports as may be required.
- Assisting Management in interpreting the Project and Program report information.
- Work with the Management of the cross-functional teams to develop and introduce continuous improvements to enhance report quality.
- Any additional duties, as deemed necessary to support the deliverables and Key Activities during ASP.
Profile/Skills
- A solid background in project controls of large capital engineering and construction projects, with at least 3 years of experience in calculating project controls key performance indicators (KPIs) from raw data and design of reports.
- Minimum 3 years' experience with extract, transform and load (ETL) process and data visualization with Power BI. 1 year experience with the rest of the Power Platform such as Power Automate, Dataverse and Power Apps is a major asset. Knowledge of Python (Matplotlib) and R Script visualization is a major asset.
- Bachelor’s degree or College Diploma in a related field with a minimum of 5 years of experience in project controls.
- Working experience with Primavera P6, MS Project and other Earned Value and PMIS tools is an asset.
- Have or are working towards professional accreditation with PMI and AACE.
- Advanced skills with relational and multidimensional database schemas. Experience with Data Warehouse architecture and OLAP data source is an asset.
- Experience with 3D BIM is an asset.
- Familiarity with reporting and business intelligence platforms in the Construction industry is an asset.
SYSTRA Canada is committed to having a diverse and inclusive workforce.
« SYSTRA Canada has an equal access employment program and encourages women, Indigenous peoples, visible minorities, and people with disabilities to apply. »
Note: In this description, the masculine gender is used for easy reading purposes and includes the feminine.
About SYSTRA Canada
SYSTRA Canada, membre du groupe SYSTRA, est une firme d’ingénierie et de consultation, principalement dédiée au transport des personnes et des marchandises.
Notre offre de services est groupée en trois marchés.
- Transport : dédié principalement au marché canadien du transport de passagers.
- Matériel roulant : offre des solutions clé en main pour les voitures de passagers, les wagons et les locomotives.
- Intercités et ferroviaire lourd : fournit des solutions spécifiquement adaptées au rail classique, à la fois pour le transport de passagers et des ressources minières et de marchandises.
SYSTRA Canada est une firme innovante qui fournit des services de consultation, d’ingénierie et de gestion de projets dans tous les secteurs du transport, dont la voie et l’infrastructure, le matériel roulant, l’exploitation ferroviaire, la signalisation et les télécommunications, les études économiques et financières, la commercialisation, le domaine institutionnel et les services d’appoint.
SYSTRA Canada, part of the SYSTRA group, is an engineering and consulting firm whose primary focus is to offer transportation solutions for passengers or goods.
Our service offer is grouped into three markets.
- Transit: focusing on the Canadian passenger mobility market.
- Rolling Stock: offering turnkey solutions for passenger cars, wagons and locomotives.
- Intercity & Heavy Rail: providing our clients with specific conventional rail solutions for transportation of both passengers and freight/mining resources.
We deliver innovative consulting, engineering and project management services in all fields of transportation, including track and infrastructure, rolling stock, railway operations, signalling and telecommunications, economic and financial studies, marketing, institutional and management consulting, as well as support services.