Data Analyst II: Domain Mastery & BI Dashboards

Gifthealth Inc; Columbus (OH); Hybrid; USD 65,000 - 85,000; Full time

Job summary

Gifthealth Inc. seeks a Data Analyst II to own recurring reporting and ad hoc analysis for an assigned program, deeply understanding enrollment funnel, payer quirks, fulfillment path, and data sources.

In the Data & Analytics department, you will report to the Manager, Analytics & Reporting, ensure accuracy and compliance, and build Looker dashboards (dbt for warehouse logic; Metabase used during migration from Domo).

Qualifications

• Bachelor's degree preferred; not required.
• 2–4 years of data analysis experience.
• SQL with window functions and careful grain is expected.
• Healthcare data experience is a plus.

Responsibilities

• Own one manufacturer program deeply: enrollment funnel, payer quirks, fulfillment path, and data sources.
• Own recurring reporting: weekly and monthly, support for daily feeds, review numbers before release.
• Answer questions with deadlines by tracing through claims, prior authorization, state changes, and fulfillment records, with a stated confidence level.
• Document metric definitions and ensure consistency across reports, including storage locations for next users.
• Build Looker dashboards (and look at dbt model requests for warehouse logic).
• Handle PHI carefully as part of daily practice: use minimum access and ask before moving data.

Skills

SQL

Looker

LookML

dbt

Python

Education

Bachelor's degree preferred; not required

Tools

Metabase

Domo

Looker

Snowflake

PostgreSQL

Job description

Gifthealth Inc. seeks a Data Analyst II to own recurring reporting and ad hoc analysis for an assigned program, deeply understanding enrollment funnel, payer quirks, fulfillment path, and data sources.

In the Data & Analytics department, you will report to the Manager, Analytics & Reporting, ensure accuracy and compliance, and build Looker dashboards (dbt for warehouse logic; Metabase used during migration from Domo).