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.