Looking for a job

Justin Lo

@justinlo

Message

I build SQL-validated KPI reporting workflows that turn operational data into actionable insights.

United States

Message

What I'm looking for

I'm looking to apply SQL, KPI reporting, data validation, and operational analysis to help teams improve performance, diagnose trends, and make evidence-backed decisions.

At UPenn’s Price Lab for Digital Humanities, I built SQL validation workflows across 11,500+ works and 2,300+ authors, improving data integrity through normalized records, entity matching, and repeatable quality checks.

I’ve also translated user research into healthcare-navigation workflows at K-are and built reporting tools for digital analytics and fraud-risk monitoring using SQL, Excel, Tableau, Python, and Streamlit.

Experience

Work history, roles, and key accomplishments

Research Data Analyst

Price Lab for Digital Humanities, University of Pennsylvania

Feb 2023 - Aug 2026 (3 years 6 months)

Built a structured SQL validation workflow for a research database spanning 11,500+ works, 2,300+ authors, and 148 Norton Anthology volumes. Improved entity resolution and data integrity by maintaining author alias mappings and validating candidate matches.

SQL Data Validation Data Cleaning Entity Resolution Excel Tableau Reporting

Operations & Product Support

K-are

Mar 2025 - Jul 2025 (4 months)

Mapped user-research findings into 3 healthcare-navigation workflows and defined usability and performance metrics across 5 evaluation areas. Bridged operations and UI execution by converting user feedback into workflow documentation and maintaining a KPI dashboard.

KPI Dashboards Workflow Documentation Usability Metrics Stakeholder Reporting Product Support

Marketing Analyst Intern

Monit Corporation

May 2023 - Aug 2023 (3 months)

Benchmarked cross-market product performance by comparing 26 smart-diaper products across 12 competitors in 5 Asian markets. Reduced manual review time by an estimated 30% by designing a repeatable Excel reporting workflow.

Excel Pivot Tables XLOOKUP Sumifs Market Benchmarking Pricing Analysis Reporting