Senior BI Solutions Analyst

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 experience.
• Use data to provide business insights that support our transformation journey.
• Write scripts to analyze data to discover patterns, meaningful relationships, irregularities, and trends.
• Ability to deal with ambiguity, prioritizing needs based on outcomes leveraging data.

Teamwork

• An effective team player who adds complementary skills and contributes valuable ideas and feedback.
• Accountable for fulfilling any commitments made to others on the immediate or cross functional team.
• Ensure the right business leads are informed and involved when required.
• Build partnerships and work collaboratively with teams to achieve shared objectives.
• Willing to “roll up their sleeves” when necessary to support tasks.

Execution with excellence

• Take on new opportunities and challenges with a sense of urgency and enthusiasm.
• Learn innovative methods, tools, and technology and apply them to business requests and tasks.
• Demonstrate the ability to work independently on complex technical and business opportunities.
• Acquire and utilize the necessary information from subject matter experts to deliver excellence.

Communication

• Establish and maintain effective, dynamic relationships with management and user groups across the organization.
• Demonstrate the ability to present and communicate effectively across cross functional teams, leadership, and third-party providers.

Experience, Education, Certifications

• Degree or diploma in Computer Science, Finance, Economics, Analytics, Business, Math, Statistics, or related field.
• 3-5 years of practical analytical experience in a professional environment or business setting in Supply Chain.
• Preferably 3 – 5 years of Blue Yonder Supply Chain application experience.
• Advanced knowledge of SQL to query relational databases.
• Experience in areas such as information retrieval, natural language processing, data analytics and information visualization.
• Enhanced skills in using and implementing data visualization tools such as Power BI or Tableau.
• Experience with open-source languages such as R, Python is required.
• Strong knowledge in AI/ML methodologies, Generative AI, Natural Language Processing, etc.
• Advanced knowledge of Microsoft 365 applications including Excel, Power Automate, SharePoint, Teams, Word, and Outlook.
• Excellent analytical and communication skills (written and verbal).
• Must be able to travel to offices, stores, and distribution centers as required.

Working Conditions

• Flexible hybrid work schedule allowing for work from home, office, and distribution center.
• Able to work in both warehouse and office environments.
• Willing and able to travel up to 10 -25% of the time

#CORPHIRE