Workforce & Labor Market Analytics
Analyzed regional labor gaps, workforce demand, and program outcomes to support cross-campus planning and a successful $2M statewide manufacturing pipeline initiative.
Case study
Career Services Strategy & Operations Analytics
Analytics and reporting work supporting workforce development, program lifecycle management, operational decision-making, and institutional strategy at SDSU Career Services.
Outcomes
- Led workforce analytics for a successful $2M CSU initiative, analyzing regional labor gaps, program outcomes, and workforce development needs across multiple campuses.
- Rebuilt 2 years of fragmented program lifecycle data across 761K+ records and 100+ files into a centralized reporting pipeline for program tracking and leadership reporting.
- Reduced manual reconciliation by standardizing reporting logic, KPI definitions, and data documentation across fragmented operational exports.
- Created decision-ready outputs for leadership, supporting cross-campus planning, internal operations, employer engagement, and program evaluation.
Problem
Career Services data was spread across multiple systems, service lines, exports, and reporting conventions. Leadership needed clearer ways to understand program activity, employer engagement, student support, labor market demand, and workforce development outcomes.
The challenge was both strategic and operational: translate fragmented data into a reporting structure that could support planning conversations, grant-related analysis, KPI tracking, and recurring leadership review.
Approach
- Consolidated fragmented exports into reporting-ready datasets with repeatable cleaning and transformation logic.
- Defined standardized KPI logic across appointments, programs, employer engagement, platform usage, opportunities, and outcomes.
- Analyzed regional labor market demand and program alignment to support a statewide workforce development proposal.
- Built documentation and data dictionaries to reduce ambiguity and improve reporting consistency.
- Translated technical analysis into leadership-ready outputs for planning, resource allocation, and program evaluation.
Strategic value
The work turned disconnected operational data into a more usable decision system. Instead of relying on one-off manual reconciliation, teams gained a clearer structure for understanding what was happening across programs, where activity was concentrated, and how data could support planning conversations.
Workstreams
Program Lifecycle Reporting
Rebuilt fragmented program lifecycle data across 761K+ records and 100+ files into a centralized reporting pipeline for tracking programs, activity, and outcomes.
KPI Standardization
Defined consistent reporting logic for appointments, events, employer engagement, platform adoption, job postings, and student outcomes.
Leadership Reporting
Translated operational data into decision-ready summaries, reporting structures, and outputs designed for leadership review and planning conversations.
KPI groups
Student Support
- Completed appointments
- Students served
- Appointment types
- Modality trends
Programs & Events
- Orientations and presentations
- Workshop attendance
- Event participation
- Employer engagement at events
Employer Development
- Approved employers
- New employer contacts
- Employer orientations
- Event participation
Platforms & Opportunities
- Platform logins
- Profile completion
- Job postings
- Openings and job types
Why this matters
This project reflects the kind of work I want to keep building toward: using analytics not just to describe activity, but to improve how organizations plan, prioritize, and execute. The value was not only in cleaning data or producing reports. It was in creating a more reliable structure for decision-making.
Note: code and raw artifacts are intentionally not public due to institutional data sensitivity. This case study focuses on workflow design, KPI logic, strategic context, and decision-support structure.