Position Overview
The Digital Specialist will join the AECOM Environment Digital Transformation team, embedded within a cross-functional digital group supporting environmental project delivery across the Americas. This is not a pure database administration role — the successful candidate will blend environmental data management (EDM) expertise with broader digital capability, contributing to workflow automation, reporting development, dashboard delivery, and implementation support.
Primary Objective & KPIs
- Primary Role: Support environmental project teams in digitising data flows and delivering reporting automation
- KPIs: Cost savings from digitisation; positive feedback from project teams; integration efficiencies across business lines and geographies; quality and reliability of automated reporting outputs
Main Responsibilities
Environmental Data Management (EQuIS)
- Develop, maintain, and support EQuIS environmental data systems including custom report creation and data quality workflows.
- Extract and transform environmental data for reporting purposes, ensuring fitness for use across project teams.
- Integrate EQuIS outputs into Power BI dashboards and paginated reports, delivering reliable data pipelines from source to visualisation.
- Troubleshoot EQuIS configuration, data imports, and reporting issues for internal project teams.
Reporting & Dashboard Development
- Build and maintain Power BI dashboards, including data modelling, DAX formulas for calculated columns and measures, and reporting workflow configuration.
- Develop Paginated Reports (RDL) for structured, print-ready environmental reporting outputs.
- Write SQL Server / T-SQL queries to support complex reporting workflows, including views, temporary tables, and data transformation logic.
- Design and maintain relational data models and database structures to support reporting and workflow integration requirements.
Workflow Automation & Process Development
- Design and deploy workflow automation using Microsoft Power Automate for process orchestration across project and reporting workflows.
- Develop advanced Excel automation including macros and scripting to reduce manual effort in data compilation and reporting tasks.
- Build or configure custom automation solutions using Python, C# or similar scripting/development languages to support data management, reporting pipelines and integration tasks.
- Identify digitisation opportunities across project teams and implement scalable, repeatable solutions.
Digital Implementation & Rollout Support
- Support the implementation and rollout of digital tools and platforms across the Environment business line, including onboarding, configuration, training material development, and hypercare.
- Collaborate with the broader digital transformation team across the Americas to share best practices and carry forward lessons learned.
- Work with project teams at inception to identify digital needs, configure appropriate tools, and establish data flow processes.
- Provide ongoing support through feedback-driven tool improvements, scope changes, and project close-out debriefs.
- Write clear documentation and user manuals for tools and workflows.
Platform Integration
- Help integrate platforms used by the business line, including EQuIS, Power BI, Power Automate, and related Microsoft ecosystem tools.
- Identify new opportunities and applications for the digital toolkit as the business line's needs evolve.
