📍 Job Overview

• Job Title: Client Capacity Planning Advisor, Long Range Forecasting - Evernorth - Remote
• Company: Cigna Healthcare
• Location: Chattanooga, TN, United States (Remote)
• Job Type: Full-Time
• Category: Workforce Planning & Analytics
• Date Posted: 2025-08-01
• Experience Level: 5-10 years
• Remote Status: Hybrid (3 days on-site per week for certain locations)

🚀 Role Summary

• Strategic Capacity Analysis & Forecasting: Lead the development and refinement of capacity forecasting models for back-office operational teams, focusing on Underwriting and Pre-sale. Analyze key metrics such as receipts, inventory, membership, attainment, barrier time, productivity, at work/on prod, attrition, volume mix, and on-shore vs. off-shore staffing requirements.
• Data Visualization & Reporting: Design, develop, and deliver high-impact data visualizations and reports to communicate complex workforce insights, performance trends, and strategic recommendations to diverse audiences, including senior leadership and matrix partners.
• Strategic Advisory & Recommendations: Collaborate closely with business partners on a monthly basis to review analytical results, provide strategic direction on optimal staff leverage, present forecasted outcomes, and offer data-driven recommendations on new hire needs, conversion skill requirements, and up-training initiatives.
• Operational Optimization: Apply solution-based strategic thinking to identify opportunities for operational efficiency, enabling the business to operate as lean as possible without compromising quality or risking key metric results.

📝 Enhancement Note: This role requires a strong analytical mindset, exceptional communication skills, and the ability to influence stakeholders at various levels within the organization. The ideal candidate will have a proven track record in workforce management, financial planning, or supply chain analytics and be comfortable working in a dynamic, matrix-driven environment.

💻 Primary Responsibilities

• Capacity Planning & Forecasting:

  • Develop and maintain capacity forecasting models for Underwriting and Pre-sale teams.
  • Analyze key metrics to identify trends and make data-driven recommendations.
  • Create "what-if" scenarios to illustrate the impacts of various assumptions on inventory and operational outcomes.

• Data Visualization & Reporting:

  • Design and develop interactive dashboards using tools such as Tableau or Power BI.
  • Create clear and concise reports to communicate complex data insights to stakeholders.

• Strategic Advisory & Recommendations:

  • Collaborate with business partners to review analytical results and provide strategic direction.
  • Present forecasted outcomes and offer data-driven recommendations on staffing needs and skill requirements.

• Operational Optimization:

  • Identify opportunities for operational efficiency and implement solutions to improve resource utilization.
  • Monitor and publish results against plans, proactively identify performance gaps, and lead remediation strategies with operations.

• Stakeholder Partnership & Communication:

  • Manage and cultivate strong relationships with key stakeholders across the WFM organization and external business units.
  • Clearly communicate inventory hot spots, bottlenecks, and proposed remediation plans to leadership.

• Continuous Improvement:

  • Actively participate in recurring team meetings and 1x1s, contributing to ongoing process enhancements and knowledge sharing.

🎓 Skills & Qualifications

Education: Bachelor’s degree in Business, Finance, Economics, Supply Chain, Data Science, or a related field is preferred.

Experience: 5+ years of relevant work experience in workforce management, financial/budget planning, or supply chain analytics.

Required Skills:

• Advanced proficiency in MS Excel (complex formulas, pivot tables, VBA/macros).
• Demonstrated experience with data visualization tools (Tableau, Power BI, Looker).
• Experience with database querying and understanding of data warehousing concepts (SQL).
• Strong analytical and problem-solving skills.
• Exceptional communication skills (written, oral, and listening).
• Proactive mindset with a strong sense of urgency and acute attention to detail.

Preferred Skills:

• Knowledge of Alteryx or Python.
• Operational knowledge of the underwriting or pre-sale process.

📊 Web Portfolio & Project Requirements (N/A - not applicable for this role)

💵 Compensation & Benefits

Salary Range: $76,500 - $127,500 USD per year, depending on relevant factors, including experience and geographic location.

Benefits:

• Medical, vision, and dental insurance.
• Well-being and behavioral health programs.
• 401(k) with company match.
• Company-paid life insurance.
• Tuition reimbursement.
• Minimum of 18 days of paid time off per year and paid holidays.

🎯 Team & Company Context

Company Culture:

• Industry: Healthcare and Insurance.
• Company Size: Large (over 10,000 employees).
• Founded: 1981 (as Cigna Corporation).

Team Structure:

• The Client Capacity Planning Advisor role is part of the Workforce Management (WFM) organization, working closely with Underwriting and Pre-sale teams.
• This role reports directly to the Manager, Capacity Planning & Forecasting.

Development Methodology:

• The team follows an Agile/Scrum methodology, with regular team meetings and 1x1s to foster continuous improvement and knowledge sharing.

Company Website: Cigna Group

📝 Enhancement Note: Cigna Healthcare is a global health service company dedicated to improving the health, well-being, and peace of mind of those it serves. The company offers a wide range of employee benefits, focusing on supporting the whole health of its workforce.

📈 Career & Growth Analysis

Web Technology Career Level: This role is a mid-level position within the Workforce Planning & Analytics career path, focusing on strategic capacity planning and data-driven decision-making.

Reporting Structure: The Client Capacity Planning Advisor reports directly to the Manager, Capacity Planning & Forecasting, and collaborates closely with Underwriting and Pre-sale teams.

Technical Impact: This role has a significant impact on operational efficiency, resource allocation, and service level agreements (SLAs) across Underwriting and Pre-sale teams.

Growth Opportunities:

• Career Progression: With experience and strong performance, there may be opportunities to advance to a senior capacity planning role or transition into a related field such as workforce analytics or operational management.
• Technical Skill Development: The role offers opportunities to enhance skills in data visualization, advanced analytics, and strategic planning.
• Leadership Potential: As the role involves influencing stakeholders at various levels, it provides opportunities to develop leadership skills and gain exposure to senior management.

🌐 Work Environment

Office Type: Hybrid (3 days on-site per week for certain locations).

Office Location(s): Bloomfield, CT; Chattanooga, TN; Denver, CO; St. Louis, MO; Scottsdale, AZ.

Workspace Context:

• The Client Capacity Planning Advisor works in a collaborative, matrix-driven environment, interacting with various teams across Underwriting, Pre-sale, and Workforce Management.
• The role requires a dedicated workspace with a reliable internet connection (at least 10Mbps download/5Mbps upload) for remote work.

Work Schedule: Full-time, with a flexible schedule to accommodate project deadlines and maintenance windows.

📝 Enhancement Note: The hybrid work arrangement allows for flexibility and a better work-life balance, while maintaining the ability to collaborate effectively with on-site teams when needed.

📄 Application & Technical Interview Process

Interview Process:

1. Phone/Screen: A brief phone or video call to assess communication skills and cultural fit.
2. Data Analysis Challenge: A take-home data analysis challenge to evaluate analytical skills and problem-solving abilities.
3. On-site/Video Interview: A comprehensive on-site or video interview, including behavioral questions, case studies, and discussions on strategic capacity planning and data visualization.

Portfolio Review Tips: (N/A - not applicable for this role)

Technical Challenge Preparation:

• Brush up on Excel skills, focusing on complex formulas, pivot tables, and VBA/macros.
• Familiarize yourself with data visualization tools such as Tableau or Power BI.
• Review your understanding of SQL and data warehousing concepts.
• Prepare for behavioral questions related to strategic planning, stakeholder communication, and operational optimization.

ATS Keywords: (N/A - not applicable for this role)

🛠 Technology Stack & Web Infrastructure

Data Analysis & Visualization Tools:

• Microsoft Excel
• Tableau or Power BI
• SQL
• Alteryx or Python (optional)

Workforce Management Platforms:

• Cigna's proprietary workforce management platform
• Third-party tools and integrations (e.g., Kronos, Workday)

📝 Enhancement Note: The technology stack for this role is focused on data analysis, visualization, and workforce management. Familiarity with Cigna's proprietary platform and relevant third-party tools is beneficial but not always required.

👥 Team Culture & Values

Workforce Planning & Analytics Values:

• Data-driven decision-making.
• Strategic planning and execution.
• Continuous improvement and innovation.
• Collaboration and stakeholder management.
• Operational excellence and efficiency.

Collaboration Style:

• Cross-functional collaboration between Workforce Planning & Analytics, Underwriting, Pre-sale, and other business units.
• Regular team meetings and 1x1s to foster knowledge sharing and continuous improvement.
• A culture of open communication, active listening, and constructive feedback.

📝 Enhancement Note: The team culture at Cigna Healthcare values data-driven insights, strategic planning, and collaborative problem-solving. The ideal candidate will thrive in a dynamic, matrix-driven environment and be comfortable working with diverse stakeholders.

⚡ Challenges & Growth Opportunities

Technical Challenges:

• Developing and maintaining complex capacity forecasting models for multiple teams and business units.
• Identifying trends and making data-driven recommendations in a dynamic and ever-changing business environment.
• Communicating complex data insights and strategic recommendations to diverse stakeholders, including senior leadership.

Learning & Development Opportunities:

• Enhancing skills in data visualization, advanced analytics, and strategic planning.
• Gaining exposure to senior management and developing leadership skills.
• Collaborating with cross-functional teams to drive operational efficiency and improve service level agreements.

📝 Enhancement Note: The Client Capacity Planning Advisor role presents unique challenges and growth opportunities, focusing on strategic capacity planning, data-driven decision-making, and operational optimization. The ideal candidate will be eager to tackle complex problems and continuously learn and adapt in a dynamic business environment.

💡 Interview Preparation

Technical Questions:

1. Data Analysis & Visualization: Prepare for questions related to Excel, data visualization tools, SQL, and data warehousing concepts. Be ready to discuss your approach to complex data analysis and presenting insights to stakeholders.
2. Strategic Planning: Brush up on your understanding of capacity planning, forecasting, and operational optimization. Prepare for questions that assess your ability to think strategically and make data-driven recommendations.
3. Stakeholder Management: Familiarize yourself with best practices for communicating with diverse stakeholders, including senior leadership. Prepare for questions that evaluate your ability to influence and collaborate effectively with various teams.

Company & Culture Questions:

• Research Cigna Healthcare's mission, values, and recent initiatives to demonstrate your understanding of the organization's culture and commitment to improving the health and well-being of its customers.
• Prepare for questions that assess your fit with the company's culture and your ability to contribute to its ongoing success.

Portfolio Presentation Strategy: (N/A - not applicable for this role)

📝 Enhancement Note: To succeed in the interview process, candidates should focus on demonstrating their analytical skills, strategic thinking, and ability to communicate complex data insights effectively. Familiarize yourself with Cigna Healthcare's mission, values, and recent initiatives to showcase your understanding of the organization's culture and commitment to improving the health and well-being of its customers.

📌 Application Steps

To apply for the Client Capacity Planning Advisor, Long Range Forecasting - Evernorth - Remote position:

1. Submit your application through the application link provided.
2. Tailor your resume and cover letter to highlight your relevant experience in workforce management, data analysis, and strategic planning.
3. Prepare for the phone or video screen by reviewing common behavioral and technical interview questions related to data analysis, strategic planning, and stakeholder communication.
4. Research Cigna Healthcare's mission, values, and recent initiatives to demonstrate your understanding of the organization's culture and commitment to improving the health and well-being of its customers.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.