Business Analyst

BMO Financial Group; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

Randstad Canada is seeking a Senior Data Analyst for a 6-month contract with a premier global enterprise in the Retail/CPG sector. You will bridge technical data architectures and business strategy, delivering data-driven insights and interactive dashboards using SQL, Power BI, and Tableau.

You will partner with product, engineering, and business teams to identify growth opportunities, govern data, and enable executive storytelling.

Qualifications

• 4+ years of professional experience in data analysis or business intelligence within Retail or CPG datasets.
• Strong expertise writing complex SQL queries for data extraction and data manipulation.
• Hands-on experience creating dashboards in Power BI or Tableau (or Looker).
• Understanding of dimensional modeling and relational database design.
• Experience with Jira/Confluence in Agile delivery environments.

Responsibilities

• Product analytics and strategy: analyze user behavior and translate data into product enhancements.
• Data visualization: build Power BI and Tableau dashboards for KPI communication to technical and executive stakeholders.
• Data querying and pipeline optimization: write and tune complex SQL across databases and data lakes.
• Data governance and quality assurance: establish validation protocols and governance standards.
• Agile collaboration: translate business needs into user stories and participate in sprint planning.

Skills

SQL

Power BI

Tableau

Data storytelling

Stakeholder management

Education

Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related quantitative field

Tools

Jira

Confluence

BigQuery

HiveQL

Teradata

Job description

Our client, a premier global enterprise leader in the retail and Consumer Packaged Goods (CPG) sector, is seeking an experienced, highly analytical Data Analyst (Senior Business Intelligence & Insights Analyst) to join their enterprise analytics and product strategy group.

In this strategic, hands-on role, you will bridge the gap between technical data architectures and business strategy. You will partner closely with cross-functional product, engineering, and business teams to identify growth opportunities, build scalable data governance practices, and transform complex datasets into clear, actionable narratives. Utilizing SQL, Power BI, and Tableau, you will design interactive executive dashboards, write complex database queries across enterprise data lakes, and deliver data-driven insights that directly influence product features and operational decision-making.

Duration: 6-Month Contract (with high potential for extension)

Advantages

High-Impact Enterprise Scope: Directly influence product strategy, user experience features, and business growth for a top-tier retail enterprise.

Modern Big Data Ecosystem: Work with enterprise-scale cloud and on-premise data infrastructure, including data lakes and modern BI platforms.

Cross-Functional Executive Visibility: Partner directly with cross-functional product managers, designers, and business leaders to deliver executive-level data storytelling.

Structured Agile Environment: Operate within a collaborative Agile delivery framework with clear sprint goals and task prioritization.

Responsibilities

Product Analytics & Strategy: Partner with feature teams and product managers to analyze user behavior, identify operational efficiency gaps, and translate data into product enhancements.

Data Visualization & Storytelling: Design, construct, and maintain interactive Power BI and Tableau dashboards to communicate KPIs clearly to technical and executive stakeholders.

Data Querying & Pipeline Optimization: Write, tune, and maintain complex SQL queries across relational databases, cloud storage, and big data environments to deliver ad-hoc analyses and recurring reports.

Data Governance & Quality Assurance: Define data validation protocols, establish governance standards, and organize documentation to ensure dataset accuracy, security compliance, and integrity.

Agile Stakeholder Collaboration: Facilitate data intake sessions, translate business needs into user stories in Jira/Confluence, and participate in sprint planning, retrospectives, and backlog grooming.

Qualifications

Retail / CPG Domain Depth: 4+ years of professional experience in data analysis or business intelligence, with direct exposure to Retail or CPG industry datasets and user analytics.

Advanced SQL Querying: Strong, proven expertise writing complex SQL queries for data extraction, profiling, and manipulation (MS SQL, BigQuery, HiveQL, or Teradata).

Enterprise BI Systems: Hands-on mastery in creating data models, measures, and visual dashboards using Power BI or Tableau (or Looker).

Data Modeling & Architecture: Deep understanding of dimensional modeling, relational database design, and structured/unstructured data manipulation.

Agile & Workflow Tools: Practical experience working within Agile/Scrum delivery teams using tools like Jira and Confluence.

Education: Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related quantitative field (Master’s degree is a strong asset).

Preferred Assets & Nice-to-Haves

Experience operating within big data and distributed processing environments (Hadoop / HDFS, Data Lakes).

Hands-on proficiency with BigQuery, HiveQL, or Teradata.

Summary

If you are a tech-savvy Data Analyst who pairs 4+ years of enterprise analytics mastery with strong SQL, Power BI/Tableau, and Retail/CPG domain experience, this 6-month contract opportunity is an ideal next step. Bring your data storytelling, database querying precision, and analytical mindset to our client's team today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada’s workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [e-mail] to ensure their ability to fully participate in the interview process.