Jeffrey Pan

Data Specialist @VIA

Somerville, MA, US

Clean, transform, and standardize raw customer data into relational databases using SQLAlchemy ORM for structured schema management- Design, build, and maintain end-to-end ETL pipelines with Dagster, integrating data from diverse sources via REST API endpoints- Collaborate across teams to resolve data quality issues and ensure accuracy of utility bill and energy data, incorporating customer feedback to refine deliverables-Develop and enhance interactive Streamlit visualizations, dashboards, and reports that translate utility bill data into actionable insights for external clients

Northeastern University

Bachelor's degree

Khoury College of Computer Sciences

Bachelor's degree

Reading Memorial High School

High School Diploma

Northeastern University College of Science

Bachelor's degree