Senior Data Analyst Asset Management

AECOM is actively seeking a Senior Data Analyst - Asset Management to join the U.S. West Digital Consulting team. This position will support the management analysis quality control visualization and delivery of data for large facility condition assessment asset management and capital planning programs.

The Senior Data Analyst will work closely with project managers technical staff field assessment teams and technology specialists to transform large and complex datasets into reliable structured and actionable information. The position will support the full lifecycle of project data from establishing data structures and project requirements through data collection quality assurance analysis reporting visualization and final client delivery.

A key focus of this role will be improving the efficiency consistency and reliability of our data processes. The successful candidate will be comfortable working with large datasets identifying data-quality issues developing repeatable and automated processes and translating technical data into information that can be readily understood and used by project teams and clients.

Department Description

The Digital Consulting group consists of a diverse multidisciplinary team of professionals working across the United States. We collaborate extensively with various departments and business lines within AECOM. A key focus area for us is providing asset advisory services which assist organizations in formulating effective capital and operations and maintenance (O&M) strategies. These strategies are crucial for managing the maintenance repair and replacement of assets and infrastructure to meet organizational objectives.

We emphasize the importance of clients having access to critical asset data to facilitate informed decision-making. This data enables accurate credible and defensible investment decisions by predicting costs timelines impacts and alternative options for identified needs. Our condition assessment process offers a comprehensive analysis of buildings and their systems providing clients with a detailed understanding of their facilities and infrastructure.

Our integrated assessment teams collect and analyze facility asset condition cost lifecycle and other data using digital tools. The resulting information supports capital planning data visualization reporting and integration with client enterprise systems. By leveraging this data and analysis clients can better align long-term capital projects with strategic priorities and make proactive data-driven investment decisions.

To learn more about our group please visit

The responsibilities of this position include but are not limited to:

• Manage organize analyze and validate large datasets associated with facilities building systems assets deficiencies costs lifecycle information and capital improvement needs.
• Develop and maintain data structures data models relationships naming conventions and standardized data requirements for asset management projects.
• Perform data cleaning transformation reconciliation and quality control 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 that communicate facility condition asset performance capital needs costs priorities and program progress.
• Support the 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 computerized maintenance management 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 the teams data management reporting automation and technology processes.
• Assist with proposals and business development activities related to data analytics technology and asset management.

The following skills and experience are essential for success in the role:

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

Qualifications :

Minimum Requirements

• Bachelors degree in Computer Science Data Science Information Systems Information Technology Engineering Mathematics Statistics or a closely related field plus 4 years of relevant professional experience or demonstrated equivalency of experience and/or education.
• Ability to pass drug and background checks to work on Federal grounds military installations and school grounds.
• This position requires U.S. citizenship due to federal contract/security requirement.

Preferred Qualifications

• 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 with the ability to 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.

Additional Information :

• THIS POSITION IS FOR A CURRENT VACANCY AND AECOM INTENDS TO FILL THIS POSITION BY JANUARY 7TH2027.

At AECOM we are committed to maintaining a secure and trustworthy recruitment process and take any fraudulent hiring activity seriously. To support this commitment all newly hired employees are required to attend an in-person Day 1 onboarding at an AECOM office location as a condition of employment.

About AECOM 

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status AECOM benefits may include medical dental vision life AD&D disability benefits paid time off leaves of absences voluntary benefits perks flexible work options well-being resources employee assistance program business travel insurance service recognition awards retirement savings plan and employee stock purchase plan. 

AECOM is the global infrastructure leader committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities we solve our clients complex challenges in water environment energy transportation and buildings. Our teams partner with public- and private-sector clients to create innovative sustainable and resilient solutions throughout the project lifecycle from advisory planning design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2025. Learn more at . 

What makes AECOM a great place to work 

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting-edge technology and a network of experts youll have the resources to make a real impact. Our award-winning training and development programs are designed to expand your technical expertise and leadership skills helping you build the career youve always envisioned. Here youll find a welcoming workplace built on respect collaboration and communitywhere you have the freedom to grow in a world of opportunity. 

As an Equal Opportunity Employer we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines. 

Remote Work :

Yes

Employment Type :

Full-time