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
SYSTRA is one of the world's leading engineering and consultancy groups specialising in public transport and mobility solutions. For more than 65 years, the Group has been committed to helping cities and regions to contribute to their development by creating, improving and modernising their transport infrastructure.
With its 11,000 employees, the Group's mission is to connect people and bring territories closer together in the 80 countries where it operates. By making travel more fluid, the infrastructures designed by SYSTRA bring communities together, develop social integration and facilitate access to employment, education and leisure.
A benchmark signature for transport solutions, SYSTRA supports its partners and clients throughout the lifecycle of their projects. SYSTRA is involved at a very early stage in the design phase, right through to the deployment and maintenance test phases. SYSTRA provides all of its services in more than 80 countries worldwide and generates 76% of its turnover internationally.
KEY FIGURES
- €1.1 bn in sales in 2023
- 3rd international engineering company for Mass Transit & Rail*
- 4th for Bridges*
- 6th in the Transport sector*
- Engineering News-Record (ENR) ranking, 2023-2024
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
SYSTRA is one of the world's leading engineering and consultancy groups specialising in public transport and mobility solutions. For more than 65 years, the Group has been committed to helping cities and regions to contribute to their development by creating, improving and modernising their transport infrastructure.
With its 11,000 employees, the Group's mission is to connect people and bring territories closer together in the 80 countries where it operates. By making travel more fluid, the infrastructures designed by SYSTRA bring communities together, develop social integration and facilitate access to employment, education and leisure.
A benchmark signature for transport solutions, SYSTRA supports its partners and clients throughout the lifecycle of their projects. SYSTRA is involved at a very early stage in the design phase, right through to the deployment and maintenance test phases. SYSTRA provides all of its services in more than 80 countries worldwide and generates 76% of its turnover internationally.
KEY FIGURES
- €1.1 bn in sales in 2023
- 3rd international engineering company for Mass Transit & Rail*
- 4th for Bridges*
- 6th in the Transport sector*
- Engineering News-Record (ENR) ranking, 2023-2024