Healthcare Data Analyst

Vatica Health is a company focused on analytics in the healthcare sector, and they are seeking a Healthcare Data Analyst to support their Growth team and corporate initiatives. The role involves analyzing data to drive corporate growth, collaborating with health plan clients, and developing data-driven client solutions.

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

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
• Experience in Salesforce.com CRM