Sr. Analyst, Master Data

5 days ago

Cambridge, Ontario, Canada Aecon Full time

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.
  • Inclusion. We provide equitable opportunities for everyone.

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.
  • Uncompromising honesty

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.

  • Operations Data Analyst

    1 week ago

    Cambridge, Ontario, Canada Lone Wolf Real Estate Technologies Inc Full time

    Gather requirements from subject matter experts to create reports needed for all Operations departments Work with department leaders to identify opportunities for improvement Create and maintain regular reporting, weekly, monthly and quarterly for business needs Organize and provide data in formats that are usable for teams and leaders to effect change...

  • Master Production Scheduler

    1 week ago

    Cambridge, Ontario, Canada RIMOWA Full time

    Welcome to RIMOWA, the first German Maison of the Louis Vuitton Moët Hennessy (LVMH) Group. We are a global lifestyle brand with a mission to create the essential tools for a lifetime of travel. For more than 120 years, we have dedicated ourselves to developing unique products where function coexists with luxury, heritage with innovation, and craftsmanship...

  • Data Analyst

    1 week ago

    Cambridge, Ontario, Canada Region of Waterloo Full time

    Our Story:Committed to fostering opportunities for current and future generations, the Region of Waterloo is an inclusive, thriving, and sustainable region of connected rural and urban communities with global reach. Our mission is to serve, engage and inspire, by delivering quality services to a diverse population of 630,000+, while creating a healthy,...

  • Data Scientist

    1 week ago

    Cambridge, Ontario, Canada Ontario Mutuals Full time

    **DATA SCIENTIST (TELEMATICS)Join the Ontario Mutual Automobile Plan (OMAP) team and experience the passion it takes toempower and advance our mutual insurance communityWe have an excellent opportunity to join one of Waterloo Region's top employers as a Data Scientist- (telematics) in our Ontario Mutual Automobile Plan (OMAP) department. With this position,...

  • Continuous Improvement Business Analyst

    1 week ago

    Cambridge, Ontario, Canada Parrish & Heimbecker Full time

    P&H Milling GroupCambridge, OntarioJoin our team that shares your Passion & Heart for Canadian agriculture Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Continuous Improvement Business Analyst, with P&H Milling group based in Cambridge, Ontario.Work and grow with a family-owned...

  • Supply Chain Analyst

    1 week ago

    Cambridge, Ontario, Canada Reliance Home Comfort Full time

    Find Your Limitless with RelianceBy joining Reliance as a Supply Chain Analyst, you'll become an important team member and will be provided with the tools you need to succeed. We have ambitious growth plans and are looking for Team Members who want to grow with us. At Reliance, we pride ourselves on the fact that we provide limitless opportunities for growth...

  • Environmental Data Analyst

    1 week ago

    Cambridge, Ontario, Canada Geosyntec Consultants, Inc. Full time

    Overview:Do you want to build an impactful career to change the world for the better?Geosyntec is an innovative, international engineering and consulting firm serving private and public-sector clients to address new ventures and complex problems involving our environment, natural resources, and civil infrastructure. Our engineers, scientists, technical and...

  • Group Benefits Analyst

    1 week ago

    Cambridge, Ontario, Canada People Corporation Full time

    Job Description We are seeking a Group Benefits Analyst to join our amazing team This hybrid position is based in Cambridge Ontario, however, the location is flexible as this role is mostly remote and only occasionally in office. Benefits Analysts provide service and support for internal and external clients. This role mostly supports the Account...

  • Finance Analyst

    1 week ago

    Cambridge, Ontario, Canada Parrish & Heimbecker, Limited Full time

    Finance AnalystP&H Milling GroupCambridge, ONJoin our team that shares your Passion & Heart for Canadian agriculture Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Finance Analyst based at our Fountain Street location in Cambridge, Ontario.**Work and grow with a family-owned...

  • Equipment Analyst

    1 week ago

    Cambridge, Ontario, Canada Amico Affiliates Full time

    Equipment Analyst & CoordinatorCambridge, ONAmico is a diversified and dynamic, Canadian owned and operated construction company. Our dedicated and professional team provides paving, road building, infrastructure, general contracting, design build and engineering services for civil and construction industry customers. Here at Amico we believe in partnering...

  • Finance Business Analyst

    1 week ago

    Cambridge, Ontario, Canada Mundipharma International Full time

    Department: Finance, Global Technical Operations Job type: Full Time Join us and make a difference when it matters most At Mundipharma, we are proud of the work we do to bring innovative treatments to patients. We challenge ourselves constantly to deliver more for patients, healthcare professionals, our partners, and our employees. The Team The...

  • Commercial Analyst

    1 week ago

    Cambridge, Ontario, Canada ATS Automation Tooling Systems Full time

    Join our globally growing team at ATS Industrial Automation where we create complex automation solutions at the highest level that sustainably impact lives around the world.At ATS, a publicly traded global company with a proud 40-year history, we help drive the future with our factory-wide automation solutions. At ATS Industrial Automation, what we do...

  • Accounts Payable Analyst

    2 months ago

    Cambridge, Ontario, Canada Southbridge Care Homes Full time

    Position: Accounts Payable AnalystLocation: Southbridge Care CambridgeSouthbridge Health Care LP (Southbridge) is currently looking to add a talented Accounts Payable Analyst to our amazing corporate finance team at our head office in Cambridge, ON. Reporting to the Accounts Payable Manager, the Analyst will support the accounts payable function of...

  • Inventory Analyst

    1 week ago

    Cambridge, Ontario, Canada Glen Dimplex Americas Full time

    About UsFocused on leading the transition to a sustainable future, Glen Dimplex Americas is enhancing the moments that matter in life with a commitment to delivering the best design and efficiency in the areas of temperature control and comfort creation. With operation throughout North America the success of the Glen Dimplex Americas organization is a...

  • Accounts Receivable Analyst

    1 week ago

    Cambridge, Ontario, Canada Southbridge Care Homes Full time

    Position: Accounts Receivable AnalystLocation : CambridgeSouthbridge Health Care LP (Southbridge) is currently looking to add a talented Accounts Receivable Analyst to our amazing corporate finance team at our head office in Cambridge, ON_. _Reporting to the Accounts Receivable Manager, the Analyst will support the accounts receivable function of...

  • Accounts Payable Analyst

    1 week ago

    Cambridge, Ontario, Canada Southbridge Care Homes Full time

    Position: Accounts Payable AnalystLocation : Southbridge Care CambridgeSouthbridge Health Care LP (Southbridge) is currently looking to add a talented Accounts Payable Analyst to our amazing corporate finance team at our head office in Cambridge, ON_. _Reporting to the Accounts Payable Manager, the Analyst will support the accounts payable function of...

  • Finance ERP Analyst

    1 week ago

    Cambridge, Ontario, Canada Parrish & Heimbecker, Limited Full time

    Finance AnalystP&H Milling GroupCambridge, ONJoin our team that shares your Passion & Heart for Canadian agriculture Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Finance Analyst based at our Fountain Street location in Cambridge, Ontario.**Work and grow with a family-owned...

  • Financial Analyst

    4 weeks ago

    Cambridge, Ontario, Canada Southbridge Care Homes Full time

    Position: Financial AnalystSouthbridge Health Care LP (Southbridge) is currently looking to add a talented Financial Analyst to our amazing corporate finance team at our head office in Cambridge, ON. Reporting to the Senior Manager Operations Finance, the FA will work on a team responsible for the financial reporting of Long-Term Care and Retirement homes....

  • Financial Analyst

    4 weeks ago

    Cambridge, Ontario, Canada Southbridge Care Homes Full time

    Position: Financial AnalystSouthbridge Health Care LP (Southbridge) is currently looking to add a talented Financial Analyst to our amazing corporate finance team at our head office in Cambridge, ON. Reporting to the Senior Manager Operations Finance, the FA will work on a team responsible for the financial reporting of Long-Term Care and Retirement homes....

  • Data Cleanup and Conversion Specialist, Hxm

    1 week ago

    Cambridge, Ontario, Canada Waterloo Regional Police Service Full time

    The Waterloo Regional Police Service (WRPS) and Region of Waterloo (ROW), the "Organizations", are embarking on a partnership to implement a shared Human Experience Management (HXM) solution. As the Organizations endeavor to deliver the best service possible to their communities, this new HXM solution will provide enhanced strategic value by introducing...