Project Controls Analyst

Strike, LLC; Spring (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Strike, LLC in Spring, TX seeks a Project Controls Analyst to analyze and report on project controls for construction and maintenance projects. You will support the Project Controls Director, standardize processes, and mitigate project risk.

Responsibilities include designing dashboards in Power BI, building Excel models for forecasting, and developing SQL queries to pull data. Collaboration with multiple teams and governance are essential.

Qualifications

• 5+ years of data analysis and project controls reporting.
• Experience creating dashboards, reports, and analytical models.
• Experience in cost control, forecasting, and earned value reporting.
• Familiarity with document control practices across business units.
• Oil & gas or industrial construction experience preferred.

Responsibilities

• Collaborate with Project Controls, PMs, engineers, procurement, and construction teams to understand reporting needs and provide data-driven insights.
• Design, develop, and maintain dashboards and visualizations using Power BI with advanced data modeling.
• Build and maintain Excel models, including Pivot Tables, for forecasting and cost control.
• Analyze project performance data to identify trends, risks, and improvements.
• Develop and maintain SQL queries to retrieve and validate data from relational databases.
• Lead data governance and ensure data integrity, tagging, dictionaries, and hierarchies.
• Collaborate with accounting to ensure accurate cost hierarchies and integration with JDE.
• Create scalable training programs and process documentation for enterprise-wide adoption.
• Identify opportunities to apply AI and automation to repetitive tasks and reports.

Skills

Power BI

Excel

SQL

Earned Value Management

Relational databases

ETL/Data pipeline

Document control

AI tools & prompts

Education

Bachelor's degree

PMP or equivalent

Tools

JDE (JD Edwards)

INEIGHT Est.

Oracle Primavera P6

Job description

This will be an onsite role at our Spring, TX office!

Job Summary:

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.

Primary Job Function:

• 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, 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.
• Leverage AI tools to accelerate data analysis, report generation, and process documentation while maintaining accuracy and data confidentiality standards.
• Identify opportunities to apply AI and automation to repetitive project controls tasks such as data validation, variance commentary, and report drafting.
• Evaluate emerging AI capabilities within existing platforms and recommend adoption where they improve speed or quality.

Technical Skills:

Required:

• AI Tools & Prompt Engineering: Working proficiency with generative AI assistants (e.g., Microsoft Copilot, Claude, ChatGPT) for analysis, drafting, and automation support
• 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

Nice to Have:

• 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

Experience:

• 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
• Oil & gas or industrial construction experience preferred

Education/Training:

• Bachelor’s degree in a related field (e.g., Accounting, Construction Management, Finance, Engineering, Economics, Information Systems)
• PMP or equivalent project management certification is a plus

Competencies:

• 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

Physical Demands:

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

Other Criteria:

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

Strike is an equal opportunity employer.