Data & Reporting Specialist

Metrolinx

  • Canada
  • Permanent
  • Full-time
  • 1 day ago
Job Category: Administrative and ClericalJob Description:Metrolinx is connecting communities across the Greater Golden Horseshoe. Metrolinx operates GO Transit and UP Express, as well as the PRESTO fare payment system. We are also building new and improved rapid transit, including GO Expansion, Light Rail Transit routes, and major expansions to Toronto's subway system, to get people where they need to go, better, faster and easier. Metrolinx is an agency of the Government of Ontario.At Metrolinx, equity, diversity and inclusion are essential to living our values of serving with passion, thinking forward and playing as a team.CPG's workforce is made up of driven and dedicated professionals who care deeply about working together to deliver infrastructure and make a positive impact in our communities. Join us as we build a knowledgeable and collaborative team that courageously changes how transit projects will be delivered.The Resource, Strategy and Optimization team is seeking a Data and Reporting Specialist to work with data and trends, including extracting data; providing ad hoc reporting; analyzing retention rates; developing forecasts related to talent resources/hiring; and scenario-building related to employee resources as it pertains to the Capital Projects Group within Metrolinx (CPG). The role involves working with Power BI and putting together PPT presentations, with experience with database software like MS Azure being a strong asset.Up to 12 months Contract roleWhat will I be doing?
  • Develops and implements data management strategies and data collection systems including the design and development of relational databases for information management and retrieval that optimize statistical efficiency, data quality and supports evidence based decision making.
  • Imports, cleans, transforms, validates and models data to improve data quality and to ensure the accuracy, currency and integrity of data which is used to identify issues and provide insight into analysis results and recommendations for improvements.
  • Identifies, analyses, and interprets trends or patterns in complex data sets using Data Definition Language or Data Manipulation Language commands for data gathering and analysis activities; produces ongoing and ad hoc reports and dashboards that identify issues, provide insight into results and outline recommendations for process improvements to resolve operational, business and system issues.
  • Presents data in dashboards, charts, graphs and/or tables by building, designing and maintaining online applications such as data input/data collection screens to capture and present meaningful information/data for reporting, analysis and presentation purposes for use by management, internal business units and stakeholders in identifying and implementing process improvements.
  • Develops and maintains a comprehensive and up-to-date knowledge of internal and external data sources relevant to operational, business and systems data to design and build meaningful databases that centralizes data for internal stakeholders to access.
  • Liaises with internal stakeholders and business units to identify relevant data which can be shared and will contribute to the data collection process as well as to determine stakeholder and business unit specific data/information needs.
  • Liaises with counterparts in other transit and enforcement agencies to gather and share information on data management and collection strategies, operational, business together with system issues and best practices.
  • Contributes to the identification and development of new process improvement opportunities for operational, business and systems activities through the development and implementation of data management and collection strategies as well as the analysis of data to support process improvements and evidence based decision making.
  • Provides subject matter expertise to internal stakeholders and business units to provide technical advice, assist with data interpretation, needs analysis and provide insight and commentary for decision making purposes.
  • Develops reports based on accurate resourcing and project information and analyzes information to flag potential challenges within the capital program.
  • Implements and continually improves the data collection and tracking mechanisms associated with monitoring progress towards document completion, including approvals, dates, reviews, timelines and supporting documentation associated with contractual requests.
What Skills and Qualifications Do I Need?
  • Completion of a degree in Engineering, Business Analytics or IT or a combination of education, training and experience deemed to be equivalent.
  • Demonstrated years of relevant experience
  • Experience in a Data Analyst or similar role, with a background in technology, information management, relational database design and development, business intelligence, data mining or statistics.
  • Knowledge of relational database concepts, database management software and tools and computer applications including MS Office Excel (Pivot tables, Power Pivo Power BI, Power App) and SQL queries.
  • Technical expertise in the use and application of data modelling, database design, development, investigative and data mining methods and techniques.
  • Analytical and problem-solving skills to collect, organize, analyze, and disseminate significant amounts of information with strict attention to detail and accuracy.
  • Critical-thinking skills to identify trends in data and provide insight into results and outline recommendations.
  • Interpersonal and relationship management skills to liaise with stakeholders and business units to identify/manage data/information requirements.
  • Verbal and written communication skills to prepare reports, update and brief management; provide information and explanations of a technical nature to a range of internal stakeholders
Don't Meet Every Requirement?If you're excited about working with Metrolinx but your past experience doesn't quite align with every qualification of this posting, we encourage you to apply. You just might be the right candidate for this or other roles. We are always looking for great talent to join our team.We invite all interested individuals to apply and encourage applications from members of equity-deserving communities, including those who identify as Indigenous, Black, racialized, women, people with disabilities, and people with diverse gender identities, expressions and sexual orientations.Accommodation:We value the unique skills and experiences each person brings to Metrolinx and are committed to creating and maintaining an inclusive and accessible environment. We are committed to the requirements of the Accessibility for Ontarians with Disabilities Act so if you require accommodation during the hiring process, please let our Recruitment team know by contacting us at: 416-202-5601 or email .Application Process:All applicants must be legally entitled to work in Canada. Metrolinx will be using email to communicate with you for all job competitions. It is your responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time-sensitive correspondence, we recommend that you check your email regularly. If no response is received, we will assume you are no longer interested in pursuing the opportunity. Please be advised that a Criminal Record Check may be required of the successful candidate.For Internal applicants, with the recent implementation of the Internal Mobility Policy, the internal recruitment process has changed for non-union roles. Candidates must be in their current role for 12 months prior to applying for another role and each applicant must be in good standing (not participating in a Performance Improvement Plan). Please review all provisions of the before submitting your application.Should it be determined that any background information provided is misleading, inaccurate or incorrect, Metrolinx reserves the right to discontinue with the consideration of your application.We thank all applicants for their interest, however, only those selected for further consideration will be contacted.WE ARE AN EQUITABLE AND INCLUSIVE EMPLOYER.#LI-MM3 #LI-Onsite

Metrolinx