Senior Technical Specialist- Supply Chain Data Management

SickKids; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

SickKids is seeking a Senior Technical Specialist in Supply Chain Data Management. This role focuses on advanced programming, data analytics, and application development to enhance operational efficiency. The ideal candidate will possess strong analytical skills and technical expertise in various programming languages and tools. Join a diverse team committed to making a difference in children's health.

Qualifications

• Several years of experience in programming and data analytics.
• Strong project management skills, including experience facilitating Scrum meetings.

Responsibilities

• Develop and troubleshoot applications using Python, SQL, and VBA.
• Design and optimize data pipelines and database management systems.
• Create and manage KPIs aligned with strategic objectives.

Skills

Python

SQL

VBA

Data Analytics

Communication

Education

Bachelor's degree in Computer Science

Bachelor's degree in Data Science

Bachelor's degree in Engineering

Tools

Power BI

Tableau

Microsoft365

Jupyter Lab

Visual Studio Code

Job description

Press Control+M to start dragging object

Senior Technical Specialist- Supply Chain Data Management

Position Description

The Senior Technical Specialist plays a pivotal role in supporting SicKids Supply Chain Team through advanced programming, data analytics, and application development. This position demands exceptional organizational abilities, precise attention to detail, outstanding analytical skills, and effective communication to engage positively with end users across various levels of the organization.

Here's what you'll get to do

• Develop, maintain, and troubleshoot robust applications using Python, SQL, VBA, and other relevant technologies.
• Design, implement, and optimize data pipelines and database management systems.
• Collaborate closely with end users to gather requirements and advise on optimal application usage to streamline and enhance existing business processes.
• Create and manage comprehensive Key Performance Indicators (KPIs) aligned with departmental strategic objectives and operational goals.
• Develop intuitive and insightful dashboards using visualization tools such as Power BI (DAX, M), Tableau, Seaborn, Plotly, and Matplotlib.
• Create, maintain, and automate queries tailored to the diverse needs and requirements of end users.
• Demonstrate advanced proficiency with Microsoft365 suite, particularly MS Excel (including Add-ins), Power Query, Power Apps, Power Automate, and SharePoint.
• Manage scheduled tasks and automate processes using PowerShell, shell scripting, and Command Line Shell.

Here's what you'll need

• Bachelor's degree in Computer Science, Data Science, Engineering, or related field. Equivalent combinations of education and professional experience will be considered.
• Several years of demonstrable experience in programming and data analytics.
• Advanced proficiency in Python (Pandas, NumPy, Regex, PyODBC, Win32), SQL (T-SQL, Oracle), and VBA.
• Knowledge and passion of machine learning and AI agents is an asset
• Familiarity with IDEs such as Jupyter Lab/Notebook, Spyder, Visual Studio Code, and PyCharm.
• Experience with cloud platforms including MS Azure (SQL Server, Synapse, Data Factory, Blob Storage) or AWS (EC2, S3, Redshift).
• Expertise in relational and non-relational (NoSQL) database systems.
• Proficiency with scheduling tasks/processes using Windows Task Scheduler, Cron jobs, PowerShell, and shell scripting.
• Solid understanding of Agile software development methodologies, including experience with tools like SmartSheets, Jira, Asana, or MS Planner.
• Strong project management skills, including experience facilitating Scrum meetings and regular standups.
• Proficiency in dashboard development using visualization tools such as Power BI, Tableau, Seaborn, Plotly, and Matplotlib.
• Familiarity with C#, C++, React, and Java is advantageous.
• Excellent time management skills, with the ability to prioritize effectively, maintain high accuracy, and demonstrate meticulous attention to detail.
• Superior verbal and written communication skills, with the capability to interact professionally and collaboratively with all end users.
• A commitment to understanding and aiding in the pursuit of equity, diversity & inclusion
• The opportunity to make an impact. Regardless of your role or professional interest, you will be making a difference at SickKids and contributing to our vision of Healthier Children. A Better World .

Employment Type: Temporary Full-Time. 1 year contract

Our Commitment to Diversity

The children and families we care for are from a variety of communities, and so are our employees. We welcome and encourage everyone to join our organization and be part of our team.

When requested, SickKids will provide access and inclusion supports to eligible candidates to support their full engagement during the interview and assessment process. Information received related to access or inclusion will be addressed confidentially.

Thank you for your interest in joining SickKids. Only those applicants selected for an interview will be contacted. In accordance with our Hospital policy, employment at SickKids is conditional upon the Hospital's receipt of all necessary documentation.

How to Apply

Tip: Combine your cover letter and resume into ONE document of 20 pages or less as you cannot upload multiple documents as part of your application.

If you are still experiencing technical difficulties please email [e-mail] to send us a short description of the issues you are experiencing. Please note that we will not accept resumes sent to this inbox but we are happy to respond to requests for technical assistance.