Advanced Analytics Specialist II

Advanced Analytics Specialist II

What you'll do at

Position Summary...

What you'll do...

The Walmart eCommerce team is rapidly innovating to evolve and define the future state of shopping. As the world's largest retailer, we are on a mission to help people save money and live better. With the help of some of the brightest minds in technology, merchandising, marketing, supply chain, talent and more, we are reimagining the intersection of digital and physical shopping to help achieve that mission. 


The Advanced Analytics Specialist II will support Network Planning and Inventory Optimization for the eCommerce business. S/he will support designing the flow of domestic and import inventory for optimized replenishment. This role is part of the Walmart eCommerce Supply Chain Planning & Advanced Analytics team, a future-focused, action-biased, data-driven team chartered with defining the next generation inventory network by leveraging advanced analytics. This is a high-impact and high-visibility role within the organization with expectations to deliver immediate results. The complexity of this role requires well beyond basic data analysis and research. It involves complex analytics, building robust and scalable databases, configure business impacting systems, and the ability to automate processes and reports. 

The Advanced Analytics Specialist II is responsible for helping build our best-in-class Supply Chain Analytics. The ideal candidate has a demonstrated passion for working with data to creatively and tenaciously solve complex problems. Your ultimate goal is use data to drive the right business outcomes and build strong relationships with the Technology, Merchandising, and Supply Chain Operations teams you partner with. 

What you’ll be working on (Job Duties) 

Modeling (30%): 

  • Develop and improve upon our methodology for managing inventory, replenishment, forecasting, S&OP and end to end supply chain using big-data (SQL, Google Big Query, HIVE, Teradata, KNIME) and statistical modeling tools (R, Python) to plan and optimize the Supply Chain to improve key inventory drivers. 

  • Build and manage parts of algorithmic products/models. Ensures segment aligns with overall product goals. Develop mathematical models to build data-driven decision-making systems for inventory optimization and allocation, improving the Supply Chain performance. 

  • Build advanced statistical models to determine optimal key business parameters, such as ordering cadence, service level and desired safety stock for an item. Apply machine learning algorithms to improve demand forecast accuracy.  

  • Apply decision tree models, coupled with machine learning models and incorporating business insights, to improve accuracy of Forecasting Product demand in supply chain. Create supervised and unsupervised learning models to forecast demand for product that are completely new to  

  • Accurately capture defects within Forecasting and Operations to understand correlations using statistical inference to drive key enterprise metrics. Develops data models (algorithms, approaches) for workstreams and individual projects within a business area to drive business results and value. Execute on exploratory and scenario analysis to shape future products. Collaborates with project team to implement modeling solutions. 



Analytics (30%): 

  • Solve and formulate multi-objective integer/linear programming optimization problems to improve key performance metrics and drive down cost across Walmart’s supply chain.  

  • Provide insightful analysis and make recommendations to management regarding cost savings and/or profitability improvement strategies; Work with operational management to identify areas of improvement and perform other special duties & projects.   

  • Improve and automate replenishment ordering model by analyzing several key inputs across the supply chain. Consolidate big data sets with millions of records, determine the optimal inventory order quantity to balance customer experience and company’s operating costs. 

  • Analyze complex data in Teradata, Hive & Hadoop to identify patterns, detect anomalies in inbound vendor performance data using statistical tools and provide recommendations on fixes to the Engineering Team. Use big data languages such as Hive and Spark to query business data and reorganize them into usable formats for analytics use. 

  • Use SQL and Excel to build automated ordering processes which include collecting inventory and sales data, analyzing future demand and calculating final order quantity using statistical formulas 

  • Analyze large quantities of data such as inventory, transportation and fulfillment data to help the Supply Chain team and other parts of the organization make decisions that drive value.   

  • Design important business metrics, use Looker and Tableau to build data visualization dashboards and custom business intelligence reports.  

  • Conduct Ad-hoc analysis per requests from senior management. 

Data Collection & Reporting (25%): 

  • Address complex business problems by working with large, messy, disparate datasets and conduct analyses to quickly inform critical business decisions. Develop metrics to monitor and quantify the impact of changes. In-depth investigation of key drivers.  

  • Generate insights for supply chain optimization utilizing SQL (with data manipulation through Python and R) and create business critical dashboards in Tableau, targeted at driving improved experience for customers. 

  • Develop data visualization and reports for key metrics in Supply Chain inventory management: Item In-stock, Inventory Turns, Purchase Order Visibility, Forecasts, etc. These reports help executive leadership to track business performance and drives process improvement initiatives.

  • Design and build scalable data pipelines across data warehouses (PostgreSQL, Teradata, Hive, etc.) using SQL to efficiently maintain years of historical data and allow analysts to easily access the data for analyses and modeling. Create data tables using Structured Query Language (SQL) in Teradata or Google Cloud Server to collect inbound transaction data to measure Forecast Accuracy. 

  • Automate and manage reporting/analysis. Optimize complex analysis by building dashboards in Tableau for visualizing status quo and trends of vendor performance for both internal and external stakeholders. 

