Senior Analytics Engineer: AI-Driven Data Platform

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

Benefits offered by this job

Unlimited AI token budget

Take what you need vacation policy

Healthcare, vision, and dental

Daily lunches, dinners and snacks in</

Job summary

Hercules is seeking a senior analytics and full-stack engineer to own the complete data stack, from ETL to BI dashboards. You will work across data from Stripe, Meta ads, and our ops database into BigQuery, model data with DBT, and define semantic layers for accurate metrics.

The role emphasizes self-serve Omni dashboards and AI-enabled coding. The team prefers in-office work in San Francisco, with openness to remote for exceptional candidates who can align with US time zones and travel to the

Qualifications

• Software fundamentals: system design, architecture, data modeling, and API design.
• Code and codebase quality: write clean, maintainable code. Work effectively in monorepos.
• Data modeling: Strong experience modeling data with DBT or another declarative data modelling framework.
• Semantic layers: Strong experience with at least one semantic layer modeling framework like Omni, Looker, etc
• Business intelligence: Strong understanding of the different ways to display data for easy consumption
• AI: able to truly 10x your workflow by being on frontier of AI coding

Responsibilities

• ETL: Get all of our data from 3rd party providers into our Data warehouse (BigQuery).
• Data modeling: Clean and model our data for. We currently use DBT and the medallion architecture
• Semantic layer modeling: Define and model our key business metrics, make sure they are modeled 100% accurately
• Business intelligence: Create dashboards and visualisations that our company will use every day. We use Omni for Business Intelligence. Your goal is to make Omni as self serve as possible for our entire company

Skills

Software fundamentals

Code and codebase quality

Data modeling

Semantic layers

Business intelligence

AI

Job description

Hercules is seeking a senior analytics and full-stack engineer to own the complete data stack, from ETL to BI dashboards. You will work across data from Stripe, Meta ads, and our ops database into BigQuery, model data with DBT, and define semantic layers for accurate metrics.

The role emphasizes self-serve Omni dashboards and AI-enabled coding. The team prefers in-office work in San Francisco, with openness to remote for exceptional candidates who can align with US time zones and travel to the