Environmental Data Analyst (EQuIS experience required)

AECOM; Philippines; On-site; PHP 558,000 - 1,004,000; Full time

Job summary

AECOM Environmental Data Management role in the Philippines involves developing and supporting environmental data systems, creating Power BI dashboards, and building automated data workflows across projects.

The candidate will extract, transform, and integrate data for reporting, design data models, and contribute to digital tool rollouts with cross-team collaboration. Night shift availability and 3 days onsite per week are required.

Qualifications

• Minimum of two years' experience in environmental consulting or related project delivery.
• 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 Microsoft Power Automate for workflow or process automation.
• Advanced Microsoft Excel skills including macro development and automation scripting.
• Strong organisational skills, results orientation, and ability to manage multiple priorities.
• Excellent communication skills with a consultative, service‑oriented approach to internal stakeholders.
• Must be open to working fixed night shift schedule and 3 days onsite per week.

Responsibilities

• Develop, maintain, and support 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 EDM outputs into Power BI dashboards and paginated reports, delivering reliable data pipelines from source to visualisation.
• Troubleshoot EDM 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.
• 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.
• Identify digitisation opportunities across project teams and implement scalable, repeatable solutions.
• Provide onboarding, configuration, training material development, and hypercare for digital tools.
• Write clear documentation and user manuals for tools and workflows.

Skills

Power BI

EQuIS

Python

C#

Power Automate

Excel Macros

Data Visualization

Data Modeling

Tools

Paginated Reports (RDL)

DAX

SQL

Job description

Company Description

Work with Us. Change the World.

At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations.

There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world.

We're one global team driven by our common purpose to deliver a better world. Join us.

Job Description

Environmental Data Management

• Develop, maintain, and support 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 EDM outputs into Power BI dashboards and paginated reports, delivering reliable data pipelines from source to visualisation.

• Troubleshoot EDM 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.

• 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.

• 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.

Qualifications

Required

• 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 Microsoft Power Automate for workflow or process automation.

• Advanced Microsoft Excel skills including macro development and automation scripting.

• Strong organisational skills, results orientation, and ability to manage multiple concurrent priorities.

• Excellent communication skills with a consultative, service‑oriented approach to internal stakeholders.
• Must be open to working fixed night shift schedule and 3 days onsite per week.

Preferred / Advantageous

• Custom development experience using Python, C# or similar scripting/development languages for tool or integration builds.

Additional Information

At AECOM, we are committed to maintaining a secure and trustworthy recruitment process and take any fraudulent hiring activity seriously. To support this commitment, all newly hired employees are required to attend an in‑person Day 1 onboarding at an AECOM office location as a condition of employment.

About AECOM

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status, AECOM benefits may include medical, dental, vision, life, AD&D, disability benefits, paid time off, leaves of absences, voluntary benefits, perks, flexible work options,well‑being resources, employee assistance program, business travel insurance, service recognition awards, retirement savings plan, and employee stock purchase plan.

AECOM is the global infrastructure leader, committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities, we solve our clients’ complex challenges in water, environment, energy, transportation and buildings. Our teams partner with public‑and‑private‑sector clients to create innovative, sustainable and resilient solutions throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2025. Learn more at aecom.com.

What makes AECOM a great place to work

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting‑edge technology and a network of experts, you’ll have the resources to make a real impact. Our award‑winning training and development programs are designed to expand your technical expertise and leadership skills, helping you build the career you’ve always envisioned. Here, you’ll find a welcoming workplace built on respect, collaboration and community - where you have the freedom to grow in a world of opportunity.

As an Equal Opportunity Employer, we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines.