Enrollment & Forecasting Analyst or Senior

Enrollment And Forecasting Analyst Or Senior

Hybrid role (3 days/week in office) at our Portland, Medford, Fargo, Burlington, Vancouver, Renton, Spokane, Boise, Lewiston or Salt Lake City offices. Candidates must reside within commutable distance of that location.

Build a career with purpose. Join our Cause to create a person-focused and economically sustainable health care system.

Who We Are Looking For:

Every day, Cambia's dedicated team of Enrollment and Forecasting Analyst or Senior is living our mission to make health care easier and lives better. As a member of the Strategic Finance team, our Enrollment & Forecasting Analyst is responsible for analyzing and reporting business intelligence information for Cambia, specifically centered on corporate enrollment results and product performance. Incumbents are highly customer-focused, providing service to internal and external partners. They must be capable of constantly engaging in analytic activities to track trends over time, enabling senior leadership to make sound short and long term strategic decisions all in service of creating a person-focused health care experience.

Do you have a passion for serving others and learning new things? Do you thrive as part of a collaborative, caring team? Then this role may be the perfect fit.

What You Bring to Cambia:

Qualifications:

The Enrollment/Product Forecast Analyst would have a 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

The Enrollment/Product Forecast Analyst Senior would have a Bachelor's degree in mathematics, computer science, business administration or an equivalent related field and 7+ years job-related experience or equivalent combination of education and related work experience. Master's degree preferred.

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 (e.g. Customer Service, Provider Services, Finance, Regulatory Affairs, Underwriting, Strategic Communications, Product Development, Legal, Marketing, Executives) as well as external customers (Brokers/Agents, State Regulators, BCBSA, DHS companies).
• Ability to think analytically, apply analytical techniques and to provide in-depth analysis and recommendations to management using critical thinking and sound judgment.
• Ability to participate in a team atmosphere to achieve department goals and objectives consistent with corporate vision and strategies.
• Motivated, self-starting nature; responds positively to moderate guidance yet is capable of and comfortable with independent critical thinking & problem solving.
• Ability to work independently, or collaboratively, on simple projects and issues with minimal financial and/or risk impact to the corporation.

Additional Skills and Attributes for Senior Enrollment and Forecasting Analyst

• Able to communicate effectively and directly with the highest levels of management.
• Demonstrates knowledge and developing expertise of matters concerning corporate enrollment, forecasting, and/or product analytics.
• Actively participates in analysis and projects company wide.
• Ability to analyze internal performance data, market activity and corporate strategy to deliver short term and long-term forecasting at multiple levels, including companies, segments and products.
• Develop and maintain strong working relationships with regulators.
• Oversees process and ensures accurate delivery of all internal reporting and external filings.
• Ability to utilize business tools, including strong proficiency with Microsoft Office Suite (Excel, Word, Access, PowerPoint), as well as proficiency with data analytics tools, such as SQL, SAS, Tableau.
• Demonstrated ability to retrieve complex data sets from internal systems, such as Facets, to support ongoing enrollment analysis activities.
• Ability to work independently, on projects and issues with medium financial and/or risk impact to the corporation.

What You Will Do at Cambia:

• 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. This may also include assisting with the development of long-term projections utilized in the corporate scenario planning process.
• 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.
• Collects 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.
• Leads Enrollment & Forecasting team in reporting process improvement specific to reporting automation.
• Leads enrollment data validation and investigation, and act as primary contact for enrollment specific data warehouse correction activities.
• Prepares 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.
• Maintains department specific database, including building and updating tables and security access.
• Represents 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.

Enrollment and Forecasting Analyst:

• 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,7