Sr. Analyst, Master Data

Aecon • Toronto, ON

49d • $70,000 - $75,000

About The Position

The Senior Master Data Analyst plays a key role on the Corporate Procurement Data team, providing reporting, analytics, and master data support to the Strategic Sourcing function. This role delivers insights through dashboards and analysis for procurement leadership and corporate stakeholders. You will also own Material Master (MM) data within SAP, supporting material creation, maintenance, and governance. As part of the procurement data governance framework, you will ensure data quality, consistency, and scalability across the organization.

Requirements

• Undergraduate degree in Business Administration or Engineering.
• Advanced proficiency in Business Objects, Power BI, and Microsoft Excel.
• Strong communication, analytical, and critical‑thinking skills.
• High attention to detail and strong data manipulation experience.
• Ability to work collaboratively in a fast‑paced, deadline‑driven environment.
• Self‑motivated, goal‑oriented, and disciplined in problem solving.

Nice To Haves

• Knowledge of SAP Analytics Cloud (SAC) is an asset.
• Exposure to scripting, Visual Basic, or SharePoint Designer is an asset.

Responsibilities

• Deliver quarterly reporting for the Preferred Supplier Initiative (PSI), including spend analysis, rebate and discount consolidation, and commodity tracking using Power BI and Excel (Power Query).
• Manage ongoing rebates: review postings, assess tax requirements, maintain tracking files, and calculate year‑end allocations.
• Provide ad‑hoc analysis and reporting for preferred supplier categories and maintain the preferred supplier master list.
• Partner with stakeholders to gather requirements and design advanced BI dashboards and reports.
• Maintain and enhance existing reports and dashboards, including Indigenous spend, diversity spend, procurement dashboards, open PO reporting, and general spend reporting across Power BI, SAP Analytics Cloud (SAC), and Business Objects (BO).
• Produce BO reports to support audit and compliance requirements.
• Process Material Master requests in line with data governance standards and defined SLAs.
• Support and promote Material Master adoption through training, data analysis, cleansing, and SAP setup.
• Develop and maintain material groups, naming conventions, and overall material group structure.
• Provide SAP MM expertise across the P2P process, including table analysis and issue resolution.
• Investigate data integrity issues, identify root causes, and implement sustainable corrective actions.

Benefits

• Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being.
• Believe in helping you build your career through our Aecon University and Leadership Programs.
• Are committed to supporting and investing in inclusive work environments, through initiatives like Equity, Diversity & Inclusion training, our Aecon Women in Trades and Aecon Diversity in Trades programs, and our Employee Resource Groups (ERGs) to ensure we are building inclusion into every aspect of our culture at Aecon.
• Are a leader in sustainable construction. With a strong commitment to operating responsibly by minimizing our impact on the environment and surrounding communities.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level