Western Canada Operations Data Modeling Analyst

Summit Search Group; British Columbia; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company is seeking a Western Canada Operations Data Modeling Analyst. The role focuses on implementing data models for operational excellence, requiring strong analytical skills, experience in data analytics, and proficiency in tools like Power BI and SQL. A continuous improvement mindset and effective cross-functional collaboration are essential as you work to enhance operational processes and drive data-driven insights.

Qualifications

• Master's Degree or minimum of 2 years of experience in data analytics.
• Experience in reporting and visualization using Power BI.
• Hands-on experience with optimization modeling and predictive analytics.

Responsibilities

• Develop and implement predictive models for operational decision-making.
• Collaborate with cross-functional teams to ensure data-driven solutions.
• Present complex modeling results in accessible formats.

Skills

Analytical Skills

Data Visualization

Problem Solving

Collaboration

Education

Post-secondary education in Data Science, Operations Research, or related fields

Tools

Power BI

SQL

Python

R

Job description

Western Canada Operations Data Modeling Analyst

Western Canada Operations Data Modeling Analyst

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Summit Search Group

Managing Partner, Summit Search Group / Successfully Recruiting Top Tier Professionals in Various Markets

POSITION TITLE:

Western Canada Operations Data Modeling Analyst

REPORTS TO:

Western Canada Manager, Operations Data

DEPARTMENT:

Operations Support

DIRECT REPORTS:

n/a

INDIRECT REPORTS:

n/a

Purpose of Position:

The Western Canada Operations Data Modeling Analyst, reporting to the Western Canada Manager, Operations Data, plays a key role in driving operational excellence and continuous improvement across all Western Canada programs. This role is responsible for developing and maintaining advanced data models that enable predictive and prescriptive analytics, simulation-based decision support, and network flow optimization.

The analyst will collaborate with cross-functional stakeholders to comprehend business requirements, transform raw operational data into clean, structured, and scalable models, and produce actionable insights that inform collection routing, resource planning, and performance management. This role encompasses advanced analytics, operational data engineering, and decision-making, ensuring that data-driven solutions are aligned with strategic and tactical business goals.

PRINCIPAL DUTIES AND RESPONSIBILITIES:

Predictive & Prescriptive Analytics

• Develop and implement predictive models to forecast material volumes, contamination rates, and service demand patterns using historical and real-time data.

• Build prescriptive analytics tools to support operational decision-making, such as optimal routing, shift planning, and resource allocation.

• Leverage simulation modeling (e.g., discrete event or agent-based models) to test operational scenarios and evaluate process improvement opportunities.

Optimization & Network Flow Modeling

• Design and maintain mathematical optimization models to enhance efficiency across the collection and post-collection logistics network, including routing, bin distribution, facility throughput, and scheduling.

• Work collaboratively with Operations and Logistics teams to translate real-world constraints into solvable models using tools like Excel based Solvers or programming language-based solvers.

Data Modeling & Transformation

• Structure and maintain foundational data models from raw operational and logistics data sources (e.g., collection events, contamination logs, vendor reports).

• Build clean, scalable, and automated data transformation pipelines using SQL, Python, or R in coordination with reporting teams. Some experience in cloud-based data ETL is desirable, but not mandatory

• Harmonize disparate data sources across jurisdictions and program types to ensure consistent, integrated modeling approaches.

• Develop intuitive decision-support tools and scenario analysis frameworks for stakeholders to evaluate trade-offs (e.g., cost vs. service level, staffing vs. volume).

• Present complex modeling results in accessible formats (dashboards, storyboards, written insights) for non-technical decision-makers.

• Support dashboard and reporting initiatives by delivering model outputs and indicators that integrate into Power BI or other visualization platforms.

• Collaborate with the Reporting Analyst to ensure modeling insights align with KPIs and metrics tracked across the organization.

• Ability to convert into dashboard concept that can be implemented by reporting analysts

Cross-Functional Collaboration & Governance

• Engage stakeholders from Supply Chain, Operations, Sustainability, and IT to define modeling requirements and validate outputs.

• Document modeling assumptions, data dictionaries, and business logic clearly to ensure transparency and reproducibility.

• Good understanding of Agile Delivery platform along with understanding of Agile principles

• Maintain data governance practices to ensure data integrity, traceability, and alignment with enterprise systems (e.g., SAP, AWS).

• Evaluate current operational processes and identify opportunities for data-driven improvements through automation, optimization, and experimentation.

• Contribute to technology pilots (e.g., route sensors, AI-driven contamination detection) by integrating results into models or decision tools.

• Promote a Continuous Improvement mindset within the data and operations teams, identifying standardization and automation opportunities.

Interpersonal/Communications:

a) Internal Relationships:

