Digital Solutions Business Analyst

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

The successful candidate will be joining the Technology Services team within the US East region. Your primary focus will be driving data collection and validation processes, designing and developing Power BI reports for data analysis, and leveraging Power Platform to support reporting and data management processes for our external-facing projects. You will collaborate with team members to deliver impactful, data-driven solutions that support AECOM's core services. 

Responsibilities:

•  Coordinate and execute data collection and validation processes on a weekly or monthly basis, or as required.
• Gather reporting requirements in a project controls context (budget, schedule) via workshops. 
• Maintain documentation for requirements and support & maintenance processes as needed.
• Design and develop Power BI reports and dashboards to provide actionable insights and support data analysis and decision-making. 
• Implement ETL processes and data transformations to ensure seamless data flow between systems, leveraging SQL databases and Power BI. 
• Build workflows, processes, and approvals using Power Automate to optimize business processes. 
• Troubleshoot and resolve challenges in existing Power Platform solutions using analytical and problem-solving skills. 
• Work closely with project teams and stakeholders to collect, evaluate, and refine requirements, incorporating feedback into solution development. 
• Provide accurate time estimates for pipeline tasks. 
• Provide first-level support for user access and basic troubleshooting. 
• Support the team and organization in growing its Power Platform capabilities, with a focus on data analytics and reporting.

Qualifications

Minimum Qualifications:

• BA/BS plus two years of relevant experience or demonstrated equivalency of experience and/or education.

Preferred Qualifications:

• Displays knowledge and ability to apply business practices in carrying out a variety of assignments. 
• Produces regularly scheduled reports from multiple data sources. 
• Is able to analyze and present data for purpose of evaluation. 
• Demonstrates the ability to organize, process, and present information, requiring good communication skills.

Additional Information

• Sponsorship for US employment authorization is not available now or in the future for this position.
• Relocation is not available for this position.

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, well-being resources, employee assistance program, business travel insurance, service recognition awards, retirement savings plan, and employee stock purchase plan.

AECOM is the world’s trusted infrastructure consulting firm, delivering professional services throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. On projects spanning transportation, buildings, water, new energy and the environment, our public- and private-sector clients trust us to solve their most complex challenges. Our teams are driven by a common purpose to deliver a better world through our unrivaled technical and digital expertise, a culture of equity, diversity and inclusion, and a commitment to environmental, social and governance priorities. AECOM is a Fortune 500 firm and its Professional Services business had revenue of $14.4 billion in fiscal year 2023. See how we are delivering sustainable legacies for generations to come at aecom.com and @AECOM.

Freedom to Grow in a World of Opportunity