Business Intelligence Architect II

At Gifthealth, we're revolutionizing the way people experience healthcare by simplifying the process of managing prescriptions and health services. Our mission is to provide a seamless, personalized, and efficient healthcare experience for all our customers. We're a dynamic, innovative, and customer-centric company dedicated to making a positive impact on people's lives.

Position Summary

We are seeking a Business Intelligence Architect II to own the Looker semantic layer, BI platform provisioning, and the design of external client-facing BI access, while setting technical direction for BI developers and analysts across the domain. This position plays a key role in supporting the Data & Analytics department and reports to the Manager, BI & Reporting (until that role is filled, the Director of Data & Analytics), ensuring alignment with organizational goals, operational excellence, and compliance standards.

This is a platform-level individual-contributor role: there are no direct reports at this level, but the role carries technical direction and mentorship for BI developers and analysts, and real hands-on time in LookML and SQL.

Key Responsibilities

• Own the Looker semantic layer: explores, views, model files, and the boundary between dbt and LookML, writing the LookML standards that enforce it and harvesting metric logic that currently lives in the wrong place. Own metric definitions per business domain, with domain differences documented rather than smoothed over.
• Own BI platform provisioning: Looker instance configuration, model and project structure, git workflow for LookML, user and group provisioning, and connection management against Snowflake, including the dated plan for Domo retirement.
• Design and own external client-facing BI access: per-client data isolation enforced in the platform, row-level and column-level access aligned with dbt masking policies in Snowflake, and a provisioning path that Legal and Security will sign off on.
• Govern what "trusted" content means: certified versus ad hoc content, naming, folder structure, deprecation, and change control on metric definitions so a silent definition change never lands in a client-facing deck.
• Set technical direction for the BI domain: the patterns BI developers and analysts build on, delivered through code review, pairing, and written standards rather than direct reports.
• Design how the semantic layer represents the identity-resolution layer's reporting surface, accounting for match confidence and records that merge after a report has already gone out.

Qualifications

• Education: Bachelor's degree preferred; not required. We evaluate demonstrated capability rather than credentials.
• Experience: 7 to 10 years of experience in business intelligence or data platform work, including deep hands-on Looker/LookML project structuring and strong SQL/dbt experience. This band is guidance rather than a gate.

Knowledge, Skills, and Abilities:  

• Deep Looker and LookML experience: has structured a LookML project, made the modeling calls, and lived with them a year later — not just used Looker.
• Has designed a semantic or metric layer that other people built on, and can explain what didn't work the first time.
• Strong SQL skills and enough dbt fluency to argue about where a transformation belongs and then go write it.
• Experience with multi-tenant or external-facing BI access: row-level security, per-customer isolation, and the difference between hiding data and not sending it.
• Willing to chase a metric definition into the operational reality behind it, and writes standards down so they can actually be found and followed.
• Demonstrated application of the above Qualification
• Nice to have: healthcare, pharmacy, or other regulated-data experience (PHI, HIPAA, masking, role-based access as daily practice); experience migrating off a legacy BI tool; Snowflake performance and cost tuning; treating BI platform configuration as code (e.g., Terraform); identity resolution or master data management; or experience with a second BI platform such as Power BI.

Work Environment

• Location: Columbus, OH or Remote (US).
• Schedule: Full-time; standard business hours.
• May require flexibility for escalations tied to client-facing access work and the Domo retirement timeline.
• Regular collaboration with BI developers, analysts, Legal, and Security, plus time on the distribution center floor and with the call center to understand the operational data firsthand.

Key Essential Functions

• Must be able to work at a computer for extended periods
• Must be able to communicate effectively, verbally and in writing, with cross-functional stakeholders including Legal and Security
• Must be able to handle and access data in compliance with HIPAA and PHI handling requirements
• Must be able to periodically visit the distribution center and call center to observe operations firsthand

Employment Classification

Status: Full-time
FLSA: Exempt  

Equal Employment Opportunity (EEO) Statement

Gifthealth is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, transgender status, national origin, age, disability, veteran status, or any other legally protected status. 

We celebrate diversity and are committed to creating an inclusive environment for all employees. If you do not meet every requirement but still feel you would be a great fit for this role, we encourage you to apply!

Disclaimer

This job description is intended to describe the general nature and level of work being performed. It is not intended to be an exhaustive list of all responsibilities, duties, or skills required of personnel. Gifthealth reserves the right to modify job duties or descriptions at any time.