Inventory Optimization Advisor

Alberta, Canada Job Family Group: Retail Operations Worker Type: Regular Posting Start Date: October 16, 2026 Business Unit: Downstream and Renewables Experience Level: Experienced Professionals

Job Description

What’s the role Shell is seeking for Inventory Optimization Advisor to join its team in Calgary. The Inventory Optimization Advisor is responsible for driving inventory performance, business analytics, reporting excellence, and technology-enabled improvements across Shell Canada's Mobility business. This role combines expertise in inventory management, business operations, analytics, process improvement, and digital transformation to deliver actionable insights, improve operational performance, and support data-driven decision making. The successful candidate will work closely with business stakeholders, Digital & IT teams, vendors, and external partners to optimize business outcomes and support strategic initiatives.

Analytics, Reporting, and Business Intelligence

• Design, develop, and maintain scalable reporting, analytics, and business intelligence solutions
• Translate business requirements into meaningful KPIs, dashboards, and actionable insights
• Develop and maintain SQL-based datasets, data models, and automated reporting processes
• Build and support Power BI, Power Apps, and Power Automate solutions
• Ensure reporting accuracy, data quality, governance, and reconciliation controls
• Conduct trend analysis, root cause investigations, and exception reporting to support operational and strategic decision making

Technology and Digital Transformation

• Lead and support technology initiatives that enhance inventory management, retail operations, customer experience, and business performance
• Partner with business stakeholders, Digital & IT teams, vendors, and project teams to define requirements, evaluate solutions, and support implementation
• Act as the business subject matter expert for inventory, reporting, and operational processes during technology deployments and enhancements
• Develop business cases, testing strategies, performance measures, and value realization plans for technology investments
• Identify opportunities to improve processes through automation, digitization, and analytics-driven solutions
• Monitor adoption and business benefits of implemented technologies and drive continuous improvement

Inventory Performance and Optimization

• Develop and implement strategies to improve inventory performance across the Mobility network
• Analyze inventory performance, shrink, stock availability, turnover, and ordering effectiveness to identify opportunities for improvement
• Monitor key business metrics and develop recommendations to improve inventory ownership returns and operational performance
• Partner with Category Management, Operations, and Retailers to drive inventory improvements and business outcomes
• Support inventory governance, controllership, and continuous improvement initiatives across the business
• Define operational procedure and policies, developing SOP and training guidelines for retailers and operations business

Stakeholder Management and Leadership

• Lead cross-functional initiatives involving business, technology, and external stakeholders
• Communicate complex analytical findings in a clear and actionable manner
• Influence decision making through data-driven recommendations and business insights
• Build strong partnerships across Mobility and support a culture of continuous improvement
• Mentor colleagues and help build analytical capability across the organization

What you bring

• The candidate must have legal authorization to work in Canada on a full-time basis
• Bachelor's degree in Data Analytics, Information Systems, Computer Science, or a related discipline
• 4+ years of experience in data analytics, reporting, or business intelligence
• Advanced SQL, Power BI, and Excel skills (Power Query, Power Pivot, VBA/macros)
• Experience with Power Apps, Power Automate, and automated reporting solutions
• Strong knowledge of data modeling, data governance, and reporting best practices
• Experience integrating and transforming data from multiple sources
• Background in inventory management, retail, merchandising, supply chain, or similar operations
• Understanding of business performance management, inventory controls, and operational reporting
• Experience leading analytics, digital transformation, or continuous improvement initiatives
• Ability to translate business requirements into reporting and system solutions
• Strong stakeholder, project, and change management skills

We are committed to creating a more equitable, inclusive, and diverse company