Property Acquisitions Controls Officer – Metrolinx

Title of the Job: Property Acquisitions Controls Officer

Location: Canada

Job Description: Job 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.What will I be doing?

• Perform the closing function when acquiring property to ensure timely transfer of funds for ownership to Metrolinx; ensuring proper supporting documentation is in-place for audit purposes.
• Work closely with the property data management database (PETRA) to ensure information is updated correctly and properly reflected in all reporting.
• Integrate and clean property transactions data from various sources to ensure high-quality, accurate reporting in the Estimate at Completion (EAC).
• Develop, improve, and maintain the integration of property transactions data, including the Cost Table, Approval Memo, Budget Table, Memo Registry, and EAC.
• Identify and implement performance optimization techniques to enhance the speed and efficiency of the property forecast and budgets of assigned portfolio of projects within Property Acquisitions.
• Develop and maintain project controls systems to manage key project financials (e.g., budget, forecast, actuals, variance, etc.).
• Develop and maintain dynamic Power BI dashboards and reports to provide actionable insights into business performance and trends.
• Utilize advanced features of Power BI, Power Pivot, Query to create interactive visualizations and custom data models tailored to specific business needs.
• Draft Business Process Requirement Document; prepare technical user guides and business process documentation for the project lifecycle.
• Collect, analyze, and interpret data to evaluate risks and recommend solutions to improve processes and procedures.
• Collaborate with the Property Acquisition Team and Project Cost Controls to gather requirements, analyze data, and identify opportunities for process improvements and optimization.

What Skills and Qualifications Do I Need?

• Completion of a degree in Real Estate, Business Administration, Computer Science, or related discipline – or a combination of education, training and experience deemed equivalent
• Demonstrated experience in business analysis, with a focus on data mapping, data validation, data visualization, data modeling, and financial analysis.
• Experience in real estate transactions, interpreting contracts, lease administration, property accounting, or financial budgeting and reporting.
• Knowledge of budget, project schedule, forecasts, property closings, contract administration, and documentation.
• Knowledge of database concepts, database management software and tools including PowerBI and MS Office Excel (Pivot tables, Power Pivot, formulas, VBA) and experience in using systems and applications, such as Oracle Unifier, Ecosys, MS Project, Visio, Word, PowerPoint or similar.
• Excellent organizational skills with a high attention to detail and a track record of producing accurate work.
• Strong ability to multi-task and perform in a high-pressure environment with multiple deadlines.
• Creative thinking with ability to problem solve on their feet and able to accept challenges and takes the initiative to devise solutions independently.

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-SC1

Company Name: Metrolinx

Salary:

Apply for the job!