• Work closely with the Western Canada Manager, Operations Data to identify reporting opportunities and requirements.

• Collaborate with Recycle BC and SK Recycles staff to deliver timely reporting.

b) External Relationships:

• Work with external consultants/contractors to achieve project deliverables.

• Coordinate with managers in Data & Report Development, Enterprise Knowledge, Business Intelligence & Analytics, and Data Visualization.

• Work closely and effectively with our service provider partner/s

Responsibility:

a) Supervision:

b) Resources/Budget:

• Assist with the identification of IT hardware and software requirements.

c) Decision Making:

• Provide input and make data-driven recommendations for operational strategies related to the programs.

Education/Skills/Experience/Designations:

Education:

Post-secondary education in Data Science, Operations Research, Applied Mathematics, Engineering, Computer Science, or Business/Operations Analytics is highly desirable.

Additional coursework or certifications in optimization, simulation, or statistical modeling is an asset.

Experience:

• Master's Degree or Minimum of 2 years of experience in the data analytics field, with exposure to operational data in logistics, supply chain, utilities, or related fields.

• Hands-on experience in reporting, visualization (Power BI), and data transformation using Power Query or Excel.

• Experience or strong interest in optimization modeling, simulation, and predictive/prescriptive analytics applied to real-world operational processes.

• Exposure to data engineering workflows and transitioning analytics environments (e.g., SAP BW to cloud platforms like AWS) is an asset.

• Knowledge/Competencies/Skills:

Data & Analytics Tools:

i. Proficiency in Power BI, including strong skills in DAX, Power Query, and visual storytelling.

ii. Comfortable with data wrangling using Excel, Power BI, and scripting tools like R or Python.

iii. Familiarity with SAP ecosystems including SAP Business Warehouse (BW) and SAP S4/HANA.

iv. Understanding of cloud-based analytics infrastructure such as AWS Redshift, S3, and Glue, or readiness to learn.

i. Foundational or intermediate experience in predictive modeling, simulation, optimization, or anomaly detection using Python, R, or a similar toolset.

ii. Ability to translate operational questions into data-driven models and scenario analysis.

iv. Awareness of or hands-on experience with ETL design, pipeline automation, or scripting to streamline data delivery.

v. Ability to support the transition from manual reporting to automated, scalable modeling frameworks.

• Other Technical Skills:

i. Exposure to CRM platforms (e.g., C4C), Microsoft Dynamics, and cloud tools such as AWS.

ii. Basic working knowledge of JIRA, SharePoint, or other workflow/project management tools.

iii. Comfort with version control and structured deployment/release processes.

Soft Skills:

• Strong analytical and problem-solving skills with attention to operational impact.

• Ability to clearly communicate technical concepts to non-technical stakeholders.

• Effective cross-functional collaboration and relationship-building skills.

• Strong organizational and time management capabilities.

• Self-starter who can work independently while aligning with evolving business needs.

• A Continuous Improvement mindset focused on process optimization and proactive problem-solving.

Working Conditions:

• Periodic travel throughout Western Canada may be required. Valid provincial driver’s license required.

• Peak work period (quarterly reporting, business planning/budgeting etc.) may require extended hours to meet deadlines.

• Comfortable and prepared to perform effectively in an environment that undergoes frequent change.

To apply, please submit your resume to this posting or email [e-mail]. Only qualified individuals will be contacted.

Summit Search Group is a fair and equitable search firm. We welcome applications from all candidates regardless of race, ethnicity, religion, disability, age, gender identity, or sexual orientation. Accommodations are available upon request for the recruitment and selection process.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Supply Chain and Analyst

Referrals increase your chances of interviewing at Summit Search Group by 2x

Sign in to set job alerts for “Modeling Analyst” roles.

Quantitative Equity Analyst – Process Engineering

Burnaby, British Columbia, Canada 1 week ago

Modeling expert Senior Analyst - Inventory insights

Quantitative Equity Analyst – Data Science

Burnaby, British Columbia, Canada 1 week ago

Surrey, British Columbia, Canada 4 days ago

Surrey, British Columbia, Canada 1 month ago

Richmond, British Columbia, Canada CA$70,000.00-CA$90,000.00 1 month ago

Richmond, British Columbia, Canada 2 weeks ago

Burnaby, British Columbia, Canada 4 weeks ago

Senior Technical Analyst (Data Engineer)

Burnaby, British Columbia, Canada 1 month ago

Coquitlam, British Columbia, Canada 6 days ago

Richmond, British Columbia, Canada 5 days ago

Surrey, British Columbia, Canada 1 week ago

Data Taxonomy Specialist (Code Methods Analyst)

Richmond, British Columbia, Canada 4 days ago

Burnaby, British Columbia, Canada 1 week ago

Burnaby, British Columbia, Canada 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.