Project Controls Analyst

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

Technical Skills

Required:

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

• Power Automate – 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

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.