Senior Inventory Analyst (Pharmacy)

CVS Health•Woonsocket, RI

4d•$46,988 - $112,200

About The Position

A Senior Inventory Analyst on CVS Health’s Pharmacy Inventory Management Store Planning team supports inventory operations across approximately 8,900 retail pharmacy locations. The team works to improve the efficiency of approximately $6 billion in standing inventory and manage daily business changes while ensuring pharmacies have appropriate inventory to meet projected sales plans and customer service goals. Replenishment of pharmaceutical products to stores is sourced from CVS warehouses and outside vendors. The role supports essential-item supply, demand and allocation management, business and process change recommendations, inventory-efficiency opportunity identification, and supply-chain and logistics partners. The analyst helps maintain service to pharmacies and patients while supporting financial efficiency and new business opportunities. The position is part of the Pharmacy Inventory Management team and reports to the Senior Manager of Inventory Supply Analytics.

Requirements

At least 2 years of experience in supply chain, inventory management, or merchandising.
At least 2 years of experience in data analytics or statistical analysis using SQL, Snowflake, Python, or a similar data manipulation language.
At least 2 years of advanced MS Excel experience.
At least 1 year of experience working with inventory metrics and understanding how those metrics influence one another.
At least 1 year of experience building inventory and replenishment models, simulation algorithms, or what-if tools incorporating multiple variables to estimate downstream impacts of business changes.
Bachelor’s degree in supply chain management, business management, or a related field, or equivalent years of experience.

Nice To Haves

Retail or healthcare industry knowledge, including pharmacy products and pharmacy operational processes.
Experience working with multiple data warehousing environments, preferably Snowflake and GCP.
Knowledge of one or more data-wrangling and ETL tools.
Experience writing and relaying detailed business requirements for IT updates or builds.
Knowledge of inventory allocation methodologies and ladder plans for managing seasonal products.
Experience working with CVS retail systems, such as CFRx and RxConnect.
Experience creating visualizations that clearly convey meaningful insights.
Experience with Python, R, or similar analytical tools or languages.
BA/BS in Supply Chain Management, Business Management, Finance, Accounting, or Information Systems.

Responsibilities

Resolve data-driven actions using relevant information to support business changes, including product sourcing changes, supply constraints, insurance plan changes, seasonality, and new product introductions.
Build models using Excel, SQL, Snowflake, and Python to highlight the impact of business changes and oversee mitigation efforts.
Take corrective actions related to defined service-level gaps.
Identify opportunities to invest in or deleverage store-level inventory in pursuit of inventory-efficiency and service-optimization targets.
Analyze opportunities and take corrective actions by store type, time of year, and product type.
Use in-store and central databases to perform ad hoc analysis and fulfill partner requests.