Skip to content

Data engineer and analyst. I build pipelines, warehouses, and Power BI reports. At EDC Lancaster County I turn federal data (BLS, BEA) into dashboards that refresh daily.Mail tracks vacancy overall (r = 0.77), not in one county USPS mail data vs Census vacancy: r is 0.77 pooled and −0.01 in one county. Read the case study.Model error 13.1% on random folds, 18–38% on a new region Melbourne housing: tested on regions the model never saw. Read the case study.Data Analyst Fellow, EDC Lancaster County · B.A. Computer Science, Franklin & Marshall College · GPA 3.72SQL · Python · Power BI · DAX · Microsoft Fabric · scikit-learn

ThanhVu

Portrait of Thanh Vu
Lancaster, PA

Data engineer
& analyst

See my work

About

About me

Now
Data Analyst Fellow, EDC Lancaster County
Education
B.A. Computer Science, Franklin & Marshall College, Magna Cum Laude
Certified
Fabric Data Engineer Associate (DP-700)
Based in
Lancaster, PA

At EDC Lancaster County I turn federal data from BLS, BEA, Census, and USPS into Power BI reports that refresh every day, so staff can brief officials and investors without rebuilding a spreadsheet first.

In personal projects I build the same way: land raw data once, clean it, test it, model it. Projects include a 131M-row SQL Server warehouse and a Fabric pipeline.

Warehouse
131M+ transaction lines
Vacancy study
84 county-years, 6 counties
Model testing
13,580 Melbourne sales

Selected work
10 projects in total

Selected work

  1. Can Mail Data Predict Housing Vacancy?Data engineering · 2026
  2. Grocery Transaction Data WarehouseData engineering · Jul–Aug 2025
  3. Can a Model Nowcast Census Vacancy from Mail Data?Machine learning · Oct 2026
  4. Sales Planning AnalysisAnalytics · Aug 2025
  5. Medical Cost Modeling and PredictionMachine learning · Oct 2026
  6. Lancaster County Economic IndicatorsAnalytics · 2026
See all 10 projects

Skills
Each group links to proof

Skills

  • 01

    Data engineering

    • SQL (T-SQL)
    • Python (pandas)
    • PySpark and Spark SQL (DP-700 study)
    • ETL / ELT pipelines
    • Medallion architecture
    • Dimensional modeling (star, galaxy)
    • Stored procedures
    • Data-quality testing
    Seen inGrocery data warehouse
  • 02

    Analytics & BI

    • Power BI
    • DAX
    • Power Query M
    • KPI and report design
    • Excel (pivot tables, lookups)
    • Matplotlib
    • R (ggplot2)
    Seen inSales planning analysis
  • 03

    Machine learning

    • scikit-learn
    • Regression and statistical inference
    • Cross-validation and evaluation design
    • Gradient boosting
    • Conformal prediction intervals
    Seen inVacancy nowcast
  • 04

    Software engineering

    • Python
    • C++ (coursework)
    • JavaScript (Apps Script)
    • Git / GitHub
    • Testing with pytest
    • Algorithms and data structures (coursework)
    • Models written from scratch (NumPy)
    Seen inVacancy nowcast tests
  • 05

    Platforms

    • Microsoft Fabric
    • Lakehouse
    • Warehouse
    • Dataflow Gen2
    • Notebooks
    • SQL Server
    • MySQL (Netflix titles ETL)
    • SQLite
    • Power Automate
    • Google Sheets / Apps Script
    Seen inCan mail data predict housing vacancy?

Experience

Experience

  1. Aug 2026 – Present
    Lancaster, PA

    Data Analyst Fellow

    EDC Lancaster County, Center for Regional Analysis

    Replaced manual downloads of CSV and Excel files from national websites with automated ingestion of 25+ federal economic series from BLS and BEA public APIs, plus pipeline checks that validate the numbers.

    • Power BI
    • DAX
    • BLS / BEA APIs
    • Google Apps Script
    • Gemini
  2. Jan 2026 – May 2026
    Sheridan, WY

    Data Science Intern

    KCC Capital Partners

    Collected and integrated data on 100+ precious-metal and mining companies, markets, and transactions into one dataset to enrich the firm’s AI agent for investment, and enriched 500+ contact records with Seamless.AI for deal sourcing.

    • Excel
    • Seamless.AI
    • Data collection
  3. Sep 2021 – Sep 2022
    Lancaster, PA

    Technology Support Assistant

    Quantitative Science Center, Franklin & Marshall College

    Resolved technical incidents for classroom and lab computers and kept classroom systems running.

    • IT support
    • Imaging
  4. Jan 2021 – Apr 2021
    Hanoi, Vietnam

    Data Engineer Intern

    KPIM Joint Stock Company

    Built ETL pipelines in Python (Pandas, NumPy) and SQL Server that automated legacy client data workflows and reduced processing time, and modeled the data in star and galaxy schemas so Power BI could use related tables instead of flat Excel and CSV files.

    • Python
    • Pandas
    • SQL Server
    • Power BI

Franklin & Marshall College

Education · B.A. Computer Science, May 2026. GPA 3.72. Magna Cum Laude.

Coursework and projects

Fabric Data Engineer Associate

Certification · Microsoft, Oct 2026

Credential ID 5CE20E8CF4AC4CE3

SQL (Advanced) Certificate

Certification · HackerRank, Sep 2025

View full resume

Contact

Get in
touch

Questions about my work, a project, or a role? Use whichever is easiest.

vulethanh07112002@gmail.com
Esc

↑ ↓ to moveEnter to open