Allocation analyst Jobs in Oakville, ON

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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.