Senior Analytics Engineer — AI-Native Data Warehouse

Jack & Jill; San Francisco (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

Fieldguide in San Francisco is seeking a Senior Analytics Engineer to own the data foundation for Fieldguide Insights, powering analytics for the world's largest CPA firms. You will architect the semantic layer and dbt models that drive mission-critical reporting and shape AI-native data interfaces in a high-growth environment.

You will collaborate with cross-functional teams to ensure data reliability, build scalable pipelines, and design a Kimball-style warehouse that serves traditional BI and

Qualifications

• 5+ years of experience in a modern data stack with expert-level SQL.
• Mastery of dimensional modeling (Kimball) and production-grade Python with version control/CI/CD workflows.

Responsibilities

• Define the canonical tables, metrics, and semantic layer behind every report to ensure reliable, defensible data.
• Migrate production logic into governed dbt models with robust test coverage and resilience to upstream schema changes.
• Collaborate with Product and Engineering to design and implement a dimensional warehouse for AI-native data interfaces.

Skills

SQL

dbt modeling

Python

CI/CD

Tools

dbt

Python scripting

Job description

Fieldguide in San Francisco is seeking a Senior Analytics Engineer to own the data foundation for Fieldguide Insights, powering analytics for the world's largest CPA firms. You will architect the semantic layer and dbt models that drive mission-critical reporting and shape AI-native data interfaces in a high-growth environment.

You will collaborate with cross-functional teams to ensure data reliability, build scalable pipelines, and design a Kimball-style warehouse that serves traditional BI and