Digital Specialist - Environmental Data & Reporting Automation
On-siteBogotá, Bogota D.C., Colombia or Bogota, New Jersey, United States
Bogotá, Bogota D.C., Colombia or Bogota, New Jersey, United StatesOn-siteFull TimeMid LevelConstructionEnterprise
Full TimeMid LevelEnterpriseConstruction
Job Summary
Develop and maintain EQuIS environmental data systems, including custom report creation, data quality workflows, and integration into Power BI dashboards. Build and configure workflow automation using Microsoft Power Automate, Python, and advanced Excel macros to streamline reporting tasks. Design relational data models, write complex SQL queries, and support the rollout of digital tools across environmental project teams. Troubleshoot reporting issues, develop documentation, and collaborate with cross-functional teams to implement scalable automation solutions.
Required 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, particularly 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
- Practical problem-solving approach with the drive to take ownership of a creative, delivery-focused role
- All newly hired employees are required to attend an in-person Day 1 onboarding at an AECOM office location as a condition of employment
Desired Qualifications
- Experience with Microsoft Fabric, Azure Data Services, or cloud-based data platforms, enabling scalable data integration and enterprise reporting
- Familiarity with API integrations and system-to-system data pipelines across enterprise tools
- Exposure to DevOps practices (version control, CI/CD pipelines) for managing and deploying data/reporting solutions
- Broader understanding of environmental consulting workflows, including field data collection, lab data, regulatory reporting, and project lifecycle data needs
- Experience leading or supporting tool rollouts, change management, and adoption strategies across distributed teams
- Experience with Power Apps for lightweight application development
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.