At Vanna Health, we believe that a sense of belonging and engagement in the community is the foundation for improving overall health and wellbeing for individuals with serious mental illness. We help people living with serious mental illness thrive by strengthening the community ecosystem around them. Through innovative payment models and technology, Vanna Health promotes collaboration across existing behavioral health and primary care providers, hospitals, payers, clubhouses and other community based organizations. Additionally, Vanna Health can deploy our own top quality providers and case managers, as needed, in areas where there may be a shortage of resources.

Vanna Health was founded in 2021 by a team of mission-driven entrepreneurs, working in close partnership with payers, providers, and community based organizations to promote collaboration and improve outcomes while driving down costs. We are committed to the goal of supporting all individuals with culturally competent care regardless of their race, ethnicity, religion, sexual orientation, or gender identity. With modern technology, extensive development opportunities, diverse careers paths, and a culture that values diversity, equity, inclusion, and belonging, we are redefining what it means to work in community health.

The Data Analyst role is critical for Vanna’s developing analytics capabilities. Your work will focus on providing data-driven insights from a wide range of data sources including payer claims, data collected from Vanna’s platform, health information exchange feeds, and EMR data. You’ll become a subject matter expert on all things data at Vanna, working hand-in-hand with our clinical, operations, product, and engineering teams to develop the technology and services that enable our Vanna Coaches to provide compassionate care to our members living with severe mental illness.

This is a unique opportunity to join a small but growing team, where you’ll have the opportunity to develop many of our foundational data capabilities from scratch. You have a growth mindset and are excited about expanding your technical skills and stepping into new responsibilities as the team and company grow.

Responsibilities

• Work collaboratively across the entire Vanna team to design and implement Vanna’s clinical, operational, financial, and product KPIs, and create static reports as well as dynamic dashboards to bring them to life
• Conduct ad-hoc analyses for internal stakeholders and clients, and present findings in a way that drives maximum impact
• Rapidly evolve our common data model for members and claims to support emerging use cases
• Help build out our business intelligence layer in support of self-service analytics
• Partner with data engineers to evolve our internal data tooling
• Partner with product engineers to ensure data collected by Vanna’s platform supports analytics use cases
• Help shepherd data through our end-to-end data platform, resolving any data quality issues along the way

About You

• 4-6 years’ experience in analytics
• Advanced SQL skills
• Experience working with relational databases like Postgres, MySQL, or SQL Server
• Experience working with analytical data stores, including columnar databases like Snowflake, Redshift, or BigQuery or data lakes like Delta Lake or Athena
• Familiarity with dashboarding tools such as Looker, QuickSight, or Tableau
• Intermediate to advanced Google Sheets or Excel skills
• Basic knowledge of Python or a desire to learn
• Excellent communication skills and ability to collaborate on a growing team
• A detective mindset – you love getting to the root of problems and using data to solve them
• Experience working with healthcare data strongly preferred