"Alerted.org

Substation Estimation Analyst

Location **Amarillo**

Secondary Locations

Job Code **18775**

\# of openings **1**

Substation Estimation Analyst

Job Summary

POWER Engineers, Member of WSP's Power Delivery Business Unit, Minneapolis Substation Department, is seeking an Estimation Analyst to join our Estimating Team in Amarillo, TX.

The Estimation Analyst will play a critical role in supporting the accuracy, efficiency, and consistency of project cost estimating for substation projects. This position is responsible for maintaining estimating databases, analyzing cost trends, tracking estimate accuracy against actual project outcomes, and ensuring the estimating team has the most current cost data and tools available.

Working closely with the Lead Estimator and Project Estimators, the Estimation Analyst will provide the data backbone for estimating operations — including cost benchmarking, variance analysis, and tool optimization. This role is well-suited for analytical professionals who excel at working with data, software tools, and process improvement to support high-quality project outcomes.

Responsibilities

Data & Database Management

+ Maintain and update estimating databases with current labor rates, material prices, bid units, and subcontractor data

+ Ensure cost data integrity and accuracy across all estimating tools and templates

+ Develop and manage work breakdown structures (WBS) and cost breakdown structures (CBS) in collaboration with project controls

+ Build and maintain material assemblies in estimating software (e.g., InEight, Assembly Manager) for use in cost models

Analytics & Reporting

+ Track and report variance between estimated and actual project costs using BI dashboards and analytical tools

+ Identify cost trends, escalation factors, and market risks to support accurate forecasting

+ Conduct variance analysis and lessons learned reviews to refine estimating accuracy

+ Provide management with reports and insights on estimating performance metrics

Process & Tool Support

+ Support implementation, testing, and optimization of new estimating tools, templates, and digital platforms

+ Convert outdated macros into Office Scripts to improve security and shareability

+ Assist in integrating external resources (commissioning, inspections, surveys, trucking, etc.) into estimating templates

+ Provide technical support to estimators on software use, data queries, and reporting needs

Collaboration & Continuous Improvement

+ Work closely with estimators and engineers to provide accurate cost data inputs

+ Support cross-departmental collaboration by validating and standardizing departmental cost inputs

+ Contribute to continuous improvement initiatives by identifying process inefficiencies and recommending enhancements

+ Help ensure the estimating team delivers to required accuracy targets (+/- 20% for scoping/appropriation, +/- 10% for engineering)

Required Education/Experience

+ Bachelor’s degree in Data Analytics, Engineering, Construction Management, Finance, or related field

+ Background in business/data analytics with strong technical acumen is also acceptable

+ 2–4 years of experience in cost analysis, project controls, data analytics, or estimating support

+ Demonstrated experience with BI reporting tools (Power BI, Tableau, etc.) and database management

+ Proficiency in Excel and data modeling skills

+ Strong knowledge of Microsoft Office Scripts and SharePoint Database skills

+ Strong command of the English language with good written and oral communication skills in order to work effectively with internal team members and external client personnel

Desired Education/Experience

+ Master's degree in Engineering Management, Data Analytics, or Business

+ Coursework or certifications in data analytics, cost engineering, or project controls are highly desirable

+ 3–5 years of professional experience in cost analysis, estimating support, project controls, or data analytics

+ Direct exposure to utility, substation, or large infrastructure projects

+ Hands-on experience with estimating software (InEight, RSMeans, Sage Estimating, or equivalent)

+ Familiarity with various automation tools such as SQL or Python

+ Experience with Work Breakdown Structures (WBS) and Cost Breakdown Structures (CBS)

+ Certifications from a relevant professional body, such as the AACE International Certified Estimating Professional (CEP) or a BI certification (e.g., Microsoft Power BI)

+ Knowledge of variance analysis, forecasting, and benchmarking practices

+ Professional certifications like PMP or CAPM are a plus, especially if combined with a project controls background

POWER Engineers, Member of WSP, is a global consulting environmental and engineering firm and one of the top design firms in the energy sector. Together, POWER and WSP’s 73,900 experts create positive, long-lasting impacts for our communities and our clients in the power and energy, transportation and infrastructure, environmental, and property and buildings sectors. As part of our team, you’ll discover a world of opportunities to connect with innovative thinkers, forge your path, and have fun tackling the world’s most challenging projects.

At POWER Engineers, Member of WSP, you can have a rewarding career on every level. Our philosophy is simple: Do Good. Have Fun. Build Success.

Our compensation package includes competitive compensation, professional development, and a full benefit package:

+ Medical/Dental/Vision

+ Paid Holidays

+ Vacation/Paid Sick Leave

+ Voluntary Life Insurance

+ 401K

+ Telehealth Benefit covers all providers

+ Maternity and Paternity Leave

+ New Dads and Moms Benefit program

+ Fertility Benefits

+ Gender affirming care

We are a fun engineering firm. That might seem contradictory to some, but it works for us!

Salary DOE

POWER Engineers, Member of WSP, is an Equal Opportunity Employer, including women, minorities, veterans, and individuals with disabilities

\#LI-TC1