Inventory Optimization Advisor

Role overview

Analytics and technology responsibilities

• Design and maintain reporting, analytics, business intelligence solutions, SQL datasets, data models, and automated reporting.
• Build and support Power BI, Power Apps, and Power Automate solutions; maintain accuracy, data quality, governance, and reconciliation controls.
• Lead technology initiatives, define requirements, evaluate solutions, support implementation, and act as a business subject matter expert.
• Develop business cases, testing strategies, performance measures, and value-realization plans; monitor adoption and benefits.
• Analyze trends, root causes, exceptions, inventory performance, shrink, availability, turnover, and ordering effectiveness.
• Recommend inventory improvements and support governance, controllership, continuous improvement, procedures, policies, SOPs, and training.
• Lead cross-functional initiatives, communicate insights, influence decisions, build partnerships, and mentor colleagues.

Candidate requirements

• 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, including Power Query, Power Pivot, and VBA/macros.
• Experience with Power Apps, Power Automate, automated reporting, 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 performance management, inventory controls, and operational reporting.
• Experience leading analytics, digital transformation, or continuous improvement initiatives; able to translate business requirements into reporting and system solutions.
• Strong stakeholder, project, and change management skills.
• Must have legal authorization to work in Canada on a full-time basis.

Benefits and work environment

• Shell describes opportunities for professional development, transferable skills, and working with experienced colleagues.
• Flexible working hours and the possibility of remote or mobile working are offered; this does not specify the role's workplace arrangement.
• The posting mentions competitive starting salary, annual performance-related salary increases, paid parental leave, and training and development programs.

Application process

• After applying, candidates must complete a mandatory online assessment within 3 days of receiving the assessment invitation.

About Shell Canada