Job Description (CONTRACT UP TO 6 MONTHS) 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.

Our Real Estate Asset Management Office is looking for a 6-month contract Asset Management Analyst to provide expertise and coordinate the development and implementation of real estate asset management strategy through data management strategies, data collection systems, data visualizations and process mapping for Real Estate and Development department. Identify, analyze and interpret data trends/issues and make recommendations for improvement to business, operations and system processes.

What will I be doing?

• Supports data management strategies by designing and implementing relational databases and data collection systems to optimize data quality, statistical efficiency, and enable evidence-based decision-making for real estate assets.
• Manages the full data lifecycle—importing, cleaning, transforming, validating, and modeling data to ensure accuracy, relevance, and usability for business and operational insights.
• Analyzes complex datasets, including real estate transactions, to identify trends and patterns using Data Definition Language or Data Manipulation Language commands (i.e. SQL) to support data-driven decision-making.
• Assists in executing the Real Estate Asset Management Strategy, including lifecycle data management, asset registry development, classification standards, and improving data maturity and integration across systems.
• Prepares, consolidates, and maintains real estate asset reporting, delivering dashboards and ad hoc reports that highlight key insights, operational issues, and actionable recommendations to present information for management and stakeholders.
• Maintains a current knowledge base of internal/external data sources to develop centralized, accessible databases supporting business operations.
• Develops KPI tracking systems to monitor asset performance, support preventative maintenance, and ensure compliance with asset management standards throughout the asset lifecycle.
• Maintains a reporting system for tracking procurement activities, service delivery, budgets (OPEX/CAPEX), and vendor performance to support cost estimation, contract negotiation, and compliance with procurement guidelines.
• Conducts gap analyses between systems and business processes using analytics to identify improvement opportunities, enhance system integrations, and support implementation of new solutions.
• Analyzes and maps operational and project-related processes to identify inefficiencies and contributes to process optimization efforts including documentation (e.g., asset information standards, data dictionaries, governance protocols, procurement workflows).
• Recommends and supports technology and process automation initiatives to improve efficiency, reduce costs, and streamline operations.
• Liaises with internal teams and external stakeholders (e.g., Metrolinx business units, government agencies, municipalities, rail partners) to align on data sharing, data collection and consolidation processes, and evolving information requirements.
• Participates in data governance and asset management committees to align tools, systems, and protocols, and to contribute to cross-functional data and tools improvement efforts.
• Supports various asset management initiatives and projects, and performs other duties as assigned.

What Skills and Qualifications Do I Need?

• Demonstrated experience and advanced knowledge of relational database concepts, database management software, automation, and tools and computer applications including Power BI, Tableau, Power Queries, MS Office Excel (Pivot tables, Power Pivot, formulas such as vlookups, xlookups, sumif, countif, textjoin/CONCATENATE, conditional formatting, VBA), SQL/DAX queries, Python, Microsoft Office Suite (Word, Excel, Outlook, Project, Access, Visio, PowerPoint, SharePoint), and Power Automate.
• Technical expertise in the use and application of data modelling, database design, development, investigative and data mining methods and techniques such as exploration, pattern identification for validation and verification.
• Demonstrated ability to perform both quantitative and qualitative research.
• Analytical and problem-solving skills to collect, organize, analyze, and disseminate significant amounts of information/data with strict attention to detail and accuracy.
• Critical-thinking/big picture-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.
• Ability to learn new software and tools in an efficient manner.
• Experience with software applications such as Oracle Primavera Unifier, Oracle e-Business Suite including iProcurement/procure-to-pay, HxGN EAM, EDRMS, OpenText, GIS and/or other enterprise asset management (EAM) applications would be an asset.
• Knowledge of: ISO 55000 - Asset Management, ISO 19650 – Building Information Modelling preferred.
• Demonstrated ability to function in a team environment, manages, develop and execute training programs.
• Must be able to adapt and prioritize, meeting deadlines, in a fast-paced environment through effective time management/multi-tasking and decision-making skills

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 hr.recruitment@metrolinx.com .

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 policy before submitting your application.

Should it be determined that any background information provided be 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.