Senior Data Analyst – Asset Management

This is a fully remote position, open to applicants in Colorado.

📋 Description

• Oversee, organize, analyze, and validate extensive datasets related to facilities, building systems, assets, deficiencies, costs, lifecycle information, and capital improvement requirements.

• Create and sustain data structures, models, relationships, naming standards, and standardized data criteria for asset management initiatives.

• Conduct data cleansing, transformation, reconciliation, and quality assurance.

• Design automated and repeatable procedures for data validation, analysis, transformation, and reporting.

• Utilize SQL and various analytical tools to query, manipulate, combine, and analyze data from diverse sources.

• Develop scripts and tools, including Python-based solutions, to enhance data-processing efficiency.

• Create and maintain Power BI dashboards and visual representations.

• Assist in the configuration, testing, and implementation of digital data collection tools.

• Define project-specific data requirements, validation criteria, and QA/QC practices.

• Facilitate the integration, import, export, and migration of project data between AECOM tools and client asset management, CMMS, and facilities management systems.

• Evaluate client-provided datasets for assessment and capital planning initiatives.

• Produce data tables, summaries, graphics, dashboards, and deliverables for technical reports and client presentations.

• Convert complex technical and analytical insights into comprehensible information for project teams and clients.

• Document data workflows, methodologies, calculations, business rules, and quality control protocols.

• Collaborate with project managers, facility assessors, engineers, architects, planners, and technology personnel.

• Promote continuous enhancement of data management, reporting, automation, and technology processes.

• Contribute to proposals and business development efforts pertaining 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 discipline plus 4 years of relevant professional experience, or a demonstrated equivalency of experience and/or education.

• Proven experience managing, analyzing, and ensuring quality control of large and intricate datasets.

• Proficiency in SQL for querying, manipulating, and analyzing relational data.

• Experience in creating data visualizations and dashboards utilizing Power BI or a similar business intelligence platform.

• Advanced skills in Microsoft Excel.

• Proven track record in developing repeatable processes for data cleansing, transformation, validation, and reporting.

• Strong analytical, problem-solving, written, and verbal communication abilities.

• Capability to pass drug and background checks for work on Federal grounds, military installations, and school properties.

• U.S. citizenship required due to federal contract/security regulations.

• Proficient with Python for data analysis, automation, transformation, and quality control processes.

• Extensive experience with SQL, relational databases, database design, and data modeling.

• Advanced experience in developing Power BI dashboards, data models, relationships, calculations, and interactive reports.

• Familiarity with ETL processes and integrating data from databases, spreadsheets, APIs, or other structured data sources.

• Experience in developing automated data quality checks, validation rules, and exception reporting.

• Background in facility, asset management, infrastructure, engineering, construction, or capital planning data.

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

• Ability to translate business requirements into data structures, analytical processes, dashboards, and technical solutions.

• Skill in communicating technical data concepts to non-technical staff and clients.

• Experience in documenting technical workflows, data dictionaries, and business rules.

• Advanced proficiency in Microsoft Office, particularly Excel, PowerPoint, and Word.

• Ability to independently identify issues, devise solutions, and take ownership of assigned tasks.

• Strong collaboration skills and capability to work effectively with multidisciplinary technical and project teams.

• Ability to pass criminal, drug, and background checks for work on Federal grounds, military installations, and school properties.

🏝️ Benefits

• Medical, dental, and vision benefits.

• Life, AD&D, and disability insurance.

• Paid time off.

• Leaves of absence.

• Voluntary benefits and perks.

• Flexible work arrangements.

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

• Access to resources and expert networks for career advancement.