Job Details

Senior Global Sourcing Analyst (VBA & Macros)


Date Opened: 06/02/2022

Job Type:

Job Number: 22000312

Job Description

About The Bay

As North America’s oldest startup and Canada’s purpose-driven digital marketplace, The Bay is on a high-growth mission to rewrite the rules of retail to help Canadians live a colourful life. If you believe in the power of our iconic brand and thrive on problem solving at scale, we want you to join our team.

At The Bay, smart and high-performing team members will challenge you to learn and grow every day. We value ambitious work and great ideas grounded in data and insights. We are looking for talented people who love a fast-paced environment, embrace change and are looking to make an impact with groundbreaking ideas.

We are building a digital-first company and brand for a diverse world and we need a diverse team to reach our potential. We strongly encourage applications from everyone to come and join a winning team that supports diverse thinking and demonstrates innovation, energy, creativity and vision every day.

The teams in the India office play an integral role in supporting The Bay’s strategic plan. Bengaluru’s workforce has deep experience in a variety of areas, including finance and accounting, technology, as well as other shared services and will support The Bay’s operations on an ongoing basis.  

 You can learn more and view available positions in Bengaluru, by visiting

Senior Global Sourcing Analyst:

The Senior Global Sourcing Analyst supports the Global Sourcing Team, with merchandising tasks. The Senior GSA role is to review & maintain purchase orders, responsible to have PO EDI to the vendor, manage POCN requests (Purchase Order Change notice), Vendor communications and reporting & analysis. The position requires frequent communication with the Global sourcing, Buying team as well as with vendors, distribution centers, stores and Leadership Team.

Who You Are:

  • University or college degree or commensurate retail experience
  • Preferred more than 4 years of relevant experience in Supply Chain & Logistics industry
  • Have knowledge on Advance Excel & VBA
  • Able to work independently with little supervision
  • You will have to demonstrate ability to manage multiple priorities simultaneously with strict adherence to deadlines
  • Detail oriented and Willingness to learn
  • Good organizational skills and understanding on KPIs and Metrics

What you will do as the Senior Global Sourcing Analyst:

  • Review & maintain purchase orders for private label brands shared by the Global Sourcing and Vendors
  • Co-ordinate with the Buying and Allocation teams to have the EDI released to the vendor based on the calendar timelines
  • Have regular touch base with the NA Partners to ensure the shipments are reaching the DC as per the Business requirements
  • Ensure all POCN requests are actioned accordingly received from the vendors and the same EDI
  • Complete audit to be actioned before releasing POs to the vendor
  • Share weekly/quarterly shipment status report to the NA Business Leaders
  • Keep a track record of all booking, shipment appointment details and receipt to DC on a regular basis
  • Good knowledge with Advance excel and VBA would be used build and create reports/dashboards for the teams

Additional Responsibilities:

  • Training and Mentoring the new TMs
  • Reporting and Analysis
  • Creation and documentation of best practices
  • Liaison between Canadian Global Sourcing teams, Buying offices, vendors and Leadership team
  • Maintain workflow dashboard and reporting of business metrics
  • Lead other specific tasks and special projects assigned
  • Drive partnership with cross functional teams
  • Data Quality Audit for the Team

What you will need:

1.  Retails knowledge/Experience (preferably Supply Chain & Logistics)

2. Expert in Advance Excel & VBA

3. Excellent in communication skills

4. Problem Solving Ability and Analytical Skills

Good to haves:

1. Operational Leadership Experience

2. Item Domain Expertise

3. Knowledge on Data Quality


Job Qualifications

Thank you for your interest with HBC. We look forward to reviewing your application. 

HBC provides equal employment opportunities (EEO) to all employees and applicants for employment.