Senior Data Analyst – Asset Management

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

📋 Description

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

• Create and uphold data structures, models, relationships, naming conventions, and standardized data needs for asset management initiatives.

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

• Formulate automated and repeatable workflows for data validation, analysis, transformation, and reporting.

• Retrieve, manipulate, merge, and analyze data from various sources utilizing SQL and other analytical instruments.

• Develop Python-based scripts and tools to enhance data processing efficiency and minimize repetitive manual activities.

• Create and sustain Power BI dashboards and visual representations that convey facility condition, asset performance, capital requirements, costs, priorities, and program advancement.

• Assist in configuring, testing, and implementing digital data collection tools.

• Define project-specific data requirements, validation protocols, and QA/QC processes.

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

• Examine client-provided datasets to determine the incorporation of existing information into assessment and capital planning programs.

• Generate data tables, summaries, graphics, dashboards, technical reports, and client presentations.

• Convert intricate technical and analytical insights into understandable 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 personnel.

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

• Assist with proposals and business development efforts related to data analytics, technology, and asset management.

⛳️ Requirements

• A Bachelor’s degree in Computer Science, Data Science, Information Systems, Information Technology, Engineering, Mathematics, Statistics, or a closely related field, along with 4 years of pertinent professional experience, or a demonstrated equivalency of experience and/or education.

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

• Capability to pass criminal, drug, and background checks to work on Federal premises, military facilities, and school grounds.

• Experience in managing, analyzing, and ensuring the quality of large and complex datasets.

• Proficient in using SQL to query, manipulate, and analyze relational data.

• Background in developing data visualizations and dashboards using Power BI or a comparable business intelligence platform.

• Advanced skills in Microsoft Excel.

• Experience in establishing repeatable processes for data cleansing, transformation, validation, and reporting.

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

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

• Extensive experience in developing Power BI dashboards, data models, relationships, calculations, and interactive reporting.

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

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

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

• Understanding of facility condition assessments, asset inventories, lifecycle planning, cost data, or capital improvement programs.

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

• Capability to communicate technical data concepts to non-technical staff and clients.

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

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

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

• Skill in collaborating effectively with multidisciplinary technical and project teams.

🏝️ Benefits

• Medical, dental, and vision insurance.

• Life, AD&D, and disability insurance.

• Paid time off.

• Leaves of absence.

• Voluntary benefits and perks.

• Flexible work arrangements.

• Resources for well-being.

• Employee assistance program.

• Business travel insurance.

• Service recognition awards.

• Retirement savings plan.

• Employee stock purchase plan.

• Award-winning training and development programs.

• In-person onboarding on Day 1 at an AECOM office location.