Senior Project Controls Analyst (Cost)
New
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 (rail or bus), utilities, and/or aviation projects).
- 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).
- 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
