Retail Data Analytics Lead - Power BI & SQL Insights

OSTTRA Group; Toronto; On-site; CAD 61,000 - 93,000; Full time

Job summary

Ontario Cannabis Store in Toronto seeks a Data Analyst, Customer Support Operations to transform retailer and service data into actionable insights. You will build dashboards, scorecards, and reports, collaborating with CRM, COS, data science, and tech partners to enable data-driven decisions.

You will translate complex data for both technical and non-technical audiences, improve reporting accuracy, and support continuous improvement across retailer operations and customer experience.

Qualifications

• Advanced analytics and BI experience translating business needs into reporting solutions.
• Proven ability to develop and maintain Power BI dashboards and reporting environments.
• Experience with SQL and relational databases, data modeling and data governance.

Responsibilities

• Develop retailer-focused dashboards, scorecards, and reports to support growth and performance.
• Partner with CRM, COS, and data teams to deliver insights on sales, product mix, and engagement.
• Produce recurring and ad hoc reports for retailer reviews and planning.
• Analyze retailer data to identify trends, risks, and opportunities for improvement.
• Translate data into actionable insights for retailer-facing teams and leadership.
• Lead data program activities, manage requirements, testing, and stakeholder feedback.
• Design and maintain scalable data models and data dictionaries in Power BI workspaces.
• Write and optimize SQL queries to extract data from multiple sources.
• Ensure data quality, governance, and secure access across reporting environments.

Skills

Data analytics

SQL querying

Stakeholder management

Forecasting

Data visualization

Excel modelling

Education

Post-secondary degree in Data Analytics or related field

Tools

Power BI

SQL

Excel

Job description

Ontario Cannabis Store in Toronto seeks a Data Analyst, Customer Support Operations to transform retailer and service data into actionable insights. You will build dashboards, scorecards, and reports, collaborating with CRM, COS, data science, and tech partners to enable data-driven decisions.

You will translate complex data for both technical and non-technical audiences, improve reporting accuracy, and support continuous improvement across retailer operations and customer experience.