Healthcare Data Analyst

Vatica Health

2h•$80,000 - $90,000

About The Position

The Healthcare Data Analyst is responsible for supporting Cozeva + Vatica’s analytics efforts in support of the Growth team and broader corporate initiatives. These services include, but are not limited to, development of rapid client-facing outputs in support of new sales and expansion of existing relationships, enable visibility to risk adjustment market metrics, support other organizational efforts leveraging analytics. The Healthcare Data Analyst will serve as a partner with the BI reporting team and the Data Engineering team, filling time-sensitive needs with rapid-response solutions and subsequently supporting migration to institutional tools when appropriate.

Requirements

High proficiency with Microsoft Suite: Access, Excel and PowerPoint
High proficiency with Azure Synapse Analytics and the ability to code in T-SQL, Spark SQL and pyspark or similar languages
2-5 years’ experience working in health plan or provider analytics, preferably in risk adjustment or quality.
Experience working in PowerBI or Tableau
Ability to understand and ingest complex internal and external business-related data sets.
Ability to work quickly to develop rapid solutions to meet immediate needs.
Direct experience with risk adjustment (Medicare Advantage and/or ACA) understanding core metrics such as condition prevalence, HCC scoring, etc.
Experience pulling data from disparate platforms to create an accurate unified picture used to drive business decisions.
Excellent multitasking and prioritization skills with a proven ability to manage multiple, simultaneous projects to completion
Highly organized and detail oriented.
2-year degree required

Nice To Haves

Experience in Salesforce.com CRM (Preferred)

Responsibilities

Gather, interpret, and employ internal and public data to support identification of clear actions to drive corporate growth.
Refresh, interpret, and distribute analytics to support regular meetings and work groups.
Support collaboration with health plan clients to analyze, design, and develop networks through ongoing evaluation of both current and potential network participants.
Contribute to design and development of data-driven client solutions.
Analyze data related to practice/provider participation, to identify opportunities to increase the number of participating providers (in existing practices) and new practices participating in Cozeva + Vatica’s programs.
Participates in the development of targeting for sales campaigns.
Payer Opportunity Projections: Analysis of potential payer networks in preparation of Provider network campaign loads.
Using Access/Power BI desktop/Alteryx, load and evaluate pre-sale data files from prospective payers.
Identify contracted organizations (Wave Zero) and net new organizations (Wave One) having sufficient opportunity, factoring any Payer carve-outs.
Complete geo mapping as needed.
Evaluate members overlap with other Payers as needed.
Prepare Campaign load data in format defined by Salesforce administrator, and initiate Campaign load with Salesforce administrator following final approval.

Benefits

Competitive salary based on your experience and skills – we believe the top talent deserves the top dollar
Bonus Potential (based on role and is discretionary) – if you go above and beyond, you should be rewarded
401k plans– we want to empower you to prepare for your future
Room for growth and advancement- we love our employees and want to develop within
Comprehensive Medical, Dental, and Vision insurance plans
Tax-free Dependent Care Account
Life insurance, short-term, and long-term disability
Excellent PTO policy (everyone deserves a vacation now and then)
Great work-life balance environment- We believe family comes first!
Strong supportive teams- There is always a helping hand when you need it