Collaboration (15%): 

  • Collaborate with cross functional teams to apply established and new analytical processes on diverse data sets to deduce insights and solve business/operational problems. 

  • Implement new or improved supply chain processes to improve efficiency or performance.  

  • Develop procedures for coordination of supply chain management with other functional areas, such as sales, marketing, finance, production, or quality assurance.  

  • Confer with supply chain planners to forecast demand or create supply plans that ensure availability of materials or products.  

  • Analyze inventories to determine how to increase inventory turns, reduce waste, or optimize customer service. Analyze information about supplier performance or procurement program success. 

  • Provide supervision and development opportunities for associates. 

  • Coach team members and provides feedback to enhance skills, knowledge and work performance. Mentors and supports training for less experienced associates. 

  • Model compliance with company policies and procedures and supports company mission, values, and standards of ethics and integrity byincorporating these into the development and implementation of business plans; using the Open Door Policy; and demonstrating and assisting otherswith how to apply these in executing business processes and practices. 


Ideal Candidate would: 

  • Have experience programming in R or Python Google Big Query, and SQL. 

  • Have experience working with large datasets, finding insights, and telling stories using data 

  • Can effectively communicate through data using clear and concise summary 

  • Is a self-starter who can work with minimum supervision 

  • Optimization experience is a plus 

  • Knowledge of supply chain, inventory management is a plus 

  • Prior experience in retail and ecommerce is a plus 

  • Positive can do attitude and curiosity to learn 

Required Qualifications:   

  • Expert at SQL and Excel - ability to manipulate large quantities of data to drive business decisions is a must 

  • Strong business acumen and scrappiness - you approach problems in a scientific manner but can also execute pragmatically 

  • Excellent analytical, organizational, and written/verbal communication skills 

  • Hands-on experience with VBA, R, Python, Google Big Query, Looker, Tableau, KNIME, SAS, MATLAB or other data analysis/visualization tools 

  • Structured and organized thinker who can drive analytical projects to completion with minimal direction; intense analytical ability, attention to detail and ability to deep-dive when necessary 

Benefits & Perks:   

Beyond competitive pay, you can receive incentive awards for your performance. Other great perks include 401(k) match, stock purchase plan, paid maternity and parental leave, PTO, multiple health plans, and much more.   

Equal Opportunity Employer:   

Walmart, Inc. is an Equal Opportunity Employer – By Choice. We believe we are best equipped to help our associates, customers and the communities we serve live better when we really know them. That means understanding, respecting and valuing diversity- unique styles, experiences, identities, ideas and opinions – while being inclusive of all people.   


Who We Are: 

Join Walmart and your work could help over 275 million global customers live better every week. Yes, we are the Fortune #1 company. But you’ll quickly find we’re a company who wants you to feel comfortable bringing your whole self to work. A career at Walmart is where the world’s most complex challenges meet a kinder way of life. Our mission spreads far beyond the walls of our stores. Join us and you'll discover why we are a world leader in diversity and inclusion, sustainability, and community involvement.  From day one, you’ll be empowered and equipped to do the best work of your life. 

Minimum Qualifications...

Outlined below are the required minimum qualifications for this position. If none are listed, there are no minimum qualifications.

Bachelor’s degree in Business, Finance, Accounting, Statistics, or related field OR 2 years' experience in data analytics or related field.

Preferred Qualifications...

Outlined below are the optional preferred qualifications for this position. If none are listed, there are no preferred qualifications.

Analytics in retail operations, Retail math (for example, calculate margin, inventory turn, average price)

Primary Location...

950 ELM AVE, SAN BRUNO, CA 94066-3047, United States of America

About Walmart

At Walmart, we help people save money so they can live better. This mission serves as the foundation for every decision we make, from responsible sourcing to sustainability—and everything in between. As a Walmart associate, you will play an integral role in shaping the future of retail, tech, merchandising, finance and hundreds of other industries—all while affecting the lives of millions of customers all over the world. Here, your work makes an impact every day. What are you waiting for?

Walmart, Inc. is an Equal Opportunity Employer – By Choice. We believe we are best equipped to help our associates, customers and the communities we serve live better when we really know them. That means understanding, respecting and valuing diversity – unique styles, experiences, identities, ideas and opinions – while being inclusive of all people.
Merchandising Internship at Walmart
"At Walmart, you have the support you need at any given moment no matter the circumstance."
— Shelby, Project Analyst

Hello, Silicon Valley

You don’t have to choose between your career and your lifestyle. In Silicon Valley, you can have both.

Discover Silicon Valley
Silicon Valley
View of Silicon Valley from the hills after a passing storm

All the benefits you need for you and your family

  • Multiple health plan options, including vision & dental plans for you & dependents
  • Financial benefits including 401(k), stock purchase plans, life insurance and more
  • Associate discounts in-store and online
  • Education assistance for Associate and dependents
  • Parental Leave
  • Pay during military service
  • Paid Time off - to include vacation, sick, parental
  • Short-term and long-term disability for when you can't work because of injury, illness, or childbirth

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific plan or program terms. For information about benefits and eligibility, see

Recently viewed jobs