Senior Data Analyst
Role details
Job location
Tech stack
Job description
Every prescription CenterWell Pharmacy fills depends on a chain of people being in the right place at the right time. The Workforce Planning team makes sure that capacity exists before the demand arrives. The team conducts long-term forecasts that impact hiring, mid-term capacity plans that shape staffing strategy, and short-term plans that hold service levels week to week.
If you have done demand planning or S&OP for a physical supply chain, this is the same discipline - our constrained resource is licensed, trained people instead of inventory., You would own how planning data reaches the people who use it - the pipelines that consolidate workforce, volume, and operational data across platforms, and the models our forecasting tools run on. You have built ETL/ELT pipelines in a cloud data environment (Azure, Snowflake, Databricks, or similar), work fluently in Python, and know dimensional modeling and data warehouse design.
Requirements
You would own how planning insight turns into decisions - the dashboards and self-service tools operations leaders run their business on, and the KPI definitions underneath them. You have advanced Power BI skills (or Tableau/Looker and willingness to switch), have built KPI frameworks from scratch, and can decompose a metric to root cause rather than reporting variance.