Project Controls Analyst- Reporting & Analytics

WSP USA; Brentwood (TN); On-site; USD 130,000 - 159,000; Full time

Benefits offered by this job

Medical, dental, vision

Retirement savings

Paid time off

Job summary

WSP USA is seeking a Project Controls Analyst to join our Project Controls team. The role can sit in WSP locations in Texas, Utah, Nevada, or Tennessee, with a focus on advanced Power BI dashboards and Power Apps to streamline data collection and workflow automation.

You will perform data analysis on large-scale capital projects, standardize reporting templates, and support EVM, budgeting, and scheduling using PMIS tools like e-Builder, Procore, or Primavera P6.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 7+ years of experience in project controls, reporting, and data analysis on large-scale capital projects.
• Demonstrated expertise building Power BI dashboards and reports; strong Power Apps knowledge.
• Experience with cost forecasting, budgeting, and earned value management (EVM).
• Familiarity with PMIS/scheduling platforms like e-Builder, Procore, Primavera P6, MS Project.

Responsibilities

• Design and build Power BI dashboards and reporting tools for KPI visibility across cost, schedule, and performance metrics.
• Develop Power Apps solutions to streamline data collection, approvals, and workflow automation.
• Analyze project data sets to identify trends and improve reporting accuracy and decision-making.
• Standardize reporting templates and KPI tracking across projects for data integrity in dashboards.
• Produce progress reports for the Program Manager and PMO, including executive summaries and client deliverables.
• Prepare cost estimates, budgets, forecasts, cash flows, and financial projections; support EVM tracking.

Skills

Power BI

Power Apps

Excel

EVM

PMIS

Education

Bachelor's degree in Business, Finance, Accounting, Engineering, Construction Management, or equivalent

Tools

e-Builder

Procore

Primavera P6

MS Project

Job description

This Opportunity

WSP is seeking a Project Controls Analyst to join our Project Controls team. This individual can sit in our WSP locations in either Texas, Utah, Nevada, or Tennessee.

Your Impact

• Design and build advanced Power BI dashboards and reporting tools that give leadership and clients clear, actionable KPI visibility across cost, schedule, and performance metrics.

• Develop Power Apps solutions to streamline data collection, approvals, and workflow automation across project controls functions.

• Perform data analysis across project data sets, identifying trends, anomalies, and opportunities to improve reporting accuracy and decision‑making.

• Standardize reporting templates and KPI tracking frameworks across projects, ensuring consistency and data integrity feeding into Power BI dashboards.

• Produce regular progress reports for the Program Manager and PMO, translating project data into clear executive‑level summaries, memos, and client deliverables.

• Prepare cost estimates, budgets, forecasts, cash flows, and financial projections; support earned value management (EVM) tracking and reporting.

• Administer cost management/PMIS platforms (e.g., e-Builder, Procore, or similar); support tracking of acquisition packages for reimbursement and invoice review.

• Provide supporting input on program/project schedules, helping monitor contractor and consultant schedule data and flag discrepancies for review by the Program Manager.

• Support vendor selection, contractor progress tracking, change order management, and project close‑out reporting as needed.

Who You Are

Minimum Requirements:

• Bachelor's degree in Business, Finance, Accounting, Engineering, Construction Management, or equivalent.

• 7+ years of experience in project controls, reporting, and data analysis on large‑scale capital projects.

• Reporting & BI Tools: Demonstrated hands‑on expertise building Power BI dashboards and reports; strong working knowledge of Power Apps for workflow/data collection tools; advanced Excel, Word, and PowerPoint skills.

• Working knowledge of cost forecasting, budgeting, and earned value management (EVM) practices.

• Familiarity with scheduling concepts and PMIS/scheduling platforms such as e-Builder, Procore, Primavera P6, or Microsoft Project (supporting‑level proficiency).

• Strong analytical and problem‑solving skills, with keen attention to detail in dashboard/report accuracy and the ability to manage multiple priorities in a fast‑paced environment.

• Strong written and verbal communication skills, with the ability to translate complex data into clear insights for both technical teams and executive stakeholders.

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.

• coverage related to medical, dental, vision, disability, and life;
• retirement savings;
• paid sick leave;
• paid vacation (or other personal time);
• paid parental leave;
• paid time off for purposes of bereavement, voting, and/or attendance at naturalization proceedings.

Compensation:

Expected Salary (all locations): $130,000-159,000/yr

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.

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.