Data and Inventory Analyst

Data and Inventory Analyst- We’re looking for like-minded individuals to join our team.**About the Role: This is a Full-time, Salaried position.**

**About The Data and Inventory Analyst**
- This role supports the company overall with Data Analysis in every aspect of the business, from Sales to Customer Service and everything in between, as well as specializing in Inventory Control. This person is responsible in providing business insight and direction backed by data.This role will work closely with the Supply Chain Manager and Inventory Specialist to identify opportunities to improve Inventory Control and close gaps with any deficiencies in our processes, as well as suggest cycle count plans, develop and run reports to find discrepancies, root causes and solving them.- **Key Responsibilities**:

- Create, restructure and manage large datasets
- Develop and maintain Excel-based tools and reports using VBA and SQL for operations, sales and other functional teams
- Gather and help management team to develop and run their monthly KPIs
- Develop data analysis and models using predictive data models for stock management
- Collaborate directly with production and supply chain teams using the data models and analysis to provide insights that drive operations improvements (i.e. Reduce stock outs, planning procurement lead times, reduce overstocking)
- Monitor, investigate and facilitate the correction of inventory discrepancies
- Recommend process and procedure changes to improve inventory accuracy and overall supply chain efficiency
- Develop data analysis on a monthly basis to identify slow moving inventory and inventory that is turning below benchmark
- Proactively collaborates with internal stakeholders to provide findings for action planning
- Supports finance team with reporting queries using SQL and Tableau as well as other relevant BI tools to enable efficient reporting and analysis of sales and Cost of goods
- Writes technical memos that document data processing queries actively used in business operations
- Support Implementation of continuous improvement processes
- Assist in the design, implementation and enforcement of data infrastructure and system policies
- Able to lift up to 25lbs; may work in hot areas 5%, noise 5%.
- Ensure adherence to Health and Safety as well as active participation in 5S activities in work area
- Perform other duties as required

**Attributes, Skills and Knowledge**:

- Bachelor's degree in Data Science, Mathematics, Statistics or a related field
- At least 3 years of data analytics experience
- At least 2 years of experience in inventory management
- At least 2 years of ERP systems experience
- Experience in a manufacturing environment preferred
- Experience / exposure to business, operations preferred
- Experience and ability to write database queries
- Technical and data manipulation experience with Excel (pivot tables, Lookups), as well as SQL and VBA
- Tableau or BI platform experience an asset
- Strong analytical skills and solutions oriented with excellent problem-solving skills
- Ability to work in a team-oriented environment, managing multiple priorities
- Project management and organizational skills
- Ability to identify stakeholder needs through inquiry and inventory needs
- Ability to communicate results of complex findings to both technical and non-technical audiences

**This position works out of our Mississauga, Ontario location. Hours are typically 8:30am to 5:00pm with flexibility.**

**What’s in it For You?**
- You will join an amazing team of talented, passionate MAD people. Together, we've built an amazing culture—prioritizing enjoyment of our work.- An environment where you feel valued and inspired
- An attractive compensation package including paid vacation
- Work/life balance and flexibility
- Employee Wellness Program and discounts
- Continuous learning, development and internal training opportunities to grow your career
- Rewarding employee experience through the enjoyment of work, activities, perks, meals and more.

**About us**:

- Have you ever stepped into an elevator and been wowed?- It is very likely that the elevator was one of oursWe dream big here at MAD. It is our vision to
- **have a MAD product in every elevator**. We will do this by:
**Going Above and Beyond**: Partnering with our customers as dependable, value-add suppliers so they are successful in the eyes of their customers.**Simplifying Interactions**: Make the entire process easy by eliminating the laborious activities customers face.**Offering Industry-Leading Products**: Our technology, aesthetics, and reliability help our customers win.**Supporting with the Best People, Providing the Best Service**: We are experts in what we do.Want to see what it's like working at MAD?
- **Visit us on **Facebook
- **.**_
We are an Equal Opportunity Employer in accordance with the Accessibility for Ontarians with Disabilities Act, 2005 (AODA) and the Ontario Human Rights Code (OHRC). Acco