Sr. Analyst, Master Data

Select how often (in days) to receive an alert:

It has come to our attention that various international organizations or individuals have been offering false employment opportunities at Aecon Group Inc. Aecon Group Inc. employment policies and processes involve interviews, and candidates who seek employment are never required to pay us any sum of money. To do so would be contrary to our business conduct guidelines and ethical practices. We also do not extend formal offers of employment or execute employment agreements through social media or social chat platforms.

We take this matter extremely seriously and are working with the appropriate authorities to shut down such fraudulent schemes. Please remain vigilant on this matter and report any suspicious outreach to your local authorities and email any concerns to [email protected]

Location: 

Toronto, ON, CA Cambridge, ON, CA

Operating Sector:  Finance

Position Title:  Sr. Analyst, Master Data

Come Build Your Career at Aecon!

As a Canadian leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive! We lead some of the most impactful infrastructure projects 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.

We lead the infrastructure industry with purpose, and our people 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!

About the Opportuntinity

This is a 12 Month Contract Opportunity

The Senior Master Data Analyst is a key member of the Corporate Procurement Data team. This position is responsible for reporting and analytics support to the Strategic Sourcing Team. Additionally, the Senior Master Data Analyst creates and maintain different reports and dashboards for several stakeholders within operations and corporate departments (Indigenous Relations, Diversity, Sustainability, etc.) The Senior Master Data Analyst is an integral part of the data governance structure for procurement master data and will ensure high data quality, consistency, and scalability across the organization. 

What You'll Do
Strategic Sourcing Team Support

• Quarterly reporting for the PSI (Preferred Supplier Initiative): Spend analysis for different preferred suppliers’ categories in Power BI, rebates and discount consolidation, commodity tracker update with power query in excel. 
• Ongoing Rebate Management: review rebates, manage rebate postings, determine taxation needs, and update rebate tracker master file. Calculation of rebate allocation at year end. 
• Ad-hoc reporting and analytics for the preferred suppliers’ categories as requested by the Strategic Sourcing Managers. Update the preferred suppliers list master file. 

BI Reporting and Analytics

• Gather requirements, design, and build/create advanced Business Intelligence Reports and Dashboards for different internal stakeholders (Procurement leaders, Sustainability dept, etc). 
• Maintenance of existing dashboards and reports: Indigenous vendors spend dashboard, procurement dashboard in SAP Analytics Cloud (SAC), diversity spend report, open Purchase Order (PO) report, general spend report and other corporate reports in Business Objects (BO).
• Quarterly reporting of diverse spend for two customers on their web platform.
• Different Business Objects (BO) reports for year-end activities.
• Different Business Objects (BO) reports for audit requirements. 

What You Bring to the Team

• An undergraduate degree in Business Administration or Engineering preferred.
• Highly proficient with Business Objects (BO), Power BI and Microsoft Excel.
• General knowledge of SAP Analytics Cloud (SAC) an asset.
• General knowledge of scripting, Visual Basic and SharePoint Designer experience an asset. 
• Good communications skills (both written and verbal).
• Analytical and critical thinking skills. 
• High attention to details is key.
• Data collection and manipulation experience.
• Demonstrated high goal achievement orientation. 
• Ability to work in a team environment. 
• Able to perform in a rigorous and fast paced environment. 
• Able to consistently take a disciplined track in achieving a goal using disciplined thought. 

Aecon 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. If you require accommodation under the ACA during any step of the application process please click here.