Data Analytics Engineer

Alchemy; San Francisco (CA); On-site; USD 200,000 - 240,000; Full time

Benefits offered by this job

Medical, Dental, & Vision

Gym Reimbursement

Home Office Build-out Budget

In-Office Group Meals

Commuter Benefits

Flexible Time Off

Wellbeing & Mental Health Perks

Learning & Development Stipend

Company Sponsored Conferences & Events

HSA and FSA Plans

Fertility Benefits

Job summary

Alchemy is seeking a Data Engineer to build and manage data models in Snowflake, enabling AI-driven decisions company-wide. The ideal candidate has over 6 years in data engineering with strong SQL skills and extensive experience in Snowflake. Responsibilities include creating optimal data structures, ensuring data quality, and facilitating conversational queries. The position offers a competitive salary range of $200,000 to $240,000 annually, alongside comprehensive benefits like medical coverage, flexible time off, and workplace perks.

Qualifications

• 6+ years in data engineering with strong SQL and deep Snowflake expertise.
• Experience designing efficient, scalable analytical data models.

Responsibilities

• Build and own the canonical data models in Snowflake as the source of truth.
• Structure datasets for optimal performance with vendor AI tools.
• Explore and prototype integrations for conversational data querying.
• Eliminate shadow tables by serving team data needs proactively.
• Own the transformation layer (dbt) with rigorous testing.

Skills

SQL

Snowflake expertise

Data engineering

Job description

The Role

This role sits at the frontier of how AI consumes and acts on internal company data. You'll be the data layer for the entire company — a strategic partner to Finance, Marketing, Sales, Product, and Data Science — designing the clean, trusted datasets that power our AI tooling and ensuring every team can make decisions from a single source of truth. You'll explore how technologies like MCP can unlock self-serve AI data access across the org, and ensure that as we adopt new AI capabilities, our data is ready to meet them. The rest of the company's AI ambitions run through you.

What You'll Do

• Build and own the canonical data models in Snowflake that serve as Alchemy's company-wide source of truth — clean, queryable, and AI-ready
• Structure datasets so vendor AI tools perform optimally out of the box, with consistent schemas, rich semantics, and well-indexed access patterns
• Explore and prototype MCP integrations that let internal teams query data conversationally
• Eliminate shadow tables and one-off datasets by proactively serving team data needs at the platform level, freeing data science to move faster
• Own the transformation layer (dbt), with rigorous testing and validation so every downstream consumer — human or AI — can trust what they're working with

What We're Looking For

• 6+ years in data engineering with strong SQL and deep Snowflake expertise
• Experience designing efficient, scalable analytical data models

  Benefits & Perks

  • Medical, Dental, & Vision
  • Gym Reimbursement
  • Home Office Build-out Budget
  • In-Office Group Meals
  • Commuter Benefits
  • Flexible Time Off
  • Wellbeing & Mental Health Perks
  • Learning & Development Stipend
  • Company Sponsored Conferences & Events
  • HSA and FSA Plans
  • Fertility Benefits

  Compensation

  Alchemy is committed to offering competitive compensation, including base salary as well as equity. Additionally, Alchemy offers comprehensive medical, dental, and vision coverage, as well as other benefits such as 401k and unlimited flexible time off.

  The base salary range for this position is estimated to be between $200,000 - $240,000 annually. Please note this range reflects base salary only, and does not include bonus, equity, or benefits. Your salary will be determined by various factors, including relevant experience, skill set, qualifications, and other business needs.

  Compensation Range: $200K - $240K