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

Skills and Attributes

• Keen analytical and problem-solving skills
• Demonstrated ability to communicate effectively, verbally and in writing, with all levels of the organization
• Intensely focused on serving our customers, which include, but are not limited to internal departments and external customers
• Ability to think analytically, apply analytical techniques and to provide in-depth analysis and recommendations to management using critical thinking and sound judgment
• Motivated, self-starting nature; responds positively to moderate guidance yet is capable of and comfortable with independent critical thinking & problem solving

What You Will Do

• Acts as a business partner with Sales, Underwriting, Actuary, Finance, Member Services and Marketing by providing corporate enrollment results monthly
• Represents Enrollment & Forecasting, as well as the Product Department, in cross-functional activities that impact department operations
• Responds to and fulfills, where appropriate, ad-hoc data requests
• Develops on-going product enrollment and/or enrollment sensitivity modeling and gauges impact to Cambia products and/or lines of business on a monthly and quarterly basis
• Provides follow-up functional and analytical support to departmental and single users of enrollment results to promote better understanding of the data
• Prepares enrollment trends by segment and/or product for strategy development, using quantifiable data, which may include sales data retrievals from within the organization
• Prepares ongoing analyses to support Cambia's quarterly forecast planning sessions for each affiliate plan to generate short-term enrollment projections in preparation for corporate quarterly financial and/or operational reviews
• Analyzes Cambia's product enrollment life cycle for determining potential impacts from pricing, promotion, product and competitive environment changes might have on Cambia's performance
• Prepares and presents analytic reports and business recommendations to internal customers
• Collections and analyzes data to evaluate 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
• Provides the opportunity to improve customer satisfaction and positively impact business results through the following activities: Continual process improvement to ensure streamlined, systematic approach to reporting and forecasting while utilizing standard tools; Coordination and analysis of product enrollment life cycle and enrollment forecasting; Interaction with Sales and Operations departments to maintain current and accurate forecasts; Accountable for developing accurate short-term forecast, as well as timely delivery of forecast files to users; Preparation of filings for the BCBSA, DOI, and other external customers as needed, including RFP requests
• Provides staff support to Director of Enrollment & Forecasting in many enrollment and product enrollment analysis activities

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

Pay

• Oregon, Washington, Utah, and Idaho: The expected hiring range is $76,500.00 – $103,500.00, the full salary range is $72,000.00 – $117,000.00 and the bonus target is 10%
• North Dakota: The expected hiring range is $73,231.73 - $99,078.23, the full salary range is $66,273.48 - $106,036.49
• Senior Enrollment And Forecasting Analyst: Oregon, Washington, Utah, and Idaho: The expected hiring range is $92,700.00 – $125,400.00, the full salary range is $87,000.00 – $142,000.00 and the bonus target is 15%
• North Dakota: The expected hiring range is $90,906.79 - $122,991.55, the full salary range is $80,716.23 - $133,182.10

Schedule

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.