Data Analytics Engineer

Department: [New] Engineering

Location: San Francisco, New York

Compensation: $200K – $240K • Offers Equity • Offers Bonus

Employment Type: FullTime

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

• Proficiency with dbt or comparable transformation frameworks

• Strong data quality instincts and a track record of building infrastructure that unblocks teams

• Good judgment — you scope well, prioritize ruthlessly, and communicate tradeoffs

• Experience in startups, a plus

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

More on The Role

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.