Senior Inventory Analyst (Pharmacy)

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. A Brief Overview A Senior Inventory Analyst on the Pharmacy Inventory Management Store Planning team plays a key role in supporting our enterprise, with a primary focus on optimizing inventory operations across approximately 8,900 retail pharmacy locations. The team provides value by improving the efficiency of our standing inventory (~$6B) and running the changes in our daily business, while supporting our pharmacies with the appropriate inventory to meet our projected sales plans and our customer service goals. The team runs the replenishment of pharmaceutical products to stores, sourced from CVS warehouses as well as Outside Vendors.  To run our pharmacy inventory and replenishment strategies, the team has many responsibilities, and you will support the team across activities such as essential item supply, demand and allocation management, business and process change recommendations, inventory efficiency opportunity identification, and supporting our supply chain/logistics partners. You will help continue to provide excellent service to our pharmacies and patients while ensuring financial efficiencies and supporting new business opportunities. You will be a part of the Pharmacy Inventory Management team and report to the Sr Manager of Inventory Supply Analytics.  What you will do • Resolve data-driven action based on relevant information to support business changes; product sourcing changes, supply constraints, insurance plan changes, seasonality, new product introductions. • Build models (Excel, SQL, Snowflake, Python) that help highlight impact of business changes and oversee the efficiency of mitigation efforts and take corrective actions related to defined service level gaps. • Help identify opportunities to invest/deleverage inventory at the store level in pursuit of both inventory efficiency and service optimization targets. • Analyze and take corrective actions related to defined service level gaps. • Use analysis to evaluate and improve opportunities by store type, time of year and product type • Use in-store and central databases to perform ad-hoc analysis and fulfill requests from partners. Required Qualifications • Minimum 2 years of experience of Supply Chain, Inventory Management or Merchandising • Minimum 2 years of experience of Data Analytics or Statistical Analysis utilizing SQL, Snowflake, Python or similar data manipulation language • Minimum 2 years of experience advanced MS Excel • Minimum 1 year of experience working with Inventory metrics and how those metrics influence each other • Minimum 1 year of experience building inventory and replenishment models, simulation algorithms or what-if tools, incorporating multiple variables, for use in estimating downstream impacts of various business changes. Preferred Qualifications • Retail or healthcare industry knowledge and Pharmacy products and pharmacy operational processes • Experience working with multiple data warehousing environments, preferably Snowflake & GCP. • Knowledge of one or more tools for Data Wrangling and ETL • Experience in Writing/relaying detailed business requirements for IT updates/builds • Knowledge of Inventory allocation methodologies & ladder plans to effectively manage seasonal products • Experience working with CVS retail systems, such as CFRx and RxConnect • Experience creatin