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 DescriptionThe U.S.West 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 AECOMassetmanagement.comThe 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 team's 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.