Value Based Care Data Analyst

This position will work to drive CommUnityCare’s (CUC) Value Based Payment (VBP) strategy and implementation by translating contracted VBP requirements into data driven insights which identify actionable opportunities that can be executed to ensure timely reporting and successful payment per contract terms. This position will develop dashboard reports that clearly communicate the value-based requirements per contracted party and will partner with cross functional teams to drive key operational decisions, track progress and milestones, and perform other project management functions, to ensure CUC successfully meets VBP reporting requirements for renumeration. This position is responsible for identifying trends and risk to improve operational efficiencies for CUC VBP Programs. This position requires an in-depth understanding of healthcare data including member, claims, clinical and provider data. This position will support management of large data set development, quantitative data analysis methodology and analytical tools for reporting. This position reports to the Business Intelligence team with direction (dotted line) from Finance.

Salary:

69-77k DOE

Essential Duties (at least 5 that are non-negotiable duties and are absolutely pertinent to successfully completing the job without
accommodations):

• Works closely with Value-Based Care Managers and Finance team members to ensure contract terms for Value Based/Incentive payments are met, maximizing available revenue streams.
• Ensures VBP contract requirements are met by supporting and leading the design, development, execution, dissemination and interpretation value based metrics and reports using clinical, member and administrative data to identify, develop and monitor actionable opportunities.
• Design, develop and manage operational dashboards, metrics, data generators, canned reports and other end-user information portals or resources to support Value-Based initiatives.
• Capture, integrate and analyze data from multiple sources to develop insights, trends and other opportunities to assist in proactively managing Value Based Contracts--Epic EHR system, Insurance carrier portals, Health Plan Rosters, Multiview accounting software
• Perform regular quality assurance checks of data.
• Research and evaluate data from different sources to identify discrepancies and patterns
• Work with the Director of FP&A to identify appropriate solutions for various reporting needs.
• In conjunction with the Director of FP&A and the Senior Financial Intelligence Analyst, develop financial models and analysis to support strategic initiatives around Value Based contract opportunities; providing analyses to support health plan and payer negotiations.
• Synthesizing large amounts of healthcare data to find substantial patterns, trends, and relationships to produce actionable insights which can inform strategy and identify cost reduction, quality improvement, risk capture, and other opportunities
• Responsible for developing high level analyses, recommending courses of action based on data, and presenting ways to improve and expand data use, reporting, and analytics to support internal and external initiatives in support of strategic efforts.
• Analyze and synthesize provider file reports being generated across different platforms.
• Create and maintain documentation of operational practices used in the development of analysis and reports

Knowledge/Skills/Abilities:
• Ability to present and explain status reports to Management, including proficiency in PowerPoint.
• Advanced Microsoft Excel skills including ability to link pivots to external data sources, creating pivot tables, and summarizing data into reports and dashboards.
• Analytical mindset with good problem-solving skills.
• Strong time management abilities.
• Strong knowledge of data management systems and analysis tools
• Outstanding communication and presentation skills.
• Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines and thrive in a demanding, quickly changing environment.
• Ability to manipulate robust data sets to answer key business questions
• Ability to model data using MS Excel, Access, SQL, and /or other data analytical tools

MINIMUM EXPERIENCE:
• 2 years healthcare-related work experience
• 1 year experience writing/running reports in an electronic health record, EPIC experience a plus

PREFERRED EXPERIENCE:
• 3 years in an analytic role, including handling robust data sets
• Proficiency with database programming languages such as SQL
• 2 year experience with Epic Systems EHR
• 2 year experience with PowerBI, Tableau or other data visualization tools

REQUIRED CERTIFICATIONS/LICENSURE:
• Epic certification required within 6 months of hire or within six months of completing Epic training.
• Must meet CommUnityCare’s Epic pre-assessment criteria.

PREFERRED CERTIFICATIONS/LICENSURE:
• Any Epic data model certifications