Project Controls Lead – Reporting & Automation

About the job

This Opportunity

WSP is seeking an experienced Project Controls Lead – Reporting & Automation to lead the development and implementation of reporting, analytics, and automation solutions across major projects and portfolios. This individual will take ownership of the project controls reporting environment, leveraging the Microsoft technology suite to improve data visibility, automate workflows, reduce manual effort, and provide project leadership with reliable, actionable information.

The successful candidate will serve as an innovation leader, partnering with Project Controls Managers and project teams to identify opportunities for process improvement, technology integration, and automation.

Your Impact

• Lead the design, development, and implementation of Power BI dashboards and reporting solutions across assigned projects and portfolios.
• Develop integrated solutions using Power Apps, Power Automate, Microsoft Fabric, and other Microsoft technologies to improve data collection, processing, workflow management, and reporting.
• Establish scalable data models, KPI frameworks, reporting standards, and dashboards that integrate cost, schedule, risk, change, financial, and performance information.
• Work directly with project data from ERP, PMIS, scheduling, financial, and other enterprise systems, developing efficient methods to extract, transform, validate, and integrate information.
• Develop automation solutions using Python, Power Automate, APIs, data pipelines, and other appropriate technologies to reduce repetitive manual processes and improve data reliability.
• Serve as an innovation and continuous improvement leader, proactively identifying opportunities to improve project controls processes, reporting, and overall efficiency.
• Partner with Project Controls Managers and project leadership to evaluate existing processes and recommend practical technology and automation solutions that reduce level of effort and resource requirements.
• Establish appropriate data governance and quality controls to ensure dashboards, automated workflows, and project reporting remain accurate, consistent, and reliable.
• Provide technical leadership and mentoring to project controls personnel in reporting, analytics, automation, and the effective use of Microsoft technologies.

Who You Are

Minimum Requirements

• Bachelor's degree in Engineering, Construction Management, Business, Finance, Data Analytics, Information Systems, or a related discipline, or equivalent relevant experience.
• 10+ years of progressive experience in project controls, reporting, data analytics, PMIS, or technology-enabled delivery supporting major capital projects or programs.
• Advanced experience developing and implementing solutions using Power BI, Power Apps, Power Automate, Microsoft Fabric, and the broader Microsoft data and analytics environment.
• Strong experience with data modeling, dashboard development, KPI reporting, data visualization, and integration of multiple project and enterprise data sources.
• Experience working directly with ERP and financial systems data, including extracting, transforming, validating, and integrating data into project controls reporting solutions.
• Working knowledge of Python, APIs, ETL processes, automation scripts, and data workflows used to automate data processing, reporting, and system integration.
• Strong understanding of project controls principles, including cost, schedule, change, risk, forecasting, earned value, and performance reporting.
• Working knowledge of commercial project controls and PMIS platforms such as e-Builder, Procore, Primavera P6, Microsoft Project, or similar systems, including the ability to integrate or utilize their data.
• Demonstrated ability to independently lead technology and reporting initiatives, identify opportunities for improvement, and translate business requirements into practical solutions.
• Strong communication and leadership skills with the ability to advise Project Controls Managers, project leadership, clients, and technical teams.

WSP Benefits:

WSP provides a comprehensive suite of benefits focused on a providing health and financial stability throughout the employee’s career. These benefits include coverage related to medical, dental, vision, disability, and life; retirement savings; paid sick leave; paid vacation (or other personal time); paid parental leave; and paid time off for purposes of bereavement, voting, and/or attendance at naturalization proceedings.

Compensation:

Expected Salary (all locations): $180,000-$190,000/year

WSP USA is providing the compensation range that the company in good faith believes it might pay and offer for this position, based on the successful applicant’s education, experience, knowledge, skills, abilities in addition to internal equity and specific geographic location. WSP USA reserves the right to ultimately pay more or less than the posted range and offer additional benefits and other compensation, depending on circumstances not related to an applicant’s sex or other status protected by local, state, and/or federal law.

#LI-MP1

About Us

About WSP WSP USA is the U.S. operating company of WSP, one of the world's leading engineering and professional services firms. Dedicated to serving local communities, we are engineers, planners, technical experts, strategic advisors and construction management professionals. WSP USA designs lasting solutions in the buildings, transportation, energy, water and environment markets. With more than 15,000 employees in over 300 offices across the U.S., we partner with our clients to help communities prosper.

www.wsp.com

WSP provides a flexible and agile workplace model while meeting client needs. Employees are also afforded a comprehensive suite of benefits including medical, dental, vision, disability, life, and retirement savings focused on providing health and financial stability throughout the employee’s career.

At WSP, we want to give our employees the challenges they seek to grow their careers and knowledge base. Your daily contributions to your team will be essential in meeting client objectives, goals and challenges. Are you ready to get started?

WSP USA (and all of its U.S. companies) is an Equal Opportunity Employer Race/Age/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Disability or Protected Veteran Status.

The selected candidate must be authorized to work in the United States.

NOTICE TO THIRD PARTY AGENCIES:

WSP does not accept unsolicited resumes from recruiters, employment agencies, or other staffing services. Unsolicited resumes include any resume or hiring document sent to WSP in the absence of a signed Service Agreement where WSP has expressly requested recruitment/staffing services specific to the position at hand.  Any unsolicited resumes, including those submitted to hiring managers or other business leaders, will become the property of WSP and WSP will have the right to hire that candidate without reservation – no fee or other compensation will be owed or paid to the recruiter, employment agency, or other staffing service.

Additional Information

• Job Identification: 98474
• Job Category: Project and Program Management
• Posting Date: 2026-10-29
• Locations: 1207 Washington Street, Vancouver, WA, 98660, US ()