Project Controls Analyst- Reporting & Analytics

WSP • Dallas, TX

12h • $130,000 - $159,000 • Hybrid

About The Position

WSP is seeking a Project Controls Analyst to join their Project Controls team. This individual can sit in WSP locations in Texas, Utah, Nevada, or Tennessee. The role involves designing and building advanced Power BI dashboards and reporting tools, developing Power Apps solutions, performing data analysis, standardizing reporting templates, producing progress reports, preparing cost estimates and financial projections, administering cost management/PMIS platforms, and supporting schedule monitoring, vendor selection, change order management, and project close-out reporting.

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

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• Disability coverage
• Life insurance
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level