Environmental Data & Reporting Automation Specialist

AECOM; Bogotá; On-site; COP 90,000,000 - 130,000,000; Full time

Job summary

AECOM is seeking a Digital Specialist to join the Environment Digital Transformation team to blend environmental data management with broader digital capabilities. You will enable workflow automation, reporting development, and dashboard delivery across the Americas.

The role supports digitizing data flows, KPI analysis, and cost savings from digitization, with an emphasis on data quality and scalable reporting infrastructure across geographies.

Qualifications

• Minimum of two years' experience in environmental consulting, environmental data systems or related project delivery context.
• Demonstrated experience with EQuIS for environmental data management, including report development and data workflows.
• Hands-on experience with Power BI, including data modelling, DAX and Paginated Reports (RDL).
• Experience with SQL Server / T-SQL, including query writing, views and data transformation.
• Experience with Microsoft Power Automate for workflow or process automation.
• Advanced Microsoft Excel skills including macro development and automation scripting (VBA and PowerQuery).
• Strong organisational skills, results orientation, and ability to manage multiple concurrent priorities.
• Excellent communication skills with a consultative, service-oriented approach to internal stakeholders.
• Python scripting experience for data management, reporting automation or integration workflows.
• Custom development experience using Python, C# or similar scripting/development languages for tool or integration builds.
• Relational database design and data model development experience.
• For Colombia-based candidates, Spanish and English capability is preferred; for Philippines-based candidates, strong English communication is expected.

Responsibilities

• Develop, maintain, and support EQuIS data systems with custom reports 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.
• Troubleshoot EQuIS configuration, data imports, and reporting issues for internal project teams.
• 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.
• 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.
• 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.
• 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.

Skills

Environmental data management

Power BI

EQuIS

SQL / T-SQL

Python scripting

Excel (VBA)

Microsoft Power Automate

Data modeling

Tools

EQuIS

Power BI

SQL Server / T-SQL

Power Automate

Excel VBA

Python

C#

Job description

AECOM is seeking a Digital Specialist to join the Environment Digital Transformation team to blend environmental data management with broader digital capabilities. You will enable workflow automation, reporting development, and dashboard delivery across the Americas.

The role supports digitizing data flows, KPI analysis, and cost savings from digitization, with an emphasis on data quality and scalable reporting infrastructure across geographies.