26-084 - Project Controls Officer

Title: Project Controls Officer 26-084Resume Due Date: Friday, August 14th, 2026 (5:00PM EST)                                            Number of Vacancies: 1Level: MP4,  $75 - $85/hr INCDuration: 24 MonthsHours of work: 35 hours   Location:  Pickering (100% on Site)Job Overview: MS Excel & Power BI:
Design, develop, and maintain complex Microsoft Excel workbooks, worksheets, dashboards, and analytical tools to support business planning, reporting, and decision-making.Analyze and understand existing spreadsheet architectures, formulas, macros, data connections, and reporting processes to ensure modifications are implemented without disrupting current functionality.Overhaul, modernize, and optimize legacy Excel workbooks while preserving critical business logic, calculations, data integrity, and user requirements.Maintain and troubleshoot existing Excel solutions, resolving issues related to formulas, VBA code, data validation, linked workbooks, and automated reporting processes.Develop advanced Excel solutions using complex formulas, Power Query, Power Pivot, dynamic arrays, pivot tables, VBA, and automation techniques.Design, develop, and maintain complex Microsoft Excel workbooks, worksheets, dashboards, and analytical tools to support business planning, reporting, and decision-making.Analyze and understand existing spreadsheet architectures, formulas, macros, data connections, and reporting processes to ensure modifications are implemented without disrupting current functionality.Overhaul, modernize, and optimize legacy Excel workbooks while preserving critical business logic, calculations, data integrity, and user requirements.Maintain and troubleshoot existing Excel solutions, resolving issues related to formulas, VBA code, data validation, linked workbooks, and automated reporting processes.Develop advanced Excel solutions using complex formulas, Power Query, Power Pivot, dynamic arrays, pivot tables, VBA, and automation techniques.
 Project Monitoring & Control:
Perform/Support project controls activities by developing and maintaining project schedules, costforecasts, and performance reports throughout the project lifecycle Change Management:Perform/Support project controls and change management activities by maintaining project costand schedule baselines, ensuring compliance with approved change control processes, and preparing required change documentation.
Cost & Schedule Quality:
Maintain/Support accurate project cost and schedule information throughout all phases of projectexecution including reconciling data across financial and project controls systems to support effective project planning, execution, and decision-making.
 Qualifications
Expert-level proficiency in Microsoft Excel.Advanced knowledge of VBA, Power Query, Power Pivot, Pivot Tables, complex formulas, and spreadsheet automation.Strong experience developing and maintaining Power BI dashboards, reports, semantic models, and DAX calculations.Ability to reverse-engineer, maintain, and enhance highly complex existing spreadsheets and reporting tools.Strong analytical, problem-solving, and troubleshooting skills.Experience integrating data from ERP, scheduling, financial, project controls, or enterprise systems.Excellent documentation, communication, and stakeholder engagement skills.