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
API
LLM
SQL
Python
CI/CD
MCP
AI agent development
DBT
Ethereum
AI benchmarking
AWS
Kubernetes
PostgreSQL
Rust
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 - Ongoing6 months
Project Overview

A production data platform powering marketplace APIs, with multi-source Python ingestion normalized into an Apache Iceberg/S3 lakehouse, orchestrated by Dagster and served via FastAPI. The platform includes incremental SQLMesh transformations with canonical grains, column-level lineage, schema guards, and parity tests, as well as statistical pricing data-quality controls and an AI-assisted analytics interface with guarded SQL execution and live-source fetchers.

Responsibilities:
  • Owned and operationalized the production data path behind marketplace APIs, normalizing multi-source Python ingestion into Apache Iceberg/S3 through Dagster orchestration and FastAPI serving;
  • Rebuilt the production transformation layer with incremental SQLMesh models in dbt syntax, enforcing canonical grains, 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 with the Cursor Agent SDK, including guarded SQL execution and live-source fetchers.
Project Tech stack:
Python
SQL
API
DBT
Data Scientist
Jan 2025 - Apr 20261 year 3 months
Project Overview

A data and analytics platform for the Sui blockchain ecosystem, providing DeFi datasets, dashboards, and governed cross-source analytics. The platform supported KPI tracking for a $75M ecosystem incentives program and extended DeepBook v3 indexing and portfolio data access through event handling, Postgres migrations, and a read API.

Responsibilities:
  • Built Sui DeFi datasets and dashboards from zero to one using dbt + Dagster pipelines in Snowflake;
  • Defined KPIs for a $75M ecosystem incentives program;
  • Served as the primary data partner to Heads of Partnerships, DeFi, and Treasury;
  • Shipped an MCP server with SQL allowlists and row caps for governed cross-source analytics;
  • Extended the DeepBook v3 indexer through four self-initiated Rust PRs covering event handlers, Postgres migrations, and a portfolio read API.
Project Tech stack:
Snowflake
DBT
Dagster
SQL
MCP
AI agent development
Applied Researcher
Nov 2023 - Jan 20251 year 2 months
Project Overview

A protocol analytics platform for Ethereum market-structure research, focused on inclusion latency, censorship incentives, and rollup reliability. The platform supported execution-quality measurement through Python-based ETL pipelines and time-series analytics in Postgres/Timescale.

Responsibilities:
  • Conducted Ethereum Foundation grant-funded market-structure research on inclusion latency, censorship incentives, and rollup reliability;
  • Built the protocol analytics stack from scratch, including Python ETL into Postgres/Timescale;
  • Published an execution-quality measurement methodology.
Project Tech stack:
Ethereum
Data analysis
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.