Senior Analytics Engineer: Data Modeling & LookML Lead

Virta Health; Oregon; Hybrid; USD 162,000 - 209,000; Full time

Job summary

Virta Health seeks a Senior Analytics Engineer to build trusted data models, write SQL and dbt, and connect source-system behavior to clear business meaning. You will collaborate with Analytics, Finance, Growth, Customer Success, and Clinical teams to deliver reliable data products at scale.

You’ll implement automated tests, optimize SQL, and support Looker/BigQuery workflows in a remote-first environment with hubs in Denver and San Francisco. Strong data-engineering fundamentals are essential.

Qualifications

• 5+ years of experience in analytics engineering, data engineering, or a related technical role.
• Advanced SQL skills and data-modeling judgment.
• Hands-on experience with dbt, including modular transformations, incremental models, testing, documentation, and dependency management.
• Experience developing LookML views, Explores, dimensions, and measures, including diagnosing join behavior and keeping metric definitions consistent across reporting experiences.
• Experience with BigQuery or a comparable cloud data warehouse, including optimization, freshness, performance, and cost considerations.
• Strong software engineering practices for data work, including version control, code review, automated testing, and controlled deployments; Python or Go for scripting, validation, and automation.
• Ability to translate ambiguous business requirements into reusable technical solutions, asking the right questions to define definitions and tradeoffs.
• Strong debugging skills and experience tracing data issues across source systems, transformations, and BI tools.
• Experience with AI-assisted development tools and validating generated code against real data behavior.

Responsibilities

• Build reusable analytical models. Design and implement dbt models and BigQuery datasets with proper grain, keys, and history.
• Develop semantic LookML views, Explores, measures, and dashboards; ensure consistency across dbt and Looker.
• Deliver modernization work into production, including Looker Core migration and retirement of legacy models.
• Turn business questions into technical solutions with cross‑functional stakeholders to create reusable data products.
• Own data correctness and operational quality with automated tests and safeguarding against issues.
• Improve performance via SQL optimization, materializations, incremental processing, and partitioning/clustering.
• Build data capabilities for AI and agents with governed datasets and clear interfaces for ML workflows.
• Lead execution from scoping to deployment, with code review and reusable pattern sharing.

Skills

Analytics engineering

Advanced SQL

dbt

LookML

BigQuery

Python or Go

Data modeling

Version control/CI‑CD

Debugging data issues

Tools

BigQuery

dbt

Python

Git

Job description

Virta Health seeks a Senior Analytics Engineer to build trusted data models, write SQL and dbt, and connect source-system behavior to clear business meaning. You will collaborate with Analytics, Finance, Growth, Customer Success, and Clinical teams to deliver reliable data products at scale.

You’ll implement automated tests, optimize SQL, and support Looker/BigQuery workflows in a remote-first environment with hubs in Denver and San Francisco. Strong data-engineering fundamentals are essential.