Senior Data Analyst – Asset Management

AECOM

. Manage, organize, analyze, and validate large datasets associated with facilities, building systems, assets, deficiencies, costs, lifecycle information, and capital improvement needs .

Posted 11/9/2026full-timeRemote • Denver • Colorado • United StatesSenior💰 $90,000 - $120,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in managing and analyzing large datasets, developing data models, and creating visualizations using Power BI. Proficient in SQL and Python for data processing, with strong problem-solving and communication skills to convey technical concepts to diverse audiences.

Highest-signal resume keywords

SQL Querying And AnalysisPower BI Dashboard DevelopmentPython For Data AnalysisData Cleaning And TransformationData Management And Quality Control

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData ModelingETL ProcessesDatabase DesignData VisualizationData StructuresAutomated Data Quality ChecksStatistical AnalysisRelational DatabasesData Reporting

Soft Skills

Analytical SkillsProblem-SolvingWritten CommunicationVerbal CommunicationCollaboration

Tools & Technologies

Power BIMicrosoft ExcelMicrosoft OfficeCMMSDigital Data Collection Tools

Industry Keywords

Asset ManagementFacilities ManagementCapital PlanningInfrastructureFacility Condition Assessments

Tech Stack

Tools & technologies

ETLPythonSQL

About the role

Key responsibilities & impact

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
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
Develop and maintain Power BI dashboards and visualizations
Support configuration, testing, and deployment of digital data collection tools
Establish project-specific data requirements, validation rules, and QA/QC procedures
Support integration, import, export, and migration of project data between AECOM tools and client asset management, CMMS, and facilities management systems
Analyze client-provided datasets for assessment and capital planning programs
Prepare data tables, summaries, graphics, dashboards, and 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
Collaborate with project managers, facility assessors, engineers, architects, planners, and technology staff
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

Requirements

What you’ll need

Bachelor's 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
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
Ability to pass drug and background checks to work on Federal grounds, military installations, and school grounds
U.S. citizenship due to federal contract/security requirement
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
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

Benefits

Comp & perks

Medical, dental, and vision benefits
Life, AD&D, and disability benefits
Paid time off
Leaves of absence
Voluntary benefits and perks
Flexible work options
Well-being resources
Employee assistance program
Business travel insurance
Service recognition awards
Retirement savings plan
Employee stock purchase plan
In-person Day 1 onboarding at an AECOM office location
Training and development programs
Resources and expert network for career growth