Senior BI Solutions Analyst, Supply Chain

Location: Markham, Ontario

Job Description:

At Pet Valu we understand that your pet is part of the family because we’re devoted pet lovers too. We have been providing pets with everything they need to live healthy, happy, and active lives for more than 40 years.

Our employees are the key to our success! As a growing organization, our employees apply their creativity and innovative ideas as they take ownership of their projects and growth. We pride ourselves in providing an open environment by managing with approachability and providing support to allow for career development.

Our Supply Chain team is growing and evolving to ensure that we continue to provide the best experience possible to support our Pet Valu community. We are excited to continue the journey with this role, to help us make a difference each day, supporting pets and their owners.

Reporting into our Manager, BI Solutions, the primary focus of the Senior Supply Chain BI Solutions Analyst role is to lead and support our supply chain strategy, user, and customer experience. Supporting Supply Chain systems, designing approaches using qualitative and quantitative methods through data and analytics to help us optimize and evolve our growing Pet Valu network.

The successful candidate will be responsible for overseeing data governance of Supply Chain reporting within Snowflake and Tableau. They will deploy interactive, visualizations and dashboards to the Supply Chain team including ELT. This candidate will provide subject matter expertise and insights to management on opportunities and options for technical solutions to business problems. They will support training and collaborate with IT to develop front-end user interfaces to support new capabilities.

They should be an effective communicator with the ability to collaborate with multiple levels of the organization, leveraging critical thinking skills to collect, analyze, and interpret data and situational/system opportunities. Senior Supply Chain Solutions Analyst role is ideal for someone passionate about solving opportunities, delivering leading insights, design, using qualitative and quantitative methods as an unlock to drive Supply Chain excellence and supporting key growth initiatives. With an overall belief in being part of something bigger. 

Essential Duties and Responsibilities

• Lead and support in managing Blue Yonder and WebPortal data maintenance/accuracy, and exception management to support Vendor and DC/Store order flow.
• Assist and at times lead ensuring Supply Chain application integrations are working as expected, identifying opportunities where they exist.
• Identify and design potential enhancement opportunities, collaborating with BA to represent the business in providing the requirements for development.
• Lead and support User Acceptance testing on various enhancements and maintaining detailed documents.
• Understanding the processes associated with inbound / outbound data flow between Supply Chain systems and ERP to help manage data issues.
• Utilize various data analysis tools and techniques to identify patterns, outliers, and areas for improvement.
• Perform complex data mining and ad-hoc data analysis using various tools.
• Leverage data visualization tools to present complex information in a clear and concise manner.
• Convert manual reporting into automated reporting / dashboards with insights to help drive the right level of visibility to the business.
• Work closely with business leads to gather and document business requirements to support Supply Chain initiatives.
• Ability to work positively with the team and cross-functional partners involved in key projects and/or Pet Valu business.
• Strong planning, prioritization, and time management skills.
• Self-motivated with a focus on driving exceptional results with a profound sense of teamwork and accountability.
• Create/generate reports/dashboards, writing scripts where possible to automate.
• Coordinate tasks for projects and other strategic initiatives with business leads.
• Perform other related duties as assigned.

Competencies:

Technical

• Familiarity with Blue Yonder (JDA) and data mining applications (Tableau, Power BI, Excel, IBM Cognos).
• Proficient with programming languages (SQL, R, Python, VBA, DAX, Scala).
• Experience with Generative AI technology stacks such as Tensorflow/Keras, PyTorch, etc.

Analytical          

• Strong analytical thinking and a commitment to improving data integrity and credibility for all programs.
• Superior analytical skills that enable teams to interpret and transform customer needs, converting them into a better customer experienc