Project Controls Analyst: Power BI Dashboards & Analytics

WSP in the U.S.; Dallas (TX); On-site; USD 130,000 - 159,000; Full time

Benefits offered by this job

Medical, dental, vision

Retirement savings

Paid time off

Parental leave

Flexible workplace model

Job summary

WSP USA is seeking a Project Controls Analyst to join our Project Controls team, with the option to sit in Texas, Utah, Nevada, or Tennessee. You will design and build Power BI dashboards, develop Power Apps, and analyze project data to drive actionable insights for cost, schedule, and performance.

Ideal candidates hold a bachelor's degree and 7+ years of project controls experience, with strong skills in forecasting, budgeting, EVM, and familiarity with PMIS tools like e-Builder and Procore.

Qualifications

• Bachelor's degree in a related field.
• 7+ years of experience in project controls on large capital projects.
• Hands-on expertise building Power BI dashboards and reports; Power Apps for workflow/data collection.
• Strong cost forecasting, budgeting, and earned value management (EVM) skills.
• Familiarity with PMIS/scheduling platforms such as e-Builder, Procore, Primavera P6, or MS Project.

Responsibilities

• Design and build advanced 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 to identify trends, anomalies, and opportunities to improve reporting accuracy and decision-making.
• Standardize reporting templates and KPI tracking across projects for data integrity feeding into dashboards.
• Produce regular progress reports for the Program Manager and PMO with executive-level summaries.
• Prepare cost estimates, budgets, forecasts, cash flows, and financial projections; support EVM tracking and reporting.
• Administer cost management/PMIS platforms; support tracking of acquisition packages for reimbursement and invoice review.
• Provide input on schedules and flag discrepancies for review by the Program Manager.
• Support vendor selection, contractor progress tracking, change orders, and project close-out reporting.

Skills

Power BI dashboards

Power Apps

Excel

Word

PowerPoint

EVM

Budgeting

Forecasting

Scheduling

Data analysis

Education

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

Tools

e-Builder

Procore

Primavera P6

Microsoft Project

Job description

WSP USA is seeking a Project Controls Analyst to join our Project Controls team, with the option to sit in Texas, Utah, Nevada, or Tennessee. You will design and build Power BI dashboards, develop Power Apps, and analyze project data to drive actionable insights for cost, schedule, and performance.

Ideal candidates hold a bachelor's degree and 7+ years of project controls experience, with strong skills in forecasting, budgeting, EVM, and familiarity with PMIS tools like e-Builder and Procore.