Digital Solutions Business Analyst

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.

Offered compensation will be based on location and individual qualifications. The expected range is $75,000.00 - $90,000.00.