Location Address:

100 Queens Quay East, 9th Floor, Toronto

Number of Openings:

1

Pay

$69,001.00 - $120,524.00

Job Posting Description:

This is a hybrid role #LI-Hybrid

Reporting into the Director of VMO, the data analyst plays a crucial role within the IT department, focusing on leveraging advanced data analytics, visualization, and reporting skills to provide insights into vendor performance and IT spending. You will transform complex datasets into data-informed decision-making across the organization.

Are you passionate about data exploration, visualization, and storytelling through analytics? Do you use your analytical expertise to identify trends, operational efficiencies, and areas for improvement? Then this is the role for you!

About the Role

Data Analysis and Reporting (70%)

• Develop comprehensive dashboards and reports using tools such as Excel pivot tables and Power BI, to visualize vendor performance, spend analysis, and contractual compliance.
• Conduct in-depth analysis of vendor data to identify trends, anomalies, and opportunities for cost savings or performance improvements.
• Create vendor reports for Leadership and vendor business reviews, and update and monitor spend, vendor risk profiles with IT's strategic vendors.
• Develop and implement Vendor Management reporting procedures to refine the reporting process and provide vendor reports for senior management.
• Perform data analysis to identify patterns, trends, and anomalies in large datasets related to IT vendors and spending.
• Create compelling data narratives and visualizations to communicate complex findings to both technical and non-technical partners.

Vendor Performance Measurement (15%)

• Implement reporting on KPIs and metrics to assess vendor performance objectively.
• Build vendor scorecards using data visualization techniques to present complex information in an easily understandable format.
• Help manage Service Level Agreements (SLAs) by providing data-driven insights.
• Contribute to vendor Quarterly Business Reviews (QBRs) by preparing data-backed presentations and insights.

Process Improvement and Spend Analysis (15%)

• Analyze commercial contractual terms, pricing structures, and historical spend data to identify cost-saving opportunities and support vendors performance enhancement.
• Develop predictive models to forecast future spend and resource requirements.
• Support the Vendor Risk framework by providing data analysis for informed decision-making in vendor selection, onboarding and annual assessments.
• Develop and maintain databases and data collection systems to support efficient vendor management processes.
• Collaborate with IT teams to implement data-driven solutions that enhance vendor management capabilities.

About you

• Bachelor's degree in Business Administration, Data Science, or a related field.
• Strong proficiency in data visualization tools (e.g., Power BI, D3.js) and the Microsoft suite of products
• 5+ years of experience supporting IT vendor management, procurement or strategic sourcing groups.
• Strong communication skills with the ability to present complex data in a clear, concise manner.
• Proven track record of developing impactful data visualizations and dashboards that inform business decisions.
• 5+ years of experience with database management and SQL skills for complex data querying and manipulation
• Ability to analyze various business domains, including vendor management and procurement.
• Vendor Management or Procurement certification (e.g., CIPMM).

There is a world of opportunities at the LCBO…

Join an organization where you can be challenged while achieving your true potential. A place where you can make a positive impact supporting Ontario business and communities. Discover a safe, healthy, diverse, inclusive, and accountable workplace where your wellbeing is our top priority. At the LCBO, your contributions are respected and valued. Be part of our journey as we invest in people and technology to transform an organization. There really is a world of opportunities at the LCBO.

We foster a culture of inclusion and belonging, so everyone feels valued, respected, and heard. The LCBO is an equal opportunity employer and committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility of Ontarians with Disabilities Act. If contacted for an interview or employment opportunity, please advise if you require an accommodation.

Please submit your resume via Workday by 11:59pm on the deadline date. We appreciate your interest and advise that only those selected for an interview will be contacted.

Work Hours:

36.25

Union / Non-Union:

Non-Union

Job Posting End Date:

December 3, 2024

The LCBO is an equal opportunity employer and committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act.