Project Controls Analyst

Strike•Spring, TX

3d•Onsite

About The Position

The Project Controls Analyst is responsible for analyzing and reporting on project controls for Strike’s construction and maintenance projects to include project planning, scheduling, cost estimating, cost tracking, and quality review. The Project Control Analyst will assist Project Controls Director and team to establish operating policies to bring standardization and mitigate project risk.

Requirements

Power BI – including Power Query, DAX, data modeling
Microsoft Excel – Advanced formulas, Pivot Tables, VBA/macros, modeling
SQL – Writing and validating complex queries
Earned Value Management (EVM) – Including productivity KPIs and Rules of Credit
Basic Relational Database Knowledge – Schema, normalization, joins, keys
ETL/Data Pipeline Concepts – basic understanding preferred
Document Control Tools/Systems – Experience maintaining project documentation
5+ years of experience in data analysis and project controls reporting
Demonstrated success in creating dashboards, reports, and analytical models
Experience in cost control, forecasting, and earned value reporting
Familiarity with document control practices across business units
Bachelor’s degree in a related field (e.g., Accounting, Construction Management, Finance, Engineering, Economics, Information Systems)
Analytical Thinking & Problem-Solving – Diagnose performance issues using data; develop actionable solutions
Data Visualization – Ability to create impactful visuals that tell the story behind the data
Communication – Strong ability to explain technical data to non-technical stakeholders
Project Management – Juggle multiple deadlines and shifting priorities
Business Acumen – Ability to learn and understand business operations, processes, and functions, and the ability to identify opportunities for improvement and innovation
Collaboration – Partner cross-functionally to deliver accurate and timely information
Continuous Learning – Stay current with evolving tools, trends, and governance practices
Regularly required to sit, talk and hear.
Frequently required to reach with hands and arms to grasp.
Occasionally required to stand; walk and stoop, kneel, crouch, or crawl.
Occasionally lift and/or move up to 10 pounds.
Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
Requires some travel.
Complies with Strike’s policies and procedures.
Complies with Strike’s Drug & Alcohol Policy maintaining favorable drug testing results throughout employment.
Performs job safely with respect to others, property and individual safety.
Works effectively with others to encourage teamwork and productivity.
Authorized to work in the United States.

Nice To Haves

Power Automate – (preferred) for workflow automation
Data Governance – Policy enforcement, stewardship, and integrity tracking
Hierarchy & Metadata Management – WBS, Org Hierarchy, Chart of Accounts, Job Metadata
JDE (JD Edwards)
INEIGHT Estimate
Oracle Primavera P6
Oil & gas or industrial construction experience preferred
PMP or equivalent project management certification is a plus

Responsibilities

Collaborate closely with Project Controls, Project Managers, Engineers, Procurement, and Construction teams to understand reporting needs and provide data-driven insights.
Design, develop, and maintain dashboards and visualizations using Power BI, incorporating advanced Power Query and data modeling techniques.
Build and maintain Excel models, including Pivot Tables, VBA macros, and financial modeling for forecasting and cost control.
Analyze project performance data (e.g., WIP, cost variance, schedule variance) to identify trends, risks, and opportunities for improvement.
Evaluate projects using data-driven methods to determine whether they are on track or in trouble.
Develop and maintain SQL queries to retrieve and validate data from relational databases.
Support and maintain metadata integrity, ensure job tagging, data dictionaries, and hierarchies are accurate and updated.
Lead and enforce data governance practices, ensuring compliance with internal standards and industry best practices.
Collaborate with accounting to ensure accurate cost hierarchies and integration with financial systems like JDE.
Create and maintain scalable training programs and process documentation for enterprise-wide adoption.
Continuously identify and implement improvements in the data analytics and project controls processes.