Digital Specialist - Environmental Data & Reporting Automation

AECOM
Bogotá
Workplace: OnsiteFull timeFunction: Executive & General ManagementExperience: 2+ yearsSkills: ["Communication","Organizational skills","Results orientation","Problem-solving","Ownership"]

Join the Environment Digital Transformation team to digitize environmental data flows and deliver reporting automation across the Americas. You’ll manage EQuIS environmental data systems, build Power BI dashboards and paginated (RDL) reports, and write SQL Server/T-SQL for reliable data pipelines. You’ll also automate workflows with Power Automate, Excel scripting, and support platform integrations and rollout activities, with KPI and cost-savings analysis for project teams.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
AECOM
AECOM
1 month ago

Digital Specialist - Environmental Data & Reporting Automation

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 1 hour agoStatus: Live
Reposted: similar role first listed 1 month ago

Job Summary

Join the Environment Digital Transformation team to digitize environmental data flows and deliver reporting automation across the Americas. You’ll manage EQuIS environmental data systems, build Power BI dashboards and paginated (RDL) reports, and write SQL Server/T-SQL for reliable data pipelines. You’ll also automate workflows with Power Automate, Excel scripting, and support platform integrations and rollout activities, with KPI and cost-savings analysis for project teams.
Location: Bogotá
Workplace: Onsite
Employment Type: Full time
Job Function: Executive & General Management
Seniority: Entry level

Key Responsibilities

  • •Develop, maintain, and support EQuIS environmental data systems, including custom report creation and data quality workflows.
  • •Build Power BI dashboards and paginated reports (RDL), using data modelling, DAX, and workflow configuration for reliable reporting pipelines.
  • •Write SQL Server/T-SQL queries and design relational data models to support reporting workflows and data transformation requirements.
  • •Design and deploy workflow automation with Power Automate, plus Excel automation and custom solutions using Python/C# to digitize and reduce manual effort.
  • •Support digital tool implementation and rollout (onboarding, configuration, training, hypercare), collaborate with teams across the Americas, and maintain documentation and user manuals.

Pay and Benefits

Perks:Health InsuranceDentalVisionLife InsurancePaid LeaveRetirement SavingsEquity

Key Requirements

  • •Minimum of two years’ experience in environmental consulting, environmental data systems, or related project delivery.
  • •Demonstrated experience with EQuIS 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 and advanced Excel automation (macros/VBA and PowerQuery).
Experience:2+ yearsEnvironmental consultingEnvironmental data systemsEnvironmental reporting
Skills:CommunicationOrganizational skillsResults orientationProblem-solvingOwnership
Languages:EnglishSpanish
Tech Stack:EQuISPower BIDAXPaginated Reports (RDL)SQL ServerT-SQLPower AutomateMicrosoft ExcelVBAPowerQueryPythonC#Microsoft FabricAzure Data ServicesAPI integrationsCI/CDPower AppsPowerPoint

Eligibility

Work Authorization:Authorization required. Sponsorship not provided.

Company Brief

AECOM
AECOM is a global infrastructure firm providing design, consulting, construction, and management services across transportation, buildings, water, environment, and energy sectors, delivering large-scale projects for public- and private-sector clients worldwide.
Industry: Civil Engineering
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Los Angeles, United States
Founded: 1990
Glassdoor
Glassdoor: 3.6
WebsiteLinkedInGlassdoor