Senior Data Analyst

SENIOR DATA ANALYST - WORKFORCE PLANNING CenterWell Pharmacy, a Humana company ABOUT THE ROLE 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. We are building this function from the ground up. The architecture, the metrics, and the tooling are not decided yet, and we are hiring two Senior Data Analysts to help decide them. WHAT YOU WILL DO Turn messy, multi-source operational data into planning inputs the business can act on Partner with operations, finance, and department leaders to understand what they actually need to decide Build the tooling and data products that let planners and leaders answer their own questions Bring rigor to how we measure ourselves - forecast accuracy, capacity use, cost per prescription, and the drivers underneath them TWO WAYS IN Every analyst here shares the work above. Beyond it, you will anchor in one of two focus areas. Focus Area 1 - Data Engineering & Architecture 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. Focus Area 2 - Business Intelligence & Analytics 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. You do not need to be strong in both. We would rather have two people who are excellent at one than two who are adequate at everything. Tell us in your application which one is yours. Use your skills to make an impact Required Qualifications 5 or more years of experience in analytics, data engineering, business intelligence, or a planning and forecasting function Advanced SQL skills - you can write, tune, and debug complex queries against large operational datasets Experience turning data into something a business partner actually used to make a decision Experience explaining a technical result to a non-technical audience Bachelor's degree in a quantitative, technical, or business discipline Preferred Qualifications Workforce planning, workforce management, or capacity planning experience to include - forecasting, scheduling, shrinkage, or occupancy Prior experience in supply chain planning, demand planning, or S&OP in a distribution, fulfillment, manufacturing, or logistics environment Healthcare, pharmacy, or other regulated-industry experience Additional Information Work Style: Remote Work at Home/Remote Requirements At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is recommended; wireless, wired cable or DSL connection is suggested Satellite, cellular and microwave connection can be used only if approved by leadership Associates who live and work from Home in the state of California, Illinois, Montana, or South Dakota will be provided a bi-weekly payment for their internet expense Humana will provide Home or Hybrid Home/Office associates with telephone and computer equipment appropriate to meet the business requirements for their position/job Work from a dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information HireVue Statement As part of our hiring process for this opportunity, we will be using an exciting interviewing technology called HireVue to enhance our hiring and decision-making ability. HireVue allows us to quickly connect and gain valuable information from you pertaining to your relevant skills and experience at a time that is best for your schedule. Travel While this is a remote position, occasional travel to Humana's offices for training or meetings may be required. Scheduled Weekly Hours 40 Pay Range The compensation range below reflects a good faith estimate of starting base pay for full time (40 hours per week) employment at the time of posting. The pay range may be higher or lower based on geographic location and individual pay will vary based on demonstrated job related skills, knowledge, experience, education, certifications, etc. $73,400 - $100,100 per year This job is eligible for a bonus incentive plan. This incentive opportunity is based upon company and/or individual performance. Description of Benefits Humana, Inc. and its affiliated subsidiaries (collectively, "Humana") offers competitive benefits that support whole-person well-being. Associate benefits are designed to encourage personal wellness and smart healthcare decisions for you and your family while also knowing your life extends outside of work. Among our benefits, Humana provides medical, dental and vision benefits, 401(k) retirement savings plan, time off (including paid time off, company and personal holidays, paid parental and caregiver leave), short-term and long-term disability, life insurance and many other opportunities. About us About CenterWell Pharmacy: CenterWell Pharmacy provides convenient, safe, reliable pharmacy services and is committed to excellence and quality. Through our home delivery and over-the-counter fulfillment services, specialty, and retail pharmacy locations, we provide customers simple, integrated solutions every time. We care for patients with chronic and complex illnesses, as well as offer personalized clinical and educational services to improve health outcomes and drive superior medication adherence. About CenterWell, a Humana company: CenterWell is a leading healthcare services business focused on creating integrated and differentiated experiences that put our patients at the center of everything we do. The result is high-quality healthcare that is accessible, comprehensive and, most of all, personalized. As the largest provider of senior-focused primary care, a leading provider of home healthcare and a leading integrated home delivery, specialty, hospice and retail pharmacy, CenterWell is focused on whole health and addressing the physical, emotional and social wellness of our patients. CenterWell is part of Humana Inc. (NYSE: HUM). Learn more about what we offer at CenterWell.com. Equal Opportunity Employer It is the policy of Humana not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status. It is also the policy of Humana to take affirmative action, in compliance with Section 503 of the Rehabilitation Act and VEVRAA, to employ and to advance in employment individuals with disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. #J-18808-Ljbffr Remote Jobs