Senior Analytics Engineer at Fieldguide

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

Job summary

Fieldguide, a San Francisco-based AI company, seeks a Senior Analytics Engineer to own the data foundation for Fieldguide Insights. You will architect the semantic layer and dbt models powering critical reporting for CPA firms.

This role blends deep technical data modeling with shaping AI-native data interfaces in a fast-growing environment, requiring strong SQL, Python, and CI/CD skills and on-site collaboration in San Francisco.

Qualifications

• 5+ years of experience in a modern data stack with expert-level SQL and hands-on dbt modeling.
• Production-quality Python and proficiency in version control and CI/CD workflows.
• Experience designing dimensional models (Kimball) and scalable data architectures.

Responsibilities

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

Skills

SQL

dbt modeling

Python

Version control (Git)

CI/CD workflows

Tools

dbt

Git

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.