Retail Operations Planning Analyst

Job Responsibility: Location Address: 100 Queens Quay East, 9th Floor, Toronto Number of Openings: 1 Job Posting Description: This is a hybrid role #LI-Hybrid Salary Range: $65,203.00 - $111,078.00 Are you passionate about conducting analysis and identifying key findings? Reporting to the Manager of Retail Operations Planning, you will plan, develop, coordinate, and administer the division's budgeting process for all stores and retail Head Office cost centres. You will also assist in procuring services, equipment, and technology necessary for the successful running of the division. If you are a team player, who is agile, results-driven, and enthusiastic about taking initiative, then this is the role for you! About the Role

• Collaborate with the Manager, Retail Operations Planning in planning, developing, coordinating, and administering the division's budgeting process for 690+ stores and all Retail Head Office cost centres.

• Assemble and summarize financial data to optimally structure various Power BI dashboards.

• Provide analytical, forecasting, reporting, and project support to senior management.

• Administer various LCBO programs & the organization's Employee Relocation Program.

• Develop and maintain various complex and interrelated databases used to track progress in sales, labour, and expense spending, KPI's and other metrics, Trade Area impacts of new stores, Health and Safety reporting, Daily Sales Forecasting, and vendor contract oversight, to report at various levels of the company.

• Use SQL to query large datasets efficiently, integrate data from multiple sources, and support the development of custom reports and dashboards.

• Analyze and critique project and plans prior to and after implementation to value add the process.

• Ensure data integrity and consistency across multiple reporting platforms and databases, applying best practices in data governance.

About You

• Undergraduate degree in accounting, finance, data science, or business.

• 5+ years of work experience in a similar position.

• Financial designations such as CPA would be considered an asset.

• Proficiency in SQL for data analysis, reporting, and database management is considered an asset.

• Formal training or certification in PowerBI or similar analytics software is preferred.

• Highly developed understanding of LCBO retail operations and retailing in general. Must have the ability to undertake and explain complex financial and statistical analyses.

• Experience with various software packages with bias to databases, statistical modeling software, (primarily Microsoft Excel and Access), and business intelligence software (primarily Microsoft PowerBI).

• Demonstrate understanding of the complexities and sensitivities of operating a “government business entity” in a competitive marketplace.

• A sound understanding of Generally Accepted Accounting Principles (GAAP) principles.

• Strong verbal and written communication skills with the ability to present complex data in a clear and actionable manner to non-technical stakeholders.

• Experience working in a unionized environment would be considered an asset.

We offer a comprehensive suite of benefits, including access to an Employee & Family Assistance Program, a Defined Benefit Pension, discounts on products and services via Workperks, and much more. 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. The LCBO collects and uses the personal information you provide under the authority of the Liquor Control Board of Ontario Act, 2019, SO 2019, c 15, Sch 21, Section 3 and in compliance with the Freedom of Information and Protection of Privacy Act for the sole purpose of processing your job application. When you click “Apply with LinkedIn” you are agreeing to share your information with our service providers engaged by us in connection with recruitment and human resources related activities. If you have any questions concerning the LCBO's collection and use of personal information, please contact: Freedom of Information and Privacy Office 100 Queens Quay East, 9th Floor Toronto, Ontario M5E 0C7 Telephone: View phone number on ca.edajobs.com E-mail: View email address on ca.edajobs.com Work Hours: 36.25 Union / Non-Union: Non-Union Job Posting End Date: May 16, 2025 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.