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 One.Walmart.com/Benefits.
Advanced Analytics Specialist II
- Location SAN BRUNO, CA
- Career Area Data Analytics and Business Intelligence
- Job Function -
- Employment Type Regular/Permanent
- Position Type Salary
- Requisition WD769899
What you'll do at
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)
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 Walmart.com supply chain. Create supervised and unsupervised learning models to forecast demand for product that are completely new to Walmart.com.
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.
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.
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 by incorporating these into the development and implementation of business plans; using the Open Door Policy; and demonstrating and assisting others with 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
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. careers.walmart.com
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.
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
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.
"At Walmart, you have the support you need at any given moment no matter the circumstance."
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
Fioli Gardens, Woodside
View an art exhibit, take a nature hike, explore the historic Filoli House, or take a class at this gorgeous 654–acre property.
Get your art fix at this internationally recognized collection of over 30,000 works of modern and contemporary art.
Computer History Museum
Large-scale exhibits, an acclaimed speaker series, docent-led tours and an award-winning education program bring computer history to life.
Hike or jog throughout the year on terrain dedicated to academic programs, environmental restoration and habitat conservation.
Golden Gate Park, SF
Events, attractions, meadows, lakes, and a Japanese Tea Garden provide for a true escape, without leaving the city.
The Tech Museum
This family-friendly interactive science and technology center in San Jose provides a glimpse into the most inventive place on Earth — Silicon Valley.
Santana Row - San Jose
Stylish boutiques, world-class shopping, and delectable cuisine = a San Jose shopping trifecta.
Pacifica State Beach
Learn to surf or visit the “World’s Most Scenic Taco Bell” at this 0.75 mile long crescent shaped escape, a symbol of successful habitat restoration.
Golden Gate Cemetery
This national cemetery comprises 161 acres dedicated to all the members of the armed forces who served our country.
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