Gifthealth operates at the intersection of healthcare technology and prescription fulfillment, helping coordinate medication access across patients, prescribers, pharmacies, and pharmaceutical manufacturers. Its digital platform supports enrollment, electronic benefits verification, electronic prior authorization, affordability assistance, pharmacy fulfillment, and patient support. Gifthealth also gives manufacturers visibility into patient journeys and brand performance, helping them understand access barriers and improve the reliability of medication delivery.
Senior Business Intelligence Architect II
Lead Gifthealth’s Looker semantic modeling, Snowflake access, and client-facing business intelligence. Set technical standards and direction for BI developers and analysts in a healthcare setting.
United States
Ohio$115,000 – $150,000 / year
HybridFull-timeSeniorLeadEnglish RequiredBusiness Intelligence AnalystDescription
- Own and shape the Looker semantic layer, from explores and views to the boundary between dbt and LookML
- Set LookML standards and place metric logic in the appropriate layer
- Define metrics by business domain and document differences across domains
- Manage BI platform provisioning, including Looker configuration, project structure, Git workflows, user and group access, and Snowflake connections
- Create a dated plan to retire Domo
- Design and manage BI access for external clients
- Protect client data isolation and align row- and column-level access with Snowflake dbt masking policies
- Establish a provisioning process approved by Legal and Security
- Govern trusted BI content through certification, ad hoc content policies, naming, folders, deprecation, and metric change control
- Guide BI developers and analysts through code reviews, pairing, and written standards
- Model identity-resolution reporting in the semantic layer, including match confidence and record merges after reporting
- Report to the Manager of BI & Reporting or the Director of Data & Analytics
- Work with BI developers, analysts, Legal, and Security
- Visit the distribution center and call center to learn how operational data is generated and used
Requirements
- A bachelor’s degree is preferred but not required
- Typically 7 to 10 years of experience in business intelligence or data platform work; this is guidance, not a strict cutoff
- Hands-on experience structuring Looker and LookML projects
- Experience designing semantic or metric layers
- Strong SQL skills
- Enough dbt knowledge to decide where transformations belong and implement them
- Experience with multi-tenant or client-facing BI access
- Experience with row-level security and isolating data by customer
- Understanding of the distinction between hiding data and preventing it from being sent
- Ability to investigate metric definitions in operational data
- Ability to document standards clearly enough for others to follow
- Demonstrated ability to apply the stated qualifications
- Ability to handle and access data in compliance with HIPAA and PHI requirements
- Ability to work at a computer for extended periods
- Clear verbal and written communication with cross-functional stakeholders
- Ability to make periodic visits to the distribution center and call center
- Must be based in Columbus, Ohio, or elsewhere in the United States for remote work
Benefits
- Option to work fully remotely
- Full-time role with standard business hours
- Opportunities to provide technical mentorship and direction
- Work with innovative healthcare technology
- Equal opportunity employer committed to an inclusive workplace