Retail Operations Planning Analyst - LCBO, Toronto

AI Summary

The LCBO is seeking a Retail Operations Planning Analyst for an acting/contract role in Toronto, Ontario. This onsite position involves planning and administering the division's budgeting process for over 690 retail stores and head office cost centres. Key duties include financial data analysis, forecasting, and reporting, with a focus on Power BI dashboards and database management. Candidates require an undergraduate degree in accounting, finance, data science, or business, along with at least five years of relevant work experience.

About the Opportunity at LCBO

As a Retail Operations Planning Analyst at the LCBO in Toronto, you will play a crucial role in supporting the extensive retail operations across Ontario. This contract position is integral to the financial health and strategic planning of the organisation, focusing on the budgeting process for hundreds of LCBO stores and various Head Office cost centres. You will collaborate closely with the Manager, Retail Operations Planning, to ensure effective financial oversight and resource allocation. This involves not only the initial planning but also the ongoing administration and coordination of the division's financial frameworks, ensuring that all retail operations are supported efficiently.

Key Responsibilities and Data Management

A significant part of this role involves assembling and summarizing financial data to create impactful Power BI dashboards, providing essential information and insights to senior management. You will be responsible for analytical support, forecasting, and detailed reporting, contributing to informed decision-making across the company. Developing and maintaining complex, interrelated databases will be a core function, tracking vital metrics such as sales, labour, expense spending, and key performance indicators. Furthermore, you will analyze and critique projects and plans both before and after implementation to ensure value addition, while upholding rigorous data integrity and consistency across all reporting platforms through best practices in data governance. Understanding the nuances of LCBO's retail environment and its status as an Ontario government business entity is paramount, especially when handling sensitive information and ensuring privacy compliance.

What You Bring to the Role

To excel in this position, you will possess an undergraduate degree in accounting, finance, data science, or business, complemented by at least five years of experience in a similar analytical role. A highly developed understanding of LCBO retail operations and the broader retailing landscape is essential, alongside the ability to undertake and clearly explain complex financial and statistical analyses. Proficiency in SQL for data analysis, reporting, and database management is considered a valuable asset, as is formal training or certification in Power BI or similar analytics software. Experience with various software packages, particularly Microsoft Excel, Access, and Power BI, is expected. A sound understanding of Generally Accepted Accounting Principles (GAAP) is required, as are strong verbal and written communication skills to present complex data in an actionable manner to both technical and non-technical stakeholders. The LCBO is committed to fostering an inclusive workplace, and your contributions will be valued as you help support Ontario businesses and communities.