Supply Chain Analytics Manager
The Supply Chain Analytics Manager will lead forecasting, planning and financial reporting for transportation partners, maintaining complex databases and developing budget and quarterly forecasts. The role collaborates with finance and transportation teams to deliver metric-driven insights that support network planning.
Skills required
About this role
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.
Position Summary
Supply Chain Analytics Manager is a member of the Network Planning team and has direct responsibilities supporting Transportation partners. This role will be responsible for creating and managing essential forecasting, planning, financial and metric reporting, maintain complex databases, and will work with the Transportation and Finance teams on the development of the yearly budget, quarterly forecasts, and monthly projection and close processes. In addition, as a member of the Network Planning team, they will support labor and other forecasting processes as necessary.
Responsibilities
• Manage and enhance key metric reporting such as P&L results, route, mileage, cost per mile, miles per route, product cube per route, pallets per route, fuel consumption and planning metrics to compare against actuals
• Monitor the monthly EIA change in fuel price vs the budgeted and forecasted fuel rates
• Calculate the cost impact on re-alignments and overrides and change in shipment plans
• Analyze, develop and maintain data queries linked to metric and financial reporting
• Support the Transportation team with various analyses for RFP’s and union negotiations
• Analyze transportation metrics to uncover, communicate, and solve for opportunities
• Provide weekly projections, monthly and quarterly P&L reporting for leadership team and DCs to review
• Develop the annual budget planning and forecast models
• Partner with the dedicated and private fleet teams in developing a bottoms up budget and incorporating the necessary initiatives and layers
• Identify and model budget shifts and variance explanations vs previous forecast
Required Qualifications
• 2+ years of analytical skills, quantitative skills, and problem-solving skills
• 2+ years of proficiency in Microsoft Office including Excel, Access, and PowerPoint
• 2+ years of experience constructing complex models to analyze financial and metric data
• 2+ years of experience working with large databases, SQL or other query tools
• 2+ years of experience working data visualization tools and report development
• 2+ years of relevant experience in finance, supply chain, or distribution
Preferred Qualifications
• SAP experience
• Power BI, ThoughtSpot, or Tableau data visualization experience
• SQL, Snowflake, data mining experience
• Build and maintain complex financial models
• Strong verbal and written communication skills across various audiences
• Ability to work independently, manage multiple tasks and prioritize responsibilities to meet critical deadlines
• Strong interpersonal skills with the ability to build strong relationships and contribute in a team setting
Education
Bachelor’s degree in Finance/Accounting, Business, Industrial Engineering, Operations Management or Supply Chain Management or equivalent work experience
Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:
$66,330.00 - $145,860.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.
Great benefits for great people
We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.
Additional details about available benefits are provided during the application process and on Benefits Moments.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.
