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.
The role will support environmental project teams in digitizing data flows and delivering reporting automation also analize KPIs and cost savings from digitization; positive feedback from project teams; integration efficiencies across business lines and geographies; quality and reliability of automated reporting output
Roles and 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.