Project Controls Analyst

Job SummaryThe 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 FunctionCollaborate 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:RequiredPower BI – including Power Query, DAX, data modelingMicrosoft Excel – Advanced formulas, Pivot Tables, VBA/macros, modelingSQL – Writing and validating complex queriesEarned Value Management (EVM) – Including productivity KPIs and Rules of CreditBasic Relational Database Knowledge – Schema, normalization, joins, keysETL/Data Pipeline Concepts – basic understanding preferredDocument Control Tools/Systems – Experience maintaining project documentationNice To HavePower Automate – (preferred) for workflow automationData Governance – Policy enforcement, stewardship, and integrity trackingHierarchy & Metadata Management – WBS, Org Hierarchy, Chart of Accounts, Job MetadataJDE (JD Edwards)INEIGHT EstimateOracle Primavera P6Experience:5+ years of experience in data analysis and project controls reportingDemonstrated success in creating dashboards, reports, and analytical modelsExperience in cost control, forecasting, and earned value reportingFamiliarity with document control practices across business unitsOil & gas or industrial construction experience preferredEducation/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 plusCompetencies:Analytical Thinking & Problem-Solving – Diagnose performance issues using data; develop actionable solutionsData Visualization – Ability to create impactful visuals that tell the story behind the dataCommunication – Strong ability to explain technical data to non-technical stakeholdersProject Management – Juggle multiple deadlines and shifting prioritiesBusiness Acumen – Ability to learn and understand business operations, processes, and functions, and the ability to identify opportunities for improvement and innovationCollaboration – Partner cross-functionally to deliver accurate and timely informationContinuous Learning – Stay current with evolving tools, trends, and governance practicesPhysical 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.