Business Intelligence Architect II

Gifthealth

. Own the Looker semantic layer, including explores, views, model files, and the boundary between dbt and LookML .

Posted 10/13/2026full-timeColumbus • Ohio • United StatesSeniorLead💰 $115,000 - $150,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in Looker and LookML, with a strong focus on semantic layer design, metric definitions, and BI platform provisioning. Proficient in SQL and dbt, ensuring compliance with data handling requirements while effectively collaborating with cross-functional teams.

Highest-signal resume keywords

Looker/LookML Project StructuringStrong SQL SkillsRow-Level Security ImplementationMulti-Tenant BI Access DesignHIPAA Compliance Knowledge

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

LookMLSQLDbtBusiness IntelligenceData Platform WorkMetric Layer DesignData IsolationContent GovernanceTechnical DirectionData Access Management

Soft Skills

Effective CommunicationCross-Functional CollaborationDocumentation SkillsInvestigative SkillsProblem-Solving

Tools & Technologies

LookerSnowflakeDomoGit

Industry Keywords

Data Handling CompliancePHI HandlingOperational DataClient-Facing BI AccessData Governance

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Own the Looker semantic layer, including explores, views, model files, and the boundary between dbt and LookML
Write LookML standards and move metric logic into the appropriate layer
Own metric definitions by business domain and document domain differences
Own BI platform provisioning, including Looker configuration, model and project structure, Git workflow, user and group provisioning, and Snowflake connection management
Develop the dated plan for Domo retirement
Design and own external client-facing BI access
Enforce per-client data isolation and align row-level and column-level access with Snowflake dbt masking policies
Establish a provisioning path approved by Legal and Security
Govern trusted content, including certification, ad hoc content, naming, folder structure, deprecation, and metric-definition change control
Set technical direction for BI developers and analysts through code review, pairing, and written standards
Design semantic-layer representation of the identity-resolution reporting surface, including match confidence and post-report record merges
Report to the Manager, BI & Reporting or Director of Data & Analytics
Collaborate with BI developers, analysts, Legal, and Security
Visit the distribution center and call center to understand operational data firsthand

Requirements

What you’ll need

Bachelor's degree preferred but not required
7 to 10 years of experience in business intelligence or data platform work (guidance rather than a gate)
Deep hands-on Looker/LookML project-structuring experience
Experience designing semantic or metric layers
Strong SQL skills
Sufficient dbt fluency to determine where transformations belong and implement them
Experience with multi-tenant or external-facing BI access
Experience with row-level security and per-customer data isolation
Understanding of the difference between hiding data and not sending it
Ability to investigate metric definitions in operational data
Ability to document standards so they can be followed
Demonstrated application of the stated qualifications
Ability to handle and access data in compliance with HIPAA and PHI handling requirements
Ability to work at a computer for extended periods
Ability to communicate effectively verbally and in writing with cross-functional stakeholders
Ability to periodically visit the distribution center and call center
Work location must be Columbus, Ohio or elsewhere in the United States for remote work

Benefits

Comp & perks

Fully remote work option
Full-time standard business hours
Technical mentorship and direction opportunities
Opportunity to work with innovative healthcare technology
Equal Opportunity Employer committed to an inclusive environment