Project Controls/PowerBI Specialist

WSP•Ephrata, PA

7d•Hybrid

About The Position

WSP is currently initiating a search for a Project Controls/PowerBI Specialist for our Ephrata, PA office. Some travel to client location will be required. Be involved in projects with our Project Controls & Technology Team and be a part of a growing organization that meets our client’s objectives and solves their challenges. This is a Hybrid position. Your Impact

Requirements

Bachelor’s degree in engineering, Construction Management, Project Management or related field (or equivalent)
7-10 years of combined field and office project controls experience involving large-scale projects
Ability to work in a hybrid-type environment and must be a self-starter.
Experience with dashboard reporting and Microsoft PowerBI is required.
Extensive knowledge of cost estimating methodologies, cost control techniques, and schedule management best practices.
Ability to interface with clients and participate in business development initiatives.
Expert ability with Microsoft Office Suite primarily Excel.
Excellent communication skills, written, oral and interpersonal skills to deal with a high-pressure environment.

Nice To Haves

Candidates with advanced degrees or professional certifications and accreditations in Engineering, Construction Management and related fields are preferred.

Responsibilities

Support the Project Manager and Project Controls Manager in the planning, coordination, and evaluation of project financial performance using data-driven tools and methodologies.
Design, develop, and maintain Power BI dashboards to visualize project health, track key performance indicators (KPIs), and enable real-time performance monitoring across cost, schedule, and risk dimensions.
Utilize Project Management Information Systems (PMIS) (e.g., e-Builder, Primavera Unifier, Procore) to input, manage, and report on project controls data, ensuring consistency and accuracy across systems.
Develop and maintain structured data management processes to ensure integrity, traceability, and version control of project cost, schedule, and change-related data.
Support the implementation of integrated project controls strategies by aligning data from cost, schedule, and procurement sources into cohesive reporting structures.
Assist in the development and enforcement of cost control procedures; track actuals, commitments, and forecasts against approved budgets, and analyze cost variances using both system reports and dashboards.
Collaborate with design, engineering, and construction teams to capture and evaluate value engineering opportunities and cost optimization strategies.
Generate and distribute automated and ad hoc reports from Power BI and PMIS platforms to support project reviews and stakeholder decision-making.
Participate in project meetings, capturing and updating action items related to project controls, data updates, and reporting requirements.
Consolidate and maintain financial and performance data for individual project components, and support the generation of program-level roll-up reports.
Review procurement records, contracts, and funding availability to confirm compliance with approved budgets and funding authorizations.
Track and manage change order data, ensuring timely evaluation of cost and schedule impacts within PMIS and reflecting changes in reporting tools and dashboards.
Contribute to the preparation of project estimates, budgets, forecasts, estimates to complete (ETC), and trend analyses, ensuring consistency of data across all reporting systems.