Onsite Project Controls & Analytics 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

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.