Data Analytics Engineer

About this role

Join Alchemy as a Data Analytics Engineer to build the foundational data infrastructure powering company-wide AI initiatives. You'll design canonical data models in Snowflake, implement transformation pipelines with dbt, and enable self-serve AI data access across Finance, Marketing, Sales, Product, and Data Science teams.

What you'll do

• Build and maintain canonical data models in Snowflake serving as the company's single source of truth
• Design AI-ready datasets with optimal schemas and indexing for vendor AI tools
• Prototype and implement MCP integrations for conversational data querying
• Own the dbt transformation layer with rigorous testing and data quality validation
• Eliminate shadow datasets by proactively serving team data needs at platform level
• Partner strategically with cross-functional teams to unblock analytics and data science workflows

What they're looking for

• SQL and Snowflake (expert level)
• dbt or comparable transformation frameworks
• Analytical data modeling and schema design
• Data quality and validation practices
• MCP (Model Context Protocol) integration
• Communication and cross-functional collaboration
• Startup experience
• Data infrastructure and platform thinking

Benefits

• Medical, dental, and vision coverage
• Home office build-out budget
• Gym reimbursement
• Flexible time off
• Learning and development stipend
• Wellness and mental health support, HSA/FSA plans, fertility benefits