0.77Pooled correlation (−0.01 in one county)
Open dashboardData 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.I build data pipelines, warehouses, and Power BI reports. At EDC Lancaster County I turn federal data (BLS, BEA) into star-schema 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

Data engineer
& analyst
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
131M+Transaction lines loaded
Read case study1.02 vs 1.05MAE: last year vs ridge, gap not distinguishable
Read case study91.7%of the 2022 plan reached, chain-wide
Open dashboard0.09 → 0.86R², in-sample (age + sex → full model)
Read case study$41K → $59.5KAvg. private pay, 2014–2024 (not inflation-adjusted)
Open dashboard- Can Mail Data Predict Housing Vacancy?Data engineering · 2026
- Grocery Transaction Data WarehouseData engineering · Jul–Aug 2025
- Can a Model Nowcast Census Vacancy from Mail Data?Machine learning · Oct 2026
- Sales Planning AnalysisAnalytics · Aug 2025
- Medical Cost Modeling and PredictionMachine learning · Oct 2026
- Lancaster County Economic IndicatorsAnalytics · 2026
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
- 02
Analytics & BI
- Power BI
- DAX
- Power Query M
- KPI and report design
- Excel (pivot tables, lookups)
- Matplotlib
- R (ggplot2)
- 03
Machine learning
- scikit-learn
- Regression and statistical inference
- Cross-validation and evaluation design
- Gradient boosting
- Conformal prediction intervals
- 04
Software engineering
- Python
- C++ (coursework)
- JavaScript (Apps Script)
- Git / GitHub
- Testing with pytest
- Algorithms and data structures (coursework)
- Models written from scratch (NumPy)
- 05
Platforms
- Microsoft Fabric
- Lakehouse
- Warehouse
- Dataflow Gen2
- Notebooks
- SQL Server
- MySQL (Netflix titles ETL)
- SQLite
- Power Automate
- Google Sheets / Apps Script
Experience
Experience
Aug 2026 – Present
Lancaster, PAData 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.
Jan 2026 – May 2026
Sheridan, WYData 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.
Sep 2021 – Sep 2022
Lancaster, PATechnology Support Assistant
Quantitative Science Center, Franklin & Marshall College
Resolved technical incidents for classroom and lab computers and kept classroom systems running.
Jan 2021 – Apr 2021
Hanoi, VietnamData 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.
Franklin & Marshall College
Education · B.A. Computer Science, May 2026. GPA 3.72. Magna Cum Laude.
Coursework and projectsFabric Data Engineer Associate
Certification · Microsoft, Oct 2026
Credential ID 5CE20E8CF4AC4CE3
SQL (Advanced) Certificate
Certification · HackerRank, Sep 2025
Contact
Get in
touch
Questions about my work, a project, or a role? Use whichever is easiest.
vulethanh07112002@gmail.com