Senior Analytics Engineer at Fieldguide

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

Job Title

Senior Analytics Engineer

Salary

Not Disclosed

Company Description

Fieldguide is a San Francisco-based AI company building the agentic platform for audit and advisory firms, backed by Goldman Sachs, Bessemer Venture Partners, 8VC, and Y Combinator.

Job Description

Join Fieldguide to own the data foundation for Fieldguide Insights, our flagship analytics product. You will architect the semantic layer and dbt models that power mission-critical reporting for the world's largest CPA firms. This role combines deep technical modeling with the opportunity to shape AI-native data interfaces in a high-growth environment.

Location

San Francisco, USA

Why this role is remarkable

• Join a high-growth leader backed by top-tier investors like Goldman Sachs and Bessemer, serving over half of the top-100 CPA firms including several Big 4.
• Own the entire analytics foundation from the ground up, designing a Kimball-style warehouse that serves both traditional BI and emerging LLM-based analytics.
• Work at the intersection of AI and professional services, building the "agentic" layer that will reshape how a massive, regulated industry operates.

What You Will Do

• Define the canonical tables, metrics, and semantic layer behind every report to ensure all customer-facing data is reliable and defensible.
• Migrate production logic into governed dbt models with robust test coverage while hardening pipelines against upstream schema changes.
• Collaborate with Product and Engineering to design and implement a dimensional warehouse capable of feeding next-generation AI-native data interfaces.

The ideal candidate

• Has 5+ years of experience in a modern data stack with expert-level SQL and deep hands‑on proficiency in dbt modeling and testing.
• Demonstrates mastery of dimensional modeling (Kimball) and writes production-quality Python with fluency in version control and CI/CD workflows.
• Is based in San Francisco and thrives in a collaborative, in‑person environment focused on building lovable products for regulated industries.