Supply Chain Business & Data Analyst

St. Michael's Hospital; Toronto; On-site; CAD 70,000 - 95,000; Full time

Job summary

A leading health organization seeks a Supply Chain Business and Data Analyst to support data management and improvements in Supply Chain operations. This role involves collaboration with internal teams and external vendors, requiring extensive data analysis skills and experience in hospital environments. The ideal candidate will possess a Bachelor's degree in a related field and a proven track record in supply chain roles.

Qualifications

• 3+ years in a supply chain role with a sound understanding of hospital operations.
• 5+ years of experience writing SQL or VBA reports, with a focus on data management.
• Strong project management and analytical skills to support quality improvement initiatives.

Responsibilities

• Perform data management and analysis to support Supply Chain operations.
• Manage relationships with stakeholders and lead quality improvement projects.
• Create training materials for stakeholders to utilize data effectively.

Skills

Analytical Skills

Relationship Management

Communication Skills

Project Management

Education

Bachelor's Degree in Related Field (IT, Business Analytics, Health Analytics)

MBA or Related Qualification

Tools

SQL

VBA

Advanced Spreadsheets

Database Management Systems

Job description

A Supply Chain Business and Data Analyst performs data management, system management, and business analysis activities to support effective Supply Chain operations and Supply Chain quality improvement across all three Unity Health Toronto sites. The position interacts with a large group of varied stakeholders including internal Supply Chain colleagues, other Unity Health Toronto staff across departments, and external third-party vendors.

Data management components of the role include comprehensive data querying and analysis, data modeling, database management, data quality management, and data standards support. Systems-related activities include the provision of subject matter expertise for Supply Chain-related systems upgrades and the monitoring of Supply Chain systems on an ongoing basis to ensure they function and support staff optimally. In addition, a Supply Chain Business and Data Analyst also leads quality improvement projects that support workflow optimization and performance management across all of Supply Chain. These activities require relationship management with multiple groups of stakeholders, significant business analysis expertise, and advanced knowledge of best practices implementation.

The position is instrumental in the development and maintenance of a comprehensive Supply Chain quality framework.

Duties & Responsibilities

• Work with key stakeholders to identify and document relevant requirements, and ensure Supply Chain data sets capture accurate information for evidence-based reporting and decision-making
• Run queries and mine data from multiple sources, use statistical tools to interpret data sets, and identify trends and patterns for diagnostic and predictive analytics
• Present the results of data analysis work and prepare reports with contextual information to effectively communicate a narrative for clinical trending, cost savings, and decision-making
• Design and maintain Supply Chain databases and troubleshoot and resolve data-related issues
• Execute ongoing internal and external Supply Chain reporting activities in a very complex landscape that includes multiple Unity Health Toronto sites, multiple government bodies / funders, intricate funding models, and multiple GPO/SSOs from which data has to be collected and collated
• Work with the Supply Chain materials management team and clinical stakeholders to develop and maintain an inventory early warning notification system to proactively inform required supply needs and prevent stockouts
• Support the development of organization-wide data standards and policies for Supply Chain
• Participate in the recurring auditing of Supply Chain data quality and data quality improvement initiatives
• Create training materials that empower stakeholders to understand how to mine and analyze data
• Understand the current state of Unity Health Toronto's ERP solution(s) functionality and the proposed future state impact of changes based on vendor documentation and/or upgrades
• Perform system functional reviews to identify gaps in Unity Health Toronto's ERP solution(s) including any hosted third-party software
• Validate the technical requirements of any additional business or clinical system interfacing with Unity Health Toronto's ERP solution(s)
• Investigate potential solutions that may strengthen the system to produce additional output (e.g. reports that are not part of the standard solution provided by the software / system)
• Identify, understand and plan for organization and staff impacts of Unity Health Toronto's ERP solution(s)
• Ensure new technical requirements are properly integrated with existing processes and skill sets
• Interact with internal and external end users to learn and document requirements that are then used to produce business requirements documents
• Write technical requirements from a critical phase and interact with designers / developers to understand software limitations
• Help programmers during system development by providing use cases, flowcharts and database designs
• Write reports leveraging various reporting tools / software and develop testing methodologies
• Evaluate workflow, identify areas of improvement, and recommend solutions that foster best practice and the achievement of performance targets
• Lead the development of Supply Chain-wide performance metrics and monitor metrics on an ongoing basis to and sustain process improvements
• Provide business analysis and data analysis support for the integration of clinical data and ERP data (items, inventory, purchase orders, case costing, etc.)
• Other duties as assigned
  
  

Qualifications

• Bachelor's Degree in Related field (IT, business analytics, health analytics, etc.) or MBA or related qualification preferred
• At least three years in a supply chain role to ensure a working knowledge of supply chain concepts required
• Sound knowledge of hospital operations including at least three years of hospital experience preferred
• Advanced data management and analytics education/experience including five years writing SQL or VBA reports required
• At least three years of recent experience maintaining supply chain systems, preferably Infor preferred
• At least five years of experience working on quality improvement initiatives preferred
• Advanced knowledge and experience with spreadsheets and database management required
• Experience writing and/or defining software program code, managing systems upgrade and modification projects, determining system problems, and identifying solutions
• Strong analytical skills for conducting systems reviews and participating in business quality improvement initiatives
• Excellent oral and written communication skills
• Strong relationship management and conflict resolution skills
• Ability to work effectively in a dynamic, ever-changing environment
• Strong project management skills
• Ability to work independently
  
  

Unity Health Toronto is committed to creating an accessible and inclusive organization. We strive to provide a recruitment process that is barrier-free and in compliance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code. We understand that you may require an accommodation at any stage of the recruitment process. When you are contacted, please inform the Talent Acquisition Specialist and we will work with you to meet your accommodation needs. We want to emphasize that all accommodation requests are handled with the utmost confidentiality, respecting your privacy and dignity.