Senior Analytics Engineer
Senior Analytics Engineer owning the semantic layer, dbt pipelines, and dimensional models that power Fieldguide Insights analytics product for audit and advisory firms. Requires 4+ years modern data stack experience with advanced SQL, dbt, Python, BigQuery, and Kimball modeling.
About the job
What You'll Do
- Design and own the Insights semantic layer, establishing canonical definitions for the tables, columns, and metrics behind each report so the numbers we ship are trusted and consistent across the business.
- Standardize how we define core metrics, reconcile them across data sources such as Amplitude, and clearly document any variances.
- Migrate production report logic into governed, tested, and portable dbt models, strengthening test coverage and reusable macros along the way.
- Improve the reliability of business-critical pipelines through proactive monitoring, alerting, and resilience to upstream schema changes.
- Partner with customers and internal teams on data quality and new environment launches, including triage, onboarding, and data handling requirements.
- Contribute to the design of a Kimball-style dimensional warehouse built to serve both traditional BI and emerging LLM and MCP-based analytics.
- Help drive the migration of BI reporting onto the semantic layer, from report inventory and classification through cutover planning.
Who You Are
- 4+ years in a modern data stack, with advanced SQL and deep hands-on dbt expertise across modeling, testing, and project structure.
- An engineer at heart: you ship production-quality Python, work fluently with version control and CI, and are comfortable diagnosing pipeline failures end to end.
- A skilled dimensional modeler (Kimball, slowly changing dimensions) who designs data models built to last as the business evolves.
- Analytically fluent, with a strong sense for data quality and the judgment to validate that results are correct, not just computed.
- Deep experience with BigQuery and cloud data warehousing, including cost and performance optimization.
- A collaborative partner who thrives working across teams, coordinating with Infrastructure and App Platform teams to deliver shared outcomes.
- Based in SF and energized by in-person collaboration with our team.
Bonus Points
- A generalist background, with prior time as a data engineer, software engineer, or data scientist on top of the analytics-engineering core.
- Experience feeding LLM or AI-native data interfaces (semantic layer, MCP, text-to-SQL guardrails).
- BI migration experience (Looker, Omni, Tableau).
- A regulated-domain background where correctness is non-negotiable.
Benefits
- Competitive compensation packages with meaningful ownership
- Flexible PTO
- 401(k)
- Wellness benefits starting on your first day
- Technology and work-from-home reimbursement
- Flexible work schedules
Skills
SQL, dbt, Python, BigQuery, Kimball Dimensional Modeling, Looker, Tableau, Amplitude, CI/CD, LLMs, Mcp
Similar jobs
Data Analytics jobs
Zapier
United States
Leads a hands-on GTM analytics team supporting Marketing, Sales, and Customer Operations through trusted reporting, forecasting, experimentation, and self-service automation. Requires 6+ years of analytics experience, at least 1 year of team management, strong SQL, GTM expertise, and advanced analytical judgment.
Okta
Bellevue, WALeads marketing analytics strategy by owning attribution, full-funnel measurement, forecasting, dashboards, experimentation, and AI/ML-driven insights. The role requires 8+ years of overall experience, deep B2B SaaS marketing analytics expertise, and advanced proficiency with Tableau, Salesforce, Snowflake, and Excel.
Scale AI
Washington, DC
Senior Data Analyst supporting the Public Sector business by building scalable analytics solutions, defining metrics, improving data quality, and informing operational and financial decisions. Requires 6+ years of experience, advanced SQL, BI dashboard skills, and an active Secret clearance.
United States
Senior Business Analyst supporting Reddit’s revenue strategy by building BigQuery data pipelines, semantic models, and dashboards for the Large Customer Sales channel. The role requires strong SQL, analytics, cross-functional collaboration, and the ability to translate complex data into measurable business outcomes.
Docker
CanadaStrategic marketing analytics manager-level individual contributor who connects customer, campaign, product usage, and revenue data to improve conversion and pipeline growth. Requires 7+ years of GTM analytics experience, advanced SQL, strong funnel and attribution expertise, and executive communication skills.