Senior Analytics Engineer – Full-stack

Hercules

. Own the full data stack . Build ETL pipelines bringing data from third-party providers such as Stripe, Meta ads, and operational databases into BigQuery . Clean and model data using DBT and the medallion architecture .

Posted 10/5/2026full-timeSan Francisco • California • United StatesSenior💰 $100,000 - $250,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in building and managing ETL pipelines, data modeling with DBT, and creating self-serve dashboards in Omni. Proficient in system design, architecture, and API design to enhance data accessibility and usability across the organization.

Highest-signal resume keywords

ETL Pipeline DevelopmentDBT Data ModelingOmni Dashboard CreationSystem DesignAPI Design

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 ModelingClean Code PracticesDeclarative Data Modeling FrameworksSemantic Layer ModelingData Visualization

Soft Skills

Iterative Problem SolvingEffective Communication

Tools & Technologies

BigQueryOmniLookerStripeMeta Ads

Industry Keywords

Full-Stack EngineeringAnalyticsMedallion ArchitectureSelf-Serve OutputsFrontier AI Coding

Tech Stack

Tools & technologies

BigQueryETL

About the role

Key responsibilities & impact

Own the full data stack
Build ETL pipelines bringing data from third-party providers such as Stripe, Meta ads, and operational databases into BigQuery
Clean and model data using DBT and the medallion architecture
Define and accurately model key business metrics in the semantic layer
Create dashboards and visualizations in Omni for daily company use
Make Omni as self-serve as possible for the entire company
Ship quickly, iterate, and correct mistakes quickly
Work toward exceptionally simple and self-serve outputs

Requirements

What you’ll need

Senior analytics and full-stack engineering experience
Strong software fundamentals, including system design, architecture, data modeling, and API design
Ability to write clean, maintainable code and work effectively in monorepos
Strong experience modeling data with DBT or another declarative data modeling framework
Strong experience with at least one semantic layer modeling framework such as Omni or Looker
Strong understanding of ways to display data for easy consumption
Ability to significantly accelerate workflow using frontier AI coding
Willingness to work in US time zones if remote
Willingness to travel to the San Francisco office regularly if remote

Benefits

Comp & perks

Unlimited AI token budget
Take what you need vacation policy
Healthcare, vision, and dental
Daily lunches, dinners and snacks in the office
Equity