Financial Data Analyst - Population Health

The Population Health Financial Data Analyst will support clinic operations and population health initiatives by extracting, compiling, validating, analyzing and presenting data to Clinic Leadership. This position will help develop and drive clinical improvement and efficiency strategies through influential delivery of actionable analytics. Responsibilities: Participates in teams supporting high visibility strategic initiatives in the areas of Quality and Population Health, including joint operating committee payor meetings, process improvement, clinical initiatives, and financial initiatives. Understands department, segment and organizational strategy and operating objectives including their linkages to related areas. Provides decision support required for day-to-day operations to strategic planning and specific business performance issues across a matrixed environment. Fosters key relationships with business stakeholders. Coordinates with all levels of management and clinical teams to analyze, summarize, and prepare recommendations regarding key patient metric trends, costs, utilization, and financial gap opportunities for variety of value-based care contracts. Constructs detailed financial models and routine reconciliations to assist in understanding and accounting of present performance against projected plans, contractual agreements, and budgets. Creates highly efficient financial models by integrating data from multiple data sources using a combination of databases, system tools, advanced skills in MS Office products, and data warehouse SQL queries and scripts. Responsible for the development, maintenance, and enhancements of financial models, analytical reports, and data warehousing of market, CMS, and payor claims data used in analyzing quality, cost and utilization, risk adjustments, audits of payor reports & settlement payments, budgeting, and forecasting for management and corporate Finance. Assist in the awareness and adaptation of techniques in the field of value-based contract financial analysis and forecasting. Perform other duties as assigned Requirements: Bachelor’s degree in Accounting, Finance, or other advanced degree in quantitative disciplines (e.g., Mathematics, Economics, Statistics, Computer Science). Minimum of 5 years of experience in financial analysis and data analysis with respect to identifying and defining source data from large data sets using SQL or other data profiling tools. Healthcare and EHR data experience is necessary, with a specific emphasis on HCC risk scoring mechanics, Quality metrics, and understanding of various value-based care programs. Strong financial modeling and analysis skills. Strong attention to detail. Advanced Microsoft Excel and Access skills including external data connections and PowerPivot development experience. Ability to perform complex mathematical calculations. Must achieve certification in at least one Epic application within first 2 years of employment. Preferred: SQL experience Power BI experience, or similar data visualization tools such as Tableau or Qlik. Understanding of Medicare and Medicare Advantage programs, related Medicare Risk Adjustment and payment models. Designations preferred: CPA, CMA, CGMA, MBA Pay Range: $88,037.00 - $132,055.00 The above information is intended to indicate the general nature and level of work required in this position. It is not designed to contain or be interpreted as a comprehensive description of all duties, responsibilities, and qualifications required of those assigned to this job. We offer a competitive Total Rewards Program. Eligibility for benefits is dependent on factors such as position type and FTE. Benefit-eligible employees qualify for benefits beginning on the first of the month following one month of employment. Vancouver Clinic offers medical, dental, vision, life insurance, AD&D, long term disability, health savings account, flexible spending account, employee assistance program, and multiple supplemental benefits (voluntary life, critical illness, accident, hospital indemnity, identity theft protection, legal services, etc.). We also offer a 401k retirement plan, along with an employer matching contribution up to 4%. Compensation packages and time off programs vary and are dependent on factors such as department, position type, primary work state and FTE. Contact your Recruiter for full information. Vancouver Clinic is proud to be an Equal Opportunity Employer. Vancouver Clinic does not discriminate on the basis of race, color, gender, disability, veteran, military status, religion, age, creed, national origin, gender identity or expression, sexual orientation, marital status, genetic information, or any other basis prohibited by local, state, or federal law. Vancouver Clinic is an alcohol and drug-free workplace. Offers are contingent on successful completion of background screen and immunization requirements.