About 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
• Design efficient, scalable analytical data models that support company-wide analytics and AI initiatives
• Partner with cross-functional teams to translate business requirements into robust data infrastructure

Requirements

• 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 with AI-optimized data structures and schemas
• Ability to work cross-functionally with Finance, Marketing, Sales, Product, and Data Science teams

Compensation & Benefits

• Compensation: Competitive base salary plus equity
• Location: New York, NY or San Francisco, CA (Hybrid)
• Employment Type: Full-time, permanent position
• Benefits: 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, 401k, Unlimited PTO

Impact

As Alchemy's strategic data infrastructure owner, you'll enable AI-driven decision making across all functions. Your work directly powers the company's AI tooling and ensures every team can operate from clean, trusted datasets. You'll be at the forefront of implementing cutting-edge technologies like MCP (Model Context Protocol) for conversational data access, positioning Alchemy at the leading edge of AI-integrated data operations.