Project Controls Lead: Reporting & Automation Innovator

WSP Global Inc.

Vancouver (WA)

On-site

USD 180,000 - 190,000

Full time

4 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

WSP Global Inc. seeks an experienced Project Controls Lead - Reporting & Automation to drive reporting, analytics, and automation across major projects. You will own the project controls reporting environment using Microsoft technologies to improve data visibility and reliability.

Lead design and implementation of Power BI dashboards, data models, and automated workflows, partnering with project teams to deliver practical technology solutions that reduce manual work and improve efficiency.

Qualifications

Bachelor's degree in Engineering, Construction Management, Business, Finance, Data Analytics, or a related discipline.
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 PMIS platforms such as e-Builder, Procore, Primavera P6, Microsoft Project, or similar systems, including the ability to integrate or utilize their data.

Responsibilities

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.