Senior Data Analyst – Asset Management

🔥 1 minute ago

⛰️ Colorado – Remote

⛰️ Colorado – Remote

💵 $90k - $120k / year

⏰ Full Time

🟠 Senior

📉 Data Analyst

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 1%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

AECOM

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1990

💼 Consulting

🏥 Healthcare

📦 Logistics

Consulting • Healthcare • Logistics

AECOM is the world's trusted infrastructure consulting firm that partners with clients to deliver innovative solutions to the most complex challenges while creating legacies for generations to come. Focused on equity, diversity, and inclusion, AECOM leverages technical expertise and digital innovation to drive transformative outcomes in infrastructure development, sustainability, and social systems. The company provides a wide range of services, including architecture & design, construction management, engineering, and environmental services across various markets such as transportation, energy, healthcare, and national governments. With a strong emphasis on sustainability, technical excellence, and community impact, AECOM is committed to building a better world.

📋 Description

• 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 • Query, manipulate, combine, and analyze data from multiple sources using SQL and other analytical tools • Develop Python-based scripts and tools 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 • 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 and determine how existing information can be incorporated into assessment and capital planning programs • Prepare data tables, summaries, graphics, dashboards, 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

• 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 • U.S. citizenship due to federal contract/security requirement • Ability to pass criminal, drug, and background checks to work on Federal grounds, military installations, and school grounds • 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 • 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 • Ability to work effectively with multidisciplinary technical and project teams

🏖️ Benefits

• 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 • Award-winning training and development programs • In-person Day 1 onboarding at an AECOM office location