Collin lee
AI/ML & Data Engineering Intern | LLMs, Semantic Search, dbt/BigQuery/Snowflake
2 yrs experience · San Francisco, CA · <10 hrs/week
About
Data science and analytics professional focused on AI/ML and data engineering. Built LLM services with semantic search and change history, implemented ETL/ELT pipelines and dbt modeling with warehouse-backed analytics, and delivered product/event logging data foundations for reliable cohort and product analytics. Experienced with Google Cloud/BigQuery, Snowflake, Airflow, Dataform, Looker, and LLM tooling (OpenAI/Anthropic/Gemini) alongside FastAPI-based evaluation dashboards.
Skills
Experience
- AI/ML Intern · Uplifty06-01-2025 – 12-31-2025
● Built an LLM service and data pipeline to refresh large batches of knowledge base content under compute and budget constraints ● Added semantic search using pgvector and full change history so editors can audit suggestions and roll back changes ● Optimized batching, scheduling, and caching for model calls and added latency + failure rate monitoring
- Contract Consultant · SHRM07-01-2025 – 10-31-2025
● Defined what the product should track for signup, onboarding, and key user actions, then partnered with the developer to implement clean, consistent event logging ● Built a Python and SQL pipeline to land those events in a warehouse, modeled them in dbt, and added data tests so product analytics and cohort views are reliable for the team
- Contract Data Engineer Consultant · Parker Dewey (JLP)05-01-2025 – 08-31-2025
● Automated a weekly ETL pipeline ingesting and cleaning sales and circulation data into Snowflake using Python and Airflow ● Built dbt models and Looker dashboards that surfaced order patterns and circulation issues for print run and purchasing decisions ● Built product event logging requirements with stakeholders, implemented consistent tracking, and landed events in a warehouse with dbt modeled tables and data tests
- Summer Intern · The Clean Team05-01-2024 – 08-31-2024
● Analyzed ad performance, sales, and inventory data in SQL and Excel to reallocate spend and refine reorder points
Education
- University of California, BerkeleyB.A., B.A. in Data Science; B.A. in Economics
- Carnegie Mellon UniversityMaster of Science, Data Analytics for Science
Similar talent on Pangea
Hire Collin through Pangea
Describe your project to the Pangea agent — see if Collin is a fit, with transparent pricing and interviews booked straight onto your calendar. No contact details change hands until you hire.
See if Collin is a fit