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.
Decision Support & Scenario Analysis
• 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.
Reporting & Visualization (Supportive Function)
• 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).
Continuous Improvement & Innovation
• 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:
• N/A
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.
• Modeling & Advanced Analytics:
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.
iii. Data Pipelining & Automation:
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 Alexandra.Bunardzic@summitsearchgroup.com. 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.
Alexandra Bunardzic
Job ID
City
- Vancouver, BC
Alexandra Bunardzic
Job ID
City
- Vancouver, BC
