OPEN: Project Controls Officer

We are currently requesting resumes for the following position: Project Controls Officer

Resume Due Date: Friday, August 14^th, 2026 (5:00PM EST)

Job ID: 26-084

Number of Vacancies: 1

Level: MP4

Duration: 24 Months

Hours of work: 35 hours per week

Location:  Pickering

Work Mode: 100% on Site

Hourly Range: $74-84

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.

Our client is dedicated to promoting employment equity and encourages applications from equity-seeking communities including but not limited to: Indigenous Peoples, racialized individuals, persons with disabilities, and women. Our client aims to build a diverse team that reflects the communities it serves, enhancing its ability to meet their needs. We are committed to an inclusive and accessible work environment and invites all qualified individuals to apply, offering accommodations during the application, interview and onboarding process as needed. This effort supports our client’s long-term strategy for equity, diversity, and inclusion.

CPUS Engineering employs artificial intelligence (AI) tools as part of its recruitment process to enhance efficiency and consistency. These tools may assist with activities such as application screening, candidate evaluation, and summarization of interview feedback.

AI-generated outputs are intended to supplement, not replace, human judgment. All final hiring decisions are made by qualified human decision-makers who exercise professional discretion in reviewing and assessing candidate information alongside any AI-generated insights.

CPUS Engineering ensures that the use of AI in recruitment complies with all applicable employment laws, human rights legislation, and privacy regulations. The organization is committed to maintaining fairness, transparency, and non-discrimination throughout the hiring process.