Analyste en planification / Planning Analyst

Qualifications

• Minimum d’un (1) an d’expérience en production de rapports, en analyse ou en soutien à la planification dans le secteur du commerce de détail ou de gros; les stages et programmes coop sont reconnus comme expérience pertinente.
• Baccalauréat en administration des affaires, finance, gestion de la chaîne d’approvisionnement, économie ou dans un domaine connexe, un atout.
• Solides compétences en Excel, notamment avec les tableaux croisés dynamiques, VLOOKUP/XLOOKUP (RECHERCHEV/RECHERCHEX) et la manipulation de grands ensembles de données.
• Capacité à apprendre rapidement de nouveaux systèmes; expérience avec des portails clients (Retail Link, un atout), des systèmes ERP ou des outils d’intelligence d’affaires tels que Power BI ou Tableau, un atout.
• Grande rigueur et souci de l’exactitude des données, avec l’habitude de valider les chiffres avant leur diffusion.
• Excellentes aptitudes en communication écrite et verbale.

Compétences et qualités recherchées

Avantages

Key Responsibilities

• Pull weekly sales, inventory, and customer inventory data from customer portals
• Prepare and distribute recurring daily, weekly, and monthly reports on sales, sell-through, store inventory, and in-stock performance
• Maintain report templates and Excel files, keeping data accurate, current, and consistent week by week
• Track actual sales against plan by account and category, and highlight items trending above or below expectation
• Monitor store and warehouse inventory levels and flag low-stock or overstock items to the planner
• Produce fill rate reports by customer, and item, and prepare the supporting cases to negotiate fill rate charges
• Compile OTIF (on time in full) scorecard reporting, breaking down misses by root cause such as late shipments, short ships, cancelled lines, and inventory shortfalls
• Assist the planner with replenishment reviews, order tracking, and recaps
• Investigate and follow up on reporting discrepancies, and order or shipment issues alongside customer service and logistics
• Complete ad-hoc reporting and analysis requests for the planning team
• Take on additional analysis and planning responsibilities as experience grows

Qualifications

• 1+ years of experience in retail or wholesale reporting, analytics, or planning support; internships and co-op terms count
• Bachelor’s degree in business, Finance, Supply Chain, Economics, or related field is an asset
• Strong Excel skills, including pivot tables, VLOOKUP/XLOOKUP, and working with large data sets
• Comfortable learning new systems quickly; exposure to customer portals (Retail Link an asset), ERP systems, or BI tools such as Power BI or Tableau is a plus
• Accurate and rigorous with data, with a habit of double-checking numbers before they go out
• Clear written and verbal communication skills a

Skills & Attributes

• Detail-oriented and organized, able to keep recurring deadlines on track
• Dependable and responsive; comfortable being the go-to for report requests
• Eager to learn the retail and planning side of the business
• Able to work independently on routine tasks while knowing when to escalate

Benefits

• Health & Dental – Insurance? We got you covered!
• Telemedicine – Access a doctor anytime, right from your phone!
• VRSP (Volunteer Retirement Savings Plan) – We help you save for the future!
• 100% free public transit – Your commute is on us!
• Flex hours – Enjoy 12 flex days per year to work from home
• Free breakfast on Fridays – Start your last workday of the week with something tasty on us!
• Early Fridays – Wrap up at 1:30 PM in the summer!
• A gift card on your birthday – happy birthday from us to you!
• Summer rooftop terrace vibes – Work breaks with a view.
• 5 à 7 summer hangout – Chill out at Esplanade Louvain, an outdoor space with gardens and music right next door.
• Team events & celebrations every month – Big thanks to our social committee for keeping the fun going!
• On-site free gym access – Includes weight room, yoga, bootcamp, and Tabata classes.
• Indoor bike parking – Ride worry–free, rain or shine.