Home / My Work / WV Labor Market Site

WV Labor Market Site Modernization

2021–Present Sullivan Steele Public Data Platform
Data Engineering Public Sector Automation Python
Dashboard-style illustration showing labor market charts and county comparisons.
Modernized reporting workflows for West Virginia labor market data delivery.

Context

West Virginia's labor market website serves policy makers, employers, and residents with unemployment, wages, and workforce trend data. Legacy SAS-centric workflows made quarterly updates and troubleshooting slower than needed.

Role

I maintain core reporting pipelines, modernize legacy jobs, and support ongoing site reliability. I also handle migration planning from SAS scripts to Python-based ETL and reproducible reporting workflows.

Approach

Mapped legacy dependencies, prioritized high-friction reports, then incrementally replaced manual scripts with Python automation. Added validation checks, cleaner scheduling boundaries, and documentation so quarterly release cycles are easier to run and audit.

Public artifact: lmi.workforcewv.org

Technical Stack

Python · SAS · SQL · Scheduled ETL jobs · Public dashboard publishing · Data validation scripts

Outcome

50% faster quarterly refresh steps

for modernized report batches after migration to Python automation and validation tooling.

  • Reduced manual handoffs across recurring publication tasks.
  • Improved reproducibility for federal-source integrations (BLS, Census).

Lessons

Legacy modernization works best as a phased reliability program rather than a one-shot rewrite. Converting the most operationally painful reports first created momentum and immediate value for recurring publication cycles.