Sql data analyst Jobs in Richmond Hill, ON

Work Location Type: Hybrid

As a leading industrial distributor with operations primarily in North America, Japan and the United Kingdom, We Keep The World Working® by serving more than 4.5 million customers worldwide with products delivered through innovative technology and deep customer relationships. We’re dedicated to providing value for customers, fostering an engaging culture for team members and driving strong financial results.

Our welcoming workplace enables you to learn, grow and make a difference by keeping businesses running and their people safe. As a Great Place to Work-Certified™ company, we’re looking for passionate people to join our team as we continue leading the industry over our next 100 years.

Compensation

The base salary for this role ranges between $55,100 - $86,680, with eligibility for an incentive target of 5% which is contingent upon achieving both individual and company performance objectives.

The pay range above is not a guarantee of compensation but reflects the potential total compensation for this role at the time of this posting based on the assigned job grade. Actual compensation will vary depending on factors such as geographic work location, relevant experience and individual skills. The stated range is a reasonable estimate and may change over time; final compensation may fall above or below the range provided. Grainger reserves the right to amend, modify, or discontinue its compensation and benefits programs at any time, in accordance with applicable law.

This job posting is for an existing vacancy.

Position Details

The Inventory team at Grainger Canada manages over 500K Stock Keeping Units and $170 million across multiple distribution centres, branches, and on-sites across Canada. Our primary responsibility is to have the right product in the right place for customers, strategically balancing capital and OPEX investment of inventory dollars, labour and holding space. The Inventory Analyst will be responsible for the daily execution and continuous improvement of inventory planning processes and policies within one of the central Inventory teams. This position is located at our Thornhill/Markham, ON office location working hybrid in the office 2-3 days per week.

You Will

• The Inventory Analyst will be accountable for functional expertise over select planning areas within the system for specific business policies and procedures, as assigned, within the following areas:
  • Demand Capture
  • Demand Management
  • Forecasting
  • Measuring/Reporting OPM
  • Maintain Inventory Planning Tables
  • DRP/Deployment
  • Stocking Policy
    
    
• Based on the specific assigned area of ownership, the Analyst will:
  • Build and maintain relationships with Supply Chain partners to develop building-specific strategies, identify constraints, and recommend and execute solutions to meet performance metric goals and support long-term supply chain objectives.
  • Ensure that lost demand is correctly accounted for in the demand history.
  • Maintain item level data and categorization of items as eligible for stocking / non-stocking product for the business.
  • Execute the process to transition items between stock and non-stock positions.
  • Ensure discretionary inventory investments are properly recorded and maintained.
    
    
• Collect demand history, while ensuring that it is aggregated and filtered to enable effective forecasting.
  • Keep current all values for Economic Order Quantities and Inbound Multiples.
  • Generate all systems recommendations for stock level changes for the network.
    
    
• Screen and manage demand records and manage item deployment processes. Perform system maintenance and maintain master data within planning areas and processes, as needed.
  • Review and analyses planning data to prepare reports for management review.
  • Perform ad-hoc analyses as needed.

You Have

• Bachelor's Degree in Business or equivalent required
• 2+ years experience in Supply Chain required
• Proficiency in SQL and PowerBI (or equivalent) is required; and Python experience is a plus.
• Strong analytic fundamentals, proficiency in analysing large data sets to solve problems
• Understanding of key financial, customer service and supply chain metrics
• Ability to influence without authority
• Uses data and analytics to tell the story to relevant business leaders
• Project Management and continuous improvement experience a plus
• Proficiency in Microsoft Office; requires knowledge of downloading and uploading information via mainframe and PC systems
• Working knowledge of SAP Supply Chain Suite, particularly Advance Planning & Optimization or Service Parts Planning, a plus.

Rewards and Benefits
Our programs provide choice and flexibility to meet your individual needs. Check out some of the benefits available to you with Grainger (may vary based on hours worked):

• Medical, dental, vision and prescription drug coverage
• Paid time off (PTO) and up to 12 company holidays per year (dependent on home province)
• Life insurance coverage, including spousal and dependent life insurance.
• Employee Family Assistance Program to help team members with physical, emotional, mental, financial and other concerns
• Registered Retirement Savings Plan & Defined Contribution Pension Plan to help you save for your financial future
• Educational & Professional Membership Fee Assistance program
• Employee discounts, team member perks and more!

DEI Statement

We encourage you to apply even if your experience doesn't perfectly match this job post as you may still be the right candidate for this role or others. We aspire to create a culture where everyone is comfortable being who they are, can learn and grow to realize their full potential, and is recognized and rewarded for their impact.

We are proud to be an equal opportunity workplace. All qualified applicants are considered for employment without regard to race, religion, sex, sexual orientation, gender identity, national origin, age, or disability. Should you need a reasonable accommodation during the application and selection process, please advise us so we can provide appropriate assistance.

Pre-employment background checks are required for all external candidates. Internal candidates undergo a background check when they move from a non-driving role to a driving role.