Senior Project Controls Analyst (Cost)
L
Luster NationalHeavy-civil infrastructure
Phoenix, AZ, regionFull-TimeSenior
Salary140000 - 175000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 10+ years
- Required Skills
- SAPMicrosoft ExcelMicrosoft Office SuitePowerPoint
Requirements
- Bachelor’s degree in engineering, construction management, business, data analytics, statistics, or related field, or equivalent combination of education and experience.
- 10+ years of experience working with structured datasets in project, engineering, construction, or program environments.
- Experience supporting project controls, data, or reporting functions on large, complex infrastructure programs (e.g., highways, roads, bridges, transit, utilities, and/or aviation projects), typically involving multi-contract delivery and integrated reporting requirements.
- Experience performing advanced data manipulation, transformation, and structuring of large datasets (not limited to basic reporting or dashboarding).
- Experience working with hierarchical data structures such as work breakdown structures (WBS), cost breakdown structures (CBS), or similar multi-level coding frameworks.
- Experience integrating, reconciling, and normalizing data across multiple systems (e.g., scheduling, cost, and financial systems).
- Experience building, structuring, and maintaining datasets or data models used for reporting.
- Experience working with incomplete, inconsistent, or poorly structured datasets and improving data quality, hierarchy, and alignment across systems.
- Advanced proficiency in Microsoft Excel, including Power Query, pivot tables, and complex lookup functions.
- Experience extracting, manipulating, and reconciling data from project controls systems, including scheduling platforms (e.g., Primavera P6), cost management systems, and ERP platforms (e.g., Deltek, SAP), to support integrated cost and schedule reporting and alignment of WBS, CBS, and related coding structures.
- Proficiency with Microsoft Office Suite/Office 365 (e.g., Outlook, Teams, Word, PowerPoint, etc.).
Responsibilities
- Design and maintain scalable datasets that support program-level project controls reporting across multiple projects and contracts.
- Define and enforce data hierarchies including work breakdown structures (WBS), cost breakdown structures (CBS), and coding frameworks across the program.
- Support identification and resolution of misalignment between WBS, CBS, schedule activities, and financial coding structures across project controls systems.
- Perform advanced data manipulation, transformation, and normalization across multiple systems to ensure alignment between cost, schedule, and financial data.
- Integrate and reconcile data from Primavera P6, cost management systems, ERP platforms, and other program tools.
- Identify and correct inconsistencies in data structures, coding, and hierarchy across project controls systems.
- Develop and maintain data models that support integrated reporting across cost, schedule, and performance metrics.
- Establish data standards and support governance practices for project controls data across the program.
- Validate data accuracy and support reconciliation efforts across multiple reporting systems.
- Collaborate with project controls managers, cost engineers, and schedulers to ensure data structures support program controls requirements.
- Support continuous improvement of data structures, reporting processes, and data quality across the program.
View Full Description & ApplyYou'll be redirected to the employer's site