Data Analyst & Reports Developer


Job Description


Crosslinx Transit Solutions (CTS) is a consortium comprised of EllisDon, SNC-Lavalin, Aecon, and ACS - Dragados. CTS has been selected by Metrolinx and Infrastructure Ontario to deliver the Eglinton Crosstown Light Rail Transit Project and is seeking highly qualified, experienced personnel to join the team of this complex P3 design and construction project

The Data Analyst & Reports Developer position will be within the Systems Integration Team with primary focus on collecting missing data from vendors and project managers / package leads. Much of this data is project-wide asset data that needs to reside in our CMMS software (QFM).


The person in this role will perform tasks as directed by the Systems Integration Authority:

  • Collect and prepare all data to be imported into our CMMS software such as geography, assets, planned preventative maintenance schedules, Testing & Commissioning events, asset lifecycle, personnel, contractor
  • Champion the Asset Data Sync (ADS) system (SharePoint to QFM) and related project deliverables
  • Interface with CMMS vendor on a weekly basis
  • Build dashboards and reports as required
  • Perform other tasks as requested for the Systems Integration Team


  • Bachelor's degree or college diploma related to engineering, technology, or computer science, or sufficient work experience in a related field
  • 5+ years prior work experience in a similar role
  • QFM or other CMMS, IWMS, CAFM asset management software experience is ideal
  • AFP / PPP / P3 payment mechanism or performance-based contracts knowledge
  • Sound knowledge of MS Office
  • Must be an MS Excel wizard (data manipulation, preparation for database importing)
  • Knowledge on topics such as: String manipulation, schemas, data types, barcoding, ETL, SFTP, web services, APIs (SOAP, RESTful), XML
  • Solid understanding of SQL
  • MS Power BI reporting and dashboard design skills
  • MS SharePoint design and good housekeeping skills
  • Crystal Reports exposure
  • Keen attention to detail and accuracy of data is paramount
  • Technically knowledgeable, exemplar communication skills, motivated self-starter, team player
  • Python experience is an asset

FindTheBestJob is a free service and does not charge a fee at any stage of application or recruitment process. Don’t provide your bank account or credit card details to anyone during job application. FindTheBestJob does not guarantee the availability of a job since organizations may end applications earlier than due date.

Apply Now