26-084 Project Controls Officer

Title:Project Controls Officer 26-084
Resume Due Date:Friday August 14^th 2026 (5:00PM EST)

Number of Vacancies: 1

Level:MP4 $75 - $85/hr INC

Duration: 24 Months

Hours 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 cost
• forecasts and performance reports throughout the project lifecycle Change Management:
• Perform/Support project controls and change management activities by maintaining project cost
• and 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 project
• execution 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.