Senior Analytics Engineer — AI-Driven Data Stack & BI

Hercules; San Francisco (CA); Hybrid; USD 100,000 - 250,000; Full time

Benefits offered by this job

Unlimited AI token budget

Vacation policy

Healthcare, vision, and dental

Daily lunches, dinners and snacks in i

Job summary

Hercules in San Francisco seeks a senior analytics and full-stack engineer to own our data stack and help build the future of AI software development. You will handle ETL from third-party providers into BigQuery, data modeling with DBT, semantic layer modeling, and BI dashboards using Omni.

You should be strong across system design, data modeling, and semantic layers, with a passion for AI-enabled coding and self-serve analytics across the company.

Qualifications

• Strong experience in system design, architecture, data modeling, and API design.
• Clean, maintainable code in a monorepo.
• Experience modeling data with DBT or similar declarative framework.
• Experience with semantic layer modeling using Omni, Looker, or similar.
• Strong BI understanding for effective data visualization.

Responsibilities

• Own ETL from 3rd party providers into the Data Warehouse (BigQuery).
• Model and clean data, using DBT and medallion architecture.
• Define and model key business metrics in the semantic layer.
• Build dashboards and visualisations to enable company-wide self-serve BI using Omni.

Skills

Software fundamentals

Code quality

Data modeling

Semantic layers

Business intelligence

AI

Tools

DBT

Omni

Looker

BigQuery

Airbyte

Datastream

ClickHouse

Job description

Hercules in San Francisco seeks a senior analytics and full-stack engineer to own our data stack and help build the future of AI software development. You will handle ETL from third-party providers into BigQuery, data modeling with DBT, semantic layer modeling, and BI dashboards using Omni.

You should be strong across system design, data modeling, and semantic layers, with a passion for AI-enabled coding and self-serve analytics across the company.