Project Controls Analyst- Reporting & Analytics

WSP; Dallas (TX); On-site; USD 130,000 - 159,000; Full time

Job summary

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

You will design and build Power BI dashboards and reporting tools, develop Power Apps solutions to streamline data collection, and perform data analysis across project data sets to improve reporting accuracy and decision-making. You will also support EVM tracking, PMIS platforms, and schedule data review for multiple high-value projects.

Qualifications

• 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.

Responsibilities

• Design and build advanced Power BI dashboards and reporting tools with 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 for consistency and data integrity feeding into Power BI dashboards.
• Produce regular progress reports for the Program Manager and PMO, translating project data into executive 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 input on program/project schedules, monitor contractor and consultant schedule data, flag discrepancies for review by the Program Manager.
• Support vendor selection, contractor progress tracking, change order management, and project close-out reporting as needed.

Skills

Analytical thinking

Communication

Time management

Education

Bachelor's degree

Tools

Power BI

Power Apps

Excel

e-Builder

Procore

Primavera P6

Microsoft 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.

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.

#LI-MP1