Senior Analytics Engineer — AI-Driven Data Platform

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

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.