Sr. Analyst, Master Data

Cambridge, ON
$70,000-75,000 per year
Permanent
Full-time

29 days ago

Come Build Your Career at Aecon!As a Canadian leader in infrastructure development, Aecon is and building what matters for future generations to thrive! We lead some of the most impactful infrastructure of our generation, at the forefront of transformational change in transportation and energy, and partnering every day to build, connect, power, and strengthen our communities.At Aecon, you can count on:

Safety Always. Our number one core value. If we can't do it safely, we don't do it at all.
Integrity. We lead by example, with humility and courage.
Accountability. We're passionate about delivering on our commitments.
Inclusion. We provide equitable opportunities for everyone.

We lead the infrastructure industry with purpose, and our are at the heart of everything we do. So, we invest in our people, just like they invest in us!At Aecon we:

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.

Our business success relies on strong execution and continuous improvement - driven by the diversity, expertise and teamwork of our people. We're always searching the globe for innovative, collaborative minds to join our best-in-class Aecon community!What is the Opportunity?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.What You'll Do Here:Strategic Sourcing Team Support

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.

BI Reporting & Analytics

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.

Material Master

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.

What You Bring to the Team:

Undergraduate degree in Business Administration or Engineering.
Advanced proficiency in Business Objects, Power BI, and Microsoft Excel.
Knowledge of SAP Analytics Cloud (SAC) is an asset.
Exposure to scripting, Visual Basic, or SharePoint Designer is an asset.
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.

Reason for vacancy: ReplacementThe expected salary range for this opportunity is $70,000-$75,000Aecon fosters diversity, inclusion and belonging within and across our organization. We welcome all to apply including, women, visible minorities, Indigenous peoples, persons with disabilities, and persons of any sexual orientation or gender identity.We are committed to adhering to the objectives and requirements outlined in the Accessible Canada Act (ACA), and to meeting the accessibility needs of persons with disabilities in a timely manner. Through the implementation of the requirements of the ACA and its applicable regulations, appropriate accommodations will be provided upon request throughout the interview and hiring process.As part of our commitment to fair and transparent hiring practices, Aecon may use artificial intelligence (AI) tools to assist in screening and reviewing candidates. These tools are applied responsibly and in accordance with applicable privacy laws and Aecon's AI Usage Policy. All final decisions are made by qualified Aecon team members.

AECON

Apply Now