Senior Data Analyst - Asset Management

AECOM•Denver, CO

11h•$90,000 - $120,000•Hybrid

About The Position

AECOM is seeking a Senior Data Analyst to join its U.S. West Digital Consulting team. The role supports the management, analysis, quality control, visualization, and delivery of data for facility condition assessment, asset management, and capital planning programs. The analyst works with project managers, technical staff, field assessment teams, and technology specialists to turn large, complex datasets into reliable, structured, actionable information throughout the project data lifecycle—from establishing data structures and requirements through collection, quality assurance, analysis, reporting, visualization, and client delivery. The role focuses on improving the efficiency, consistency, and reliability of data processes. The analyst identifies data-quality issues, develops repeatable and automated processes, and translates technical data into useful information for project teams and clients. Work includes supporting data collection tools and integrating project data with client asset management, computerized maintenance management, and facilities management systems. The position requires a bachelor's degree in a relevant field and four years of relevant professional experience, or demonstrated equivalency of experience and/or education. U.S. citizenship is required due to federal contract/security requirements, and the candidate must be able to pass applicable drug and background checks. The position is hybrid and based in Denver, Colorado. AECOM intends to fill this current vacancy by January 7, 2027.

Requirements

Bachelor's degree in Computer Science, Data Science, Information Systems, Information Technology, Engineering, Mathematics, Statistics, or a closely related field, plus four years of relevant professional experience; demonstrated equivalency of experience and/or education is accepted.
Experience managing, analyzing, and quality-controlling large and complex datasets.
Experience using SQL to query, manipulate, and analyze relational data.
Experience developing data visualizations and dashboards using Power BI or a comparable business intelligence platform.
Advanced proficiency with Microsoft Excel.
Experience developing repeatable processes for data cleaning, transformation, validation, and reporting.
Strong analytical, problem-solving, written, and verbal communication skills.
U.S. citizenship due to federal contract/security requirements.
Ability to pass drug and background checks to work on Federal grounds, military installations, and school grounds.

Nice To Haves

Proficiency with Python for data analysis, automation, transformation, and quality-control processes.
Advanced experience with SQL, relational databases, database design, and data modeling.
Advanced experience developing Power BI dashboards, data models, relationships, calculations, and interactive reporting.
Experience with ETL processes and combining information from databases, spreadsheets, APIs, or other structured data sources.
Experience developing automated data-quality checks, validation rules, and exception reporting.
Experience with facility, asset management, infrastructure, engineering, construction, or capital planning data.
Familiarity with facility condition assessments, asset inventories, lifecycle planning, cost data, or capital improvement programs.
Experience integrating data with enterprise asset management, CMMS, or facilities management systems.
Experience translating business requirements into data structures, analytical processes, dashboards, and technical solutions.
Ability to communicate technical data concepts to nontechnical staff and clients.
Experience documenting technical workflows, data dictionaries, and business rules.
Advanced proficiency with Microsoft Office, particularly Excel, PowerPoint, and Word.
Self-starter who can independently identify problems, develop solutions, and take ownership of assigned work.
Strong collaboration skills and ability to work effectively with multidisciplinary technical and project teams.
Ability to pass criminal, drug, and background checks to work on Federal grounds, military installations, and school grounds.

Responsibilities

Manage, organize, analyze, and validate large datasets related to facilities, building systems, assets, deficiencies, costs, lifecycle information, and capital improvement needs.
Develop and maintain data structures, models, relationships, naming conventions, and standardized data requirements for asset management projects.
Clean, transform, reconcile, and quality-control data to identify missing, duplicate, inconsistent, or anomalous information.
Develop automated and repeatable processes for data validation, analysis, transformation, and reporting.
Use SQL and other analytical tools to query, manipulate, combine, and analyze data from multiple sources.
Develop scripts and tools, including Python-based solutions, to improve data-processing efficiency and reduce repetitive manual tasks.
Develop and maintain Power BI dashboards and visualizations communicating facility condition, asset performance, capital needs, costs, priorities, and program progress.
Support configuration, testing, and deployment of digital data collection tools used by assessment teams.
Establish project-specific data requirements, validation rules, and QA/QC procedures, and perform ongoing data QA/QC throughout project delivery.
Support the integration, import, export, and migration of project data between AECOM tools and client asset management, CMMS, and facilities management systems.
Analyze client-provided datasets and determine how existing information can be incorporated into assessment and capital planning programs.
Prepare data tables, summaries, graphics, dashboards, and other deliverables for technical reports and client presentations.
Translate complex technical and analytical findings into clear information for project teams and clients.
Document data workflows, methodologies, calculations, business rules, and quality-control procedures to support repeatable and defensible project delivery.
Collaborate with project managers, facility assessors, engineers, architects, planners, and technology staff to develop appropriate data solutions.
Support continuous improvement of data management, reporting, automation, and technology processes.
Assist with proposals and business development activities related to data analytics, technology, and asset management.