Enrollment & Forecasting Analyst or Senior

Cambia Health Solutions•Medford, OR

8d•$72,000 - $142,000•Hybrid

About The Position

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.

Requirements

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 (for Analyst)
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 (for Senior Analyst)
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.
Able to communicate effectively and directly with the highest levels of management (for Senior Analyst).
Demonstrates knowledge and developing expertise of matters concerning corporate enrollment, forecasting, and/or product analytics (for Senior Analyst).
Actively participates in analysis and projects company wide (for Senior Analyst).
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 (for Senior Analyst).
Develop and maintain strong working relationships with regulators (for Senior Analyst).
Oversees process and ensures accurate delivery of all internal reporting and external filings (for Senior Analyst).
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 (for Senior Analyst).

Nice To Haves

Master's degree preferred.

Responsibilities

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.
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.

Benefits

Medical, dental and vision coverage for employees and their eligible family members, including mental health benefits.
Annual employer contribution to a health savings account.
Generous paid time off varying by role and tenure in addition to 10 company-paid holidays.
Market-leading retirement plan including a company match on employee 401(k) contributions, with a potential discretionary contribution based on company performance (no vesting period).
Up to 12 weeks of paid parental time off (eligibility requires 12 months of continuous service with Cambia immediately preceding leave).
Award-winning wellness programs that reward you for participation.
Employee Assistance Fund for those in need.
Commute and parking benefits.
Competitive base pay
Market-leading 401(k) with a significant company match
Bonus opportunities