Lead Data Analyst

Gifthealth

. Own the analytical direction for a domain .

Posted 11/6/2026full-timeColumbus • Ohio • United StatesSenior💰 $132,000 - $165,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, SQL, and dbt model management while leading a team of analysts to drive performance and ensure data integrity. Proficient in healthcare data compliance, including PHI and HIPAA requirements, with strong communication skills to convey findings to stakeholders.

Highest-signal resume keywords

Deep SQL ProficiencyData Analysis LeadershipHealthcare Data ComplianceMetric Definition DocumentationDbt Model Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisSQLDbtMetric DefinitionData ValidationData System JoinsPatient-Level ReconstructionPerformance ManagementData-Driven Decision MakingHealthcare Data Understanding

Soft Skills

LeadershipCommunicationCritical ReviewNegotiationTeam Building

Tools & Technologies

LookerLookMLPythonBI ToolsData Warehousing

Industry Keywords

PHIHIPAAPharmacy DataClaims ProcessingAdjudicationPrior AuthorizationPrescription LifecycleManufacturer Patient-Support Programs

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Own the analytical direction for a domain
Define canonical metrics and authoritative data sources
Decide what is modeled in dbt versus answered ad hoc
Establish validation requirements for client- and executive-facing results
Drive metric definitions into the dbt layer with data engineering and BI
Ensure metrics are traceable to their computation and exclusions
Manage two to three data analysts as direct reports
Conduct 1:1s, review SQL and conclusions, create growth plans, and handle performance conversations
Own analysis sequencing and prioritize business needs
Retire recurring reporting when appropriate and negotiate priorities with operations, account teams, and leadership
Investigate difficult questions requiring patient-level reconstruction and identified mechanisms in the data
Work with other leads and BI to keep shared metrics consistent across domains
Understand joins across NDP, LDZ, IDP, BestRx, and the entity-resolution layer
Teach analysts about data-system joins and row loss
Report to the Manager, Analytics & Reporting, with a dotted line to the Director, Data & Analytics
Attend regular meetings with the Analytics & Reporting team, direct reports, and Data & Analytics leadership
Spend time on the distribution floor and listen to patient calls to understand operations
Make periodic on-site visits to the Columbus distribution center and call center, primarily during onboarding

Requirements

What you’ll need

Degree is optional; equivalent hands-on experience is fully acceptable
Typically 7 to 10 years of hands-on data analysis experience
Track record as the senior analyst others checked their work with
Deep SQL and ability to work with large dbt model warehouses
Ability to critically review SQL and check for fan-out before trusting totals
Experience setting and documenting metric definitions
Experience managing or leading analysts, formally or informally
Ability to validate results against a second source
Ability to explain findings to operations leads, account managers, and directors
Comfort working in an unfinished stack with migrations in progress
Experience handling PHI, masking, BAAs, and role-based access
Strong understanding of healthcare data, PHI, and HIPAA requirements
Proven ability to lead a small team and drive performance across a domain
Excellent leadership, communication, and data-driven decision-making skills
Preferred: pharmacy, specialty pharmacy, healthcare, or payer data experience
Preferred: claims, adjudication, prior authorization, NDCs, or prescription lifecycle experience
Preferred: manufacturer patient-support or hub program experience
Preferred: dbt model writing, testing, and review experience
Preferred: Looker and LookML experience or legacy BI migration experience
Preferred: Python for analysis
Preferred: experience owning a metric layer or definitions catalog

Benefits

Comp & perks

Fully remote option within the US
Periodic on-site visits primarily during onboarding
Full-time exempt employment
Opportunity to lead and manage a small team
Growth plans and performance development for direct reports
Inclusive workplace and equal employment opportunity