Retail Operations Planning Analyst

LCBO; Toronto; Hybrid; CAD 65,000 - 112,000; Full time

Job summary

A leading organization in Ontario is seeking a detail-oriented professional for a hybrid role in Retail Operations Planning. The successful candidate will manage budgeting processes for over 690 stores, analyze financial data, and support senior management with insights. This role requires strong SQL and data analysis skills, along with excellent communication abilities to present complex data clearly. Join a company committed to diversity and community impact, offering a comprehensive benefits package.

Benefits

Employee & Family Assistance Program

Defined Benefit Pension

Discounts on products and services via Workperks

Qualifications

• 5+ years of work experience in a similar position.
• Financial designations such as CPA would be considered an asset.

Responsibilities

• Collaborate in planning and administering the division’s budgeting process.
• Provide analytical, forecasting, and reporting support to senior management.

Skills

SQL

Data Analysis

Communication

Education

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

Tools

PowerBI

Microsoft Excel

Microsoft Access

Job description

Location Address:
100 Queens Quay East, 9th Floor, Toronto

Number of Openings: 1

Job Posting Description:

This is a hybrid role

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

1. 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.
2. Assemble and summarize financial data to optimally structure various Power BI dashboards.
3. Provide analytical, forecasting, reporting, and project support to senior management.
4. Administer various LCBO programs & the organization’s Employee Relocation Program.
5. 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.
6. Use SQL to query large datasets efficiently, integrate data from multiple sources, and support the development of custom reports and dashboards.
7. Analyze and critique project and plans prior to and after implementation to add value to the process.
8. Ensure data integrity and consistency across multiple reporting platforms and databases, applying best practices in data governance.

About You

1. Undergraduate degree in accounting, finance, data science, or business.
2. 5+ years of work experience in a similar position.
3. Financial designations such as CPA would be considered an asset.
4. Proficiency in SQL for data analysis, reporting, and database management is considered an asset.
5. Formal training or certification in PowerBI or similar analytics software is preferred.
6. Highly developed understanding of LCBO retail operations and retailing in general. Must have the ability to undertake and explain complex financial and statistical analyses.
7. Experience with various software packages with bias to databases, statistical modeling software (primarily Microsoft Excel and Access), and business intelligence software (primarily Microsoft PowerBI).
8. Demonstrate understanding of the complexities and sensitivities of operating a “government business entity” in a competitive marketplace.
9. A sound understanding of Generally Accepted Accounting Principles (GAAP).
10. Strong verbal and written communication skills with the ability to present complex data clearly to non-technical stakeholders.
11. 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 more.

There is a world of opportunities at the LCBO…

Join an organization where you can be challenged while achieving your potential. A place to 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 valued. Be part of our journey as we invest in people and technology to transform the organization. There 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 will contact only those selected for an interview.

The LCBO collects and uses your personal information under the authority of the Liquor Control Board of Ontario Act, 2019, SO 2019, c 15, Sch 21, Section 3, in compliance with the Freedom of Information and Protection of Privacy Act for job application processing. By clicking “Apply with LinkedIn,” you agree to share your information with our service providers engaged for recruitment and HR activities.

If you have questions about the LCBO’s collection and use of personal information, contact:

Freedom of Information and Privacy Office

100 Queens Quay East, 9th Floor

Toronto, Ontario M5E 0C7

Telephone: [phone]

E-mail: [e-mail]

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.

}