CHICAGO, IL · REMOTE
Data Engineer
Nonprofit platform helping students and young adults access education and financial opportunities; building the data foundation for the ASPECTS higher-education platform across 453 partner institutions. Consolidated 5TB+ of financial-aid data into a single Snowflake platform, added a Pydantic validation layer in CI that cut transformation errors 40%, and shipped a hybrid-retrieval RAG system over 1,000+ policy documents at 92% accuracy.
- Built a Databricks and Spark pipeline consolidating 5TB+ of financial-aid data from 453 institutional sources into Snowflake, replacing fragmented per-institution feeds with one trusted source and using Delta Lake staging to absorb schema drift before transformation into analytics marts.
- Reduced system-wide transformation errors 40% by adding a Pydantic validation layer to a Jenkins and GitHub Actions CI pipeline that rejects type mismatches and null violations before data reaches Snowflake.
- Designed a hybrid RAG pipeline (dense vectors plus BM25 with reranking) on multi-region AWS that answers questions across 1,000+ financial-aid policy documents at 92% accuracy, provisioned with Terraform.