Inventory Optimization Advisor

Shell Canada; Calgary; On-site; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Remote work options

Flexible working hours

Parental leave

Diversity & inclusion

Job summary

Shell Canada in Calgary seeks an Inventory Optimization Advisor to drive inventory performance across the Mobility network. You will lead analytics, reporting, and digital transformation initiatives to deliver actionable insights and data-driven decisions.

The role requires 4+ years in data analytics, advanced SQL, Power BI, and experience with Power Apps/Automate. You will partner with IT and business teams to optimize operations and governance.

Qualifications

• Bachelor's degree in a relevant field.
• 4+ years of experience in data analytics, reporting, or BI.
• Advanced SQL, Power BI and Excel skills required.
• Experience with Power Apps & Power Automate.
• Knowledge of data modeling and governance best practices.
• Background in inventory, retail, or supply chain operations.

Responsibilities

• Design, develop, and maintain scalable reporting and BI solutions.
• Translate business requirements into KPIs, dashboards, and insights.
• Develop SQL-based datasets and automated reporting processes.
• Build and support Power BI, Power Apps, and Power Automate solutions.
• Ensure data quality, governance, and reconciliation controls.
• Conduct trend analysis and root-cause investigations for decisions.

Skills

SQL

Power BI

Excel

Data analytics

Stakeholder mgmt

Education

Bachelor's degree in Data Analytics/IS/CS

Tools

Power Apps

Power Automate

Data modeling

Job description

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

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.

What you’ll be doing

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 solutionsStrong 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

What we offer

You bring your skills and experience to Shell, and in return you work with talented, committed people in an innovative work environment. You’ll have the opportunity to develop the skills you need to grow in an environment where we value honesty, integrity, and respect for one another. You’ll be able to balance your priorities as you become the best version of yourself.

• Progress as a person as we work on the energy transition together
• Continuously grow the transferable skills you need to get ahead
• Work at the forefront of technology, trends, and practices
• Collaborate with experienced colleagues with unique expertise
• Achieve your balance in a values-led culture that encourages you to be the best version of yourself
• Benefit from flexible working hours, and the possibility of remote/mobile working
• Perform at your best with a competitive starting salary and annual performance-related salary increase; our pay and benefits packages are among the best in the world
• Take advantage of paid parental leave, including for non-birthing parents
• Join an organization working to become one of the most diverse and inclusive in the world
• We strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientation, and life experiences to apply
• Grow as you progress through diverse career opportunities in national and international teams
• Gain access to a wide range of training and development programs

We’d like you to know that Shell has a bold goal: to become one of the world’s most diverse and inclusive companies. You can get to know more about how we’re working towards that goal, click here.

Shell in Canada

Shell Canada is part of a global group of energy and petrochemicals companies with an average of 92,000 employees in more than 70 countries and has been operating in Canada since 1911.

Shell Canada is one of the few truly integrated energy companies in Canada with all of Shell’s global businesses represented, including upstream, integrated gas, downstream, and renewables and energy solutions. That means we do everything from exploration, gas production, refining and manufacturing, to providing fuels and developing energy solutions for our customers.

At a glance, our businesses and projects in Canada include:

• Joint Venture Partner (40%) with LNG Canada which will export Canadian natural gas to Asian markets
• Shale gas and liquids assets in Alberta and British Columbia
• A network of 1,400 retail stations across Canada
• The Scotford Complex in Alberta includes an upgrader; chemicals plant and is home to the Quest carbon captureand storage facility
• The Sarnia Manufacturing Centre refinery in Ontario
• Investments in renewables and energy solutions, including EV charging, hydrogenand biofuels
• 12 Shell-owned distribution terminals, three of which have marine operations
• Shell Aviation Canada delivers across a network of 26 airport fixed-based operations and airport consortiums, from coast to coast. Shell Aviation provides 1.7 billion liters of high-quality fuel annually in Canada and offers reliable and safe into-plane delivery
• Strong Sulphur and Lubricants businesses as well as an innovative Supply and Trading business

DISCLAIMER

Please note: We occasionally amend or withdraw Shell jobs and reserve the right to do so at any time, including prior to the advertised closing date. Before applying, you are advised to read our data protection policy. This policy describes the processing that may be associated with your personal data and informs you that your personal data may be transferred to Shell/Shell Group companies around the world. The Shell Group and its approved recruitment consultants will never ask you for a fee to process or consider your application for a career with Shell. Anyone who demands such a fee is not an authorised Shell representative and you are strongly advised to refuse any such demand. Shell is an Equal Opportunity Employer.-À NOTER: de temps à autre, il arrive que nous modifions ou que nous retirions des emplois chez Shell et nous nous réservons le droit de le faire à tout moment, y compris avant la date limite indiquée. Avant de candidater, il vous est conseillé de bien lire notre politique en matière de protection des données. Celle-ci décrit comment vos données personnelles peuvent être traitées et vous informe que vos données personnelles peuvent être transférées à Shell/ aux sociétés du groupe Shell dans le monde entier. Ni le groupe Shell, ni aucune de ses sociétés de conseil en recrutement agréées ne sauraient vous demander de payer des droits pour examiner votre candidature à une carrière chez Shell. Quiconque vous demande un tel paiement n’est pas un représentant agréé de Shell et il vous est fortement conseillé de refuser d’effectuer un tel paiement. Shell respecte l’égalité d’accès à l’emploi