Collin lee

Data Analyst

SF, CA, US

BigQuery

TensorFlow

Bash

Tableau

SQL

OpenAI API

PostgreSQL

Tensorflow

Keras

Python

Neo4j

Airflow

Cloud Storage

FastAPI

BASH

Java

Available for hire fromNegotiable

AI/ML & Data Engineering Intern | LLMs, Semantic Search, dbt/BigQuery/Snowflake

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.

Projects

NYC Taxi Analytics Pipeline on Google Cloud

● Built a BigQuery warehouse with bronze, silver, and gold tables scheduled daily in Dataform, producing trip facts, zone flows, vendor metrics, and quality snapshots ● Implemented schema contracts and assertion suites for nulls, allowed values, time gaps, and row deltas to protect downstream analyticsSee More

Code Vulnerability and Security Agent

● Built an evaluation framework that loads vulnerable and fixed Python functions and tests LLM agents on repairing real vulnerabilities ● Combined static analysis and sandboxed execution checks into one metrics pipeline scoring compilation, issue reduction, and closeness to a reference patch ● Shipped a FastAPI dashboard so users can run experiments and see live progress and side by side code comparisonsSee More

MedHive Medical Device Knowledge Graph QA

● Built a Python pipeline that parses FDA 510(k) PDFs into ontology aligned triples and loads a Neo4j graph with source evidence ● Designed Cypher query patterns and a natural language to query interface for device comparison questionsSee More

Work History

AI/ML Intern

UpliftyJun 2025 - Dec 2025 • 7 mos● 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

SHRMJul 2025 - Oct 2025 • 4 mos● 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)May 2025 - Aug 2025 • 4 mos● 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 TeamMay 2024 - Aug 2024 • 4 mos● Analyzed ad performance, sales, and inventory data in SQL and Excel to reallocate spend and refine reorder points

Education

University of California, Berkeley

B.A., B.A. in Data Science; B.A. in Economics2025

Carnegie Mellon University

Master of Science, Data Analytics for Science2027

How Pangea Works

Effortlessly discover top talent

We've distilled the candidate search from endless hours down to just a few minutes. Using Pangea's AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company's niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea's fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team's capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We've combined every part of the hiring process into one platform to eliminate the miscommunication that's unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call