Evan – Dagster, Snowflake, FastAPI, experts in Lemon.io

Evan

From United States (UTC-5)flag

Data Engineer|Middle-to-senior

Evan – Dagster, Snowflake, FastAPI

Evan is a Middle-to-Senior Data Engineer with strong end-to-end ownership of data platforms, specializing in Python, Snowflake, dbt, Dagster, and FastAPI. He has built and maintained production lakehouse architectures, delivered analytics APIs, and integrated AI agent workflows. Evan demonstrates clear communication, autonomy, and a product-focused mindset, with experience in crypto, DeFi, and marketplace domains.

5 years of commercial experience
Main technologies
Dagster
1.5 years
Snowflake
1.5 years
FastAPI
1 year
Data Modeling
3 years
Amazon S3
2 years
TimescaleDB
1 year
Additional skills
LLM
Python
API
SQL
CI/CD
DBT
MCP
AI agent development
Ethereum
AI benchmarking
AWS
Kubernetes
Rust
PostgreSQL
MCP Server
Pandas
ETL
Data Warehouse
Data Science
DeFi
ClickHouse
Direct hire
Possible
Ready to get matched with vetted developers fast?
Let’s get started today!

Experience Highlights

Data Engineer (Contract)
Apr 2026 - Ongoing7 months
Project Overview

Own the production data platform behind marketplace APIs end to end: multi-source Python ingestion into an Apache Iceberg/S3 lakehouse orchestrated by Dagster, incremental dbt transformations, real-time event streaming on Redpanda (Kafka), and a Postgres + FastAPI serving layer.

Responsibilities:
  • Owned and operationalized the production data path behind marketplace APIs, normalizing multi-source Python ingestion into an Apache Iceberg/S3 lakehouse with Dagster orchestration.
  • Designed and implemented real-time event streaming on Redpanda (Kafka-compatible), moving the platform from batch-only to streaming ingestion.
  • Led the migration of API serving from Iceberg/Parquet files to Postgres for low-latency reads, keeping Iceberg as the analytical source of truth.
  • Rebuilt the transformation layer with incremental dbt models, enforcing canonical grains, column-level lineage, schema guards and parity tests.
  • Built statistical data-quality controls for pricing data using bimodal-distribution detection.
  • Built a production AI-assisted analytics interface (Cursor Agent SDK) with guarded SQL execution and live-source fetchers.
Project Tech stack:
Python
SQL
API
DBT
Redpanda
Kafka
Dagster
PostgreSQL
FastAPI
Data Scientist
Jan 2025 - Apr 20261 year 3 months
Project Overview

Owned the Sui DeFi data platform end to end as the primary data partner to the Heads of Partnerships, DeFi and Treasury.

Responsibilities:
  • Designed and shipped the Sui DeFi data platform from zero: reverse-engineered on-chain schemas into dbt models orchestrated by Dagster on Snowflake, powering the KPIs for a $75M ecosystem incentives program.
  • Set the metric definitions (retention, growth, stablecoin adoption) that leadership used to steer incentive spend.
  • Architected governed LLM access to Snowflake via an MCP layer with SQL allowlists, row caps and caching, making production data safely queryable by AI agents.
  • Extended external coverage by integrating financial APIs into the warehouse through Dagster.
  • Took initiative upstream: shipped four Rust PRs to the DeepBook v3 indexer (event handlers, Postgres migrations, a portfolio read API) to fix data at the source.
Project Tech stack:
Snowflake
DBT
Dagster
SQL
MCP
AI agent development
Rust
Python
PostgreSQL
Applied Researcher
Nov 2023 - Jan 20251 year 2 months
Project Overview

Sole builder of the protocol's analytics platform, from warehouse design through published research.

Responsibilities:
  • Designed and built the analytics platform from scratch: Python ETL ingesting consensus, mempool and protocol event data into a self-managed Postgres/TimescaleDB warehouse, served via PostgREST and materialized views.
  • Turned transaction-level data into research on inclusion latency, censorship incentives and rollup reliability; the series won an Ethereum Foundation grant.
  • Developed an execution-quality measurement methodology, published in Frontier.
Project Tech stack:
PostgreSQL
Python
SQL
TimescaleDB
Pandas
Polars
Customer Data Analytics
Sep 2021 - Nov 20212 months
Project Overview

Customer Data Analytics at Dune Analytics (Fall 2021) — partnered with engineering on the technical roadmap from customer feature requests and feedback.

Responsibilities:

Partnered with engineering on the technical roadmap from customer feature requests and feedback.

Project Tech stack:
SQL

Education

2022
Mathematics, Applied Mathematics
Bachelor of Applied Science - BASc

Languages

Spanish
Advanced
English
Advanced

Hire Evan or someone with similar qualifications in days
All developers are ready for interview and are are just waiting for your requestdream dev illustration
Copyright © 2026 lemon.io. All rights reserved.