Procurement Business Analyst

Aecon•Charlotte, NC

27d

About The Position

Aecon U.S. is seeking a Procurement Business Analyst to turn fragmented procure-to-pay and project data into a reliable management system for EPC delivery. This analytical role supports Procurement Leadership and project teams through KPI ownership, reporting automation, control visibility, and repeatable tools and standards that can scale across the U.S. EPC portfolio. It is not a transactional buying position. The analyst develops and maintains executive-ready procurement dashboards, scorecards, and reporting; analyzes spend, commitments, purchase orders, invoices, vendors, funding, performance periods, cycle times, and closeout status; and provides decision-focused analysis to Procurement Leadership, EPC project teams, Finance, Accounts Payable, Commercial, and executive stakeholders. The role also partners with stakeholders on business requirements and process improvements, translates needs into data models and operating tools, performs root-cause and exception analysis, and supports future-state process design, governance, change adoption, audit readiness, and continuous improvement. It extracts and reconciles data from SAP and other approved enterprise sources, builds maintainable Power BI models and dashboards, automates analysis with advanced Excel, and monitors data quality. The analyst tracks procurement and vendor performance, funding and obligations, escalates material exceptions, and communicates findings and recommendations across technical, operational, commercial, and executive audiences.

Requirements

Bachelor's degree in Business Administration, Supply Chain Management, Finance, Data Analytics, Economics, Information Systems, Engineering, or a related field.
At least 3 years of directly relevant analytical experience.
Advanced Microsoft Excel and Power BI capability.
Experience extracting and reconciling data from SAP or another enterprise resource planning platform.
Demonstrated ability to structure ambiguous problems, validate data, quantify business impact, communicate with executives, and drive cross-functional actions to closure.

Nice To Haves

5 to 7 years of progressively responsible experience, ideally supporting project-based or capital-intensive operations.
Experience in EPC, construction, engineering, industrial, nuclear, energy, federal contracting, or another regulated, project-driven environment.
Working knowledge of procurement lifecycle management, strategic sourcing, vendor performance, purchase-order administration, procure-to-pay, spend analytics, invoice reconciliation, commitments, funding, and periods of performance.
Experience with process mapping, workflow optimization, reporting automation, data governance, change management, and relevant professional certification.
Awareness of controlled-information, quality, cybersecurity, and audit obligations applicable to regulated work, including CUI, UCNI, NQA-1, and CMMC where relevant.

Responsibilities

Own and continuously improve executive-ready EPC procurement dashboards, scorecards, and reporting in Power BI and Excel, including KPI definitions, data ownership, and documented refresh cycles.
Analyze spend, commitments, purchase orders, invoices, vendors, funding, periods of performance, cycle times, and closeout status to identify leakage, bottlenecks, savings opportunities, and cost or schedule exposure.
Provide recurring operating reviews and decision-focused analysis for Procurement Leadership, EPC project teams, Finance, Accounts Payable, Commercial, and executive stakeholders.
Establish and maintain a governed KPI framework covering sourcing pipeline, purchase-order cycle time, commitment coverage, invoice exceptions, vendor performance, funding utilization, open obligations, and closeout readiness.
Partner with stakeholders to define, validate, prioritize, and document business requirements, reporting needs, control gaps, and improvement opportunities across the EPC procure-to-pay lifecycle.
Translate business needs into practical data models, dashboards, process maps, controls, workflows, and operating procedures with clear ownership and acceptance criteria.
Perform root-cause and exception analysis, quantify business impact, and recommend corrective actions for procurement, invoice, vendor, funding, data-quality, and operational issues.
Support future-state process design, procurement transformation, change adoption, governance, audit readiness, corrective-action tracking, and continuous improvement.
Extract, validate, cleanse, reconcile, and integrate procurement and project data from SAP and other approved enterprise sources while maintaining traceability to source records.
Develop maintainable Power BI data models, calculations, measures, visualizations, and executive dashboards that support drill-down from portfolio trends to actionable exceptions.
Use advanced Excel features, including PivotTables, Power Query, Power Pivot, lookup functions, data models, dashboards, and validation controls, to automate repeatable analysis and reduce manual reporting effort.
Maintain data dictionaries, KPI and calculation logic, report inventories, ownership, refresh schedules, and standardized practices; monitor and resolve data-quality issues.
Monitor commitments, purchase orders, vendor performance, invoice exceptions, open obligations, periods of performance, funding utilization, change exposure, and closeout status; escalate material exceptions with recommended actions.
Deliver spend, demand, and market analysis to support sourcing strategy, vendor management, budgeting, forecasting, cash-flow visibility, and procurement planning for EPC work.
Develop quantitative vendor and procurement performance measures, track action closure, and communicate findings, risks, and recommendations to technical, operational, commercial, and executive audiences.