Enrollment & Forecasting Analyst or Senior

About the role

Join our Cause to create a person-focused and economically sustainable health care system. Candidates must reside within commutable distance of one of our Portland, Medford, Fargo, Burlington, Vancouver, Renton, Spokane, Boise, Lewiston or Salt Lake City offices.

Qualifications

• Bachelor's degree in mathematics, computer science, business administration or an equivalent related field and 3+ years job-related experience or equivalent combination of education and related work experience
• Master's degree preferred for Senior Enrollment and Forecasting Analyst role

Skills and Attributes

• Keen analytical and problem-solving skills
• Demonstrated ability to communicate effectively, verbally and in writing, with all levels of the organization
• Focused on serving our customers, including internal departments and external brokers/agents, state regulators, BCBSA, DHS companies
• Ability to think analytically, apply analytical techniques, and provide in-depth analysis and recommendations to management using critical thinking and sound judgment
• Motivated, self-starting nature; capable of and comfortable with independent critical thinking & problem solving

What You Will Do

• Provide corporate enrollment results monthly
• Represent Enrollment & Forecasting, as well as the Product Department, in cross-functional activities
• Respond to and fulfill, where appropriate, ad-hoc data requests
• Develop on-going product enrollment and/or enrollment sensitivity modeling and gauge impact to Cambia products and/or lines of business
• Prepare enrollment trends by segment and/or product for strategy development, using quantifiable data
• Prepare ongoing analyses to support Cambia's quarterly forecast planning sessions for each affiliate plan to generate short-term enrollment projections
• Prepare and present analytic reports and business recommendations to internal customers
• Analyze current forecast and/or products goals, researching and evaluating current economic conditions that may affect the organization's ability to acquire and retain members in the marketplace based on the product portfolio
• Provide the opportunity to improve customer satisfaction and positively impact business results through continual process improvement to ensure streamlined, systematic approach to reporting and forecasting while utilizing standard tools

Additional Duties for Senior Enrollment and Forecasting Analyst

• Mentor and support members of Product Development, as well as other departments, in utilizing and interpreting data to create valid, useful information using the most current tools and processes
• Act as a resource to all levels of Product Development staff regarding enrollment, forecasting and/or performance of all product offerings
• Lead Enrollment & Forecasting team in reporting process improvement specific to reporting automation
• Lead enrollment data validation and investigation, and act as primary contact for enrollment specific data warehouse correction activities
• Prepare in-depth product enrollment and/or enrollment analysis for management to make informed decisions
• Participate and/or lead monthly forecast meetings with Sales leadership and Plan Presidents to ensure proper staffing levels for operational departments as well as supporting all financial modeling based on membership
• Lead cross functional meetings, including the development of materials, agenda and analysis for participants from Market Insights, Product Development, Marketing services, Underwriting and Finance
• Able to communicate effectively and work directly with the senior management, including COO, CFO, CRO, Plan Presidents, etc.
• Represent department specific to enrollment reporting, enrollment forecasting and product performance
• Maintain department specific database, including building and updating tables and security access
• Represent Cambia internally and externally as a subject matter expert

Work Environment

No unusual working conditions. Work primarily performed in office environment. May be required to work outside normal hours. Travel may be required, locally or out of state.

Pay and Schedule

• Enrollment and Forecasting Analyst: Expected hiring range $76,500.00 – $103,500.00, full salary range $72,000.00 – $117,000.00, bonus target 10%
• Senior Enrollment and Forecasting Analyst: Expected hiring range $92,700.00 – $125,400.00, full salary range $87,000.00 – $142,000.00, bonus target 15%