Program Data Analyst II — Healthcare (Remote)

Gifthealth Inc; Columbus (OH); Híbrido; USD 65 000 - 90 000; Tempo integral

Resumo da oferta

Gifthealth is seeking a Data Analyst II to own a manufacturer program’s enrollment funnel, payer nuances, and data sources for recurring reporting and ad hoc analysis. You will partner with the Analytics & Reporting team to ensure accuracy, security, and timely insights.

The role emphasizes building Looker dashboards, validating metrics, and collaborating with operations to align with clinical and distribution workflows. Experience with SQL and healthcare data is valued.

Qualificações

• Bachelor's degree preferred; not required.
• 2 to 4 years of experience in data analysis.
• Proficient in SQL with window functions and aggregation.
• Strong written and verbal communication for non-technical stakeholders.
• Experience with healthcare or payer data is a plus.
• dbt, Looker, and Snowflake exposure is beneficial.

Responsabilidades

• Own one manufacturer program or internal domain deeply: its enrollment funnel, payer quirks, fulfillment path, and where its data comes from and lives.
• Own recurring reporting that goes out on a schedule: weekly and monthly program reporting plus support for daily feeds, reviewing numbers before they leave and raising unexplained changes rather than shipping them.
• Answer questions with a deadline attached by tracing them through claim adjudication, prior authorization status, prescription state changes, and fulfillment records, returning an answer plus your confidence in it.
• Write down metric definitions when you settle a disagreement for your program, keep reporting consistent with them, and document them where the next person will find them.
• Build dashboards in Looker, our primary BI platform (Metabase also in use, migrating off Domo), including client-facing Looker work that is still being stood up, and raise a dbt model request when logic belongs in the warehouse rather than in a dashboard tile.
• Handle PHI carefully as a daily practice: know what your access covers, use the minimum you need, and ask before moving patient-level data anywhere new.

Conhecimentos

SQL

Data analysis

Window functions

Python

Data validation

Communication

Formação académica

Bachelor's degree preferred

Ferramentas

Looker

LookML

dbt

Snowflake

PostgreSQL

Excel

Descrição da oferta de emprego

Gifthealth is seeking a Data Analyst II to own a manufacturer program’s enrollment funnel, payer nuances, and data sources for recurring reporting and ad hoc analysis. You will partner with the Analytics & Reporting team to ensure accuracy, security, and timely insights.

The role emphasizes building Looker dashboards, validating metrics, and collaborating with operations to align with clinical and distribution workflows. Experience with SQL and healthcare data is valued.