Project Controls Analyst: Power BI Dashboards & Apps

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

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.