19-079 – Reporting & Systems Analyst

Clarington, Ontario
Job ID:
Arpitha Sumukharya

We are currently requesting resumes for the following position: Reporting & Systems Analyst
Resume Due Date:  Thursday August 22nd (5:00 PM EST)
Number of Vacancies: 1
Duration: 3 years
Location: Darlington Energy Complex – 1855 Energy Drive, Clarington

Job Overview

  1. Administration of the automated reporting websites on SharePoint, using JavaScript to enhance the user experience on the SharePoint sites and the development of automated reports for teams executing projects. 
  2. The automated reports are built using SQL Server Reporting Services (SSRS) and are hosting on the SharePoint site with access to the reports being controlled by SharePoint groups.  The automated reports connect to an integrated data warehouse using Structured Query Language (SQL) queries and are created per user specifications to help projects track their performance.
  3. The SharePoint site is enhanced using HTML and JavaScript in order to provide users a more convenient interface to access the automated reports and consume the data from an integrated data warehouse.  This includes a project summary website that was built primarily using the D3.js JavaScript library, with reporting websites created for each business unit in OPG and a troubleshooting website that walks users through common data errors and helps identify how to resolve them.


  1. Engineering degree or equivalent training/experience
  2. Bachelors or Computer Science/Engineering or related post-secondary education.
  3. Building and maintaining SharePoint sites using JavaScript and in particular the library D3.js.
  4. Building and maintaining SharePoint groups and report subscriptions.
  5. Developing T-SQL queries to access information from an integrated data warehouse
  6. Building and maintaining automated reports using SQL Server Reporting Services (SSRS)
  7. Working experience with the following would be considered an asset:
  • Building and maintaining automated reports using Power BI
  • Project controls/management in large construction project
  • Primavera P6
  • Hexagon EcoSys