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 orga