Inventory Optimization Advisor

Shell; Calgary; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Flexible working hours

Remote/mobile working

Competitive starting salary

Annual performance-related salary rise

Paid parental leave

Training and development programs

Diversity and inclusion

Job summary

Shell Canada in Calgary is seeking an Inventory Optimization Advisor to drive inventory performance through analytics, reporting, and digital tools. You will design dashboards, optimize data models, and partner with stakeholders across Mobility, IT, and operations to deliver actionable insights and value realization.

We value strong SQL, Power BI, and Excel skills, plus experience with Power Apps and Power Automate.

Qualifications

• Bachelor's degree in data analytics, information systems, computer science, or related discipline.
• 4+ years of experience in data analytics, reporting, or business intelligence.
• Advanced SQL, Power BI, and Excel skills.
• 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.
• Ability to translate business requirements into reporting and system solutions.

Responsibilities

• 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.
• Lead analytics, digital transformation, or continuous improvement initiatives.
• Define operational procedures and training guidelines for retailers and operations.

Skills

SQL

Power BI

Excel

Power Apps

Power Automate

Data modeling

Data governance

Stakeholder management

Analytics

Education

Bachelor's degree in Data Analytics / Information Systems / Computer Science

Tools

Power Query

Power Pivot

VBA/macros

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

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, and we strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientations, and life experiences to apply.

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 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 capture and storage facility
• The Sarnia Manufacturing Centre refinery in Ontario
• Investments in renewables and energy solutions, including EV charging, hydrogen and 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 litersof 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. 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.

Shell respects the equal opportunity employer.

Shell is a global group of energy and petrochemical companies, employing 96,000 people across more than 70 countries. Whether they work on our platforms and pipelines, or in our offices and research labs, people are key to our success. They collectively determine our culture and we expect them to behave according to our values: honesty, integrity, and respect for people. Learn more about our purpose and strategy.

If you need any assistance or support while applying for a job, please contact us at [e-mail].