Skip to main content

Courtney Youngberg · Data, Automation & Analytics

I turn messy data and manual processes into useful systems.

Senior research analyst with experience across higher education, healthcare technology, customer operations, clinical research, and public safety data. I build analytics, automations, data products, and decision-support tools that bridge technical systems and business needs.

Flagship project · Live product

Equity Gap Calculator

Translating complex statistical methodology into an accessible decision-support application for higher education practitioners.Built on the California Community Colleges Chancellor’s Office PPG-1 methodology — statistical thresholds, insufficient-data handling, and gap-closing estimates included, not skipped.

  • Live Product
  • Statistical Methodology
  • Data Import
  • Interactive Analysis
File uploadCSV · .xlsx · .xlsPasted dataExcel / table pastePre-aggregatedgroup countsAuto-detectionheader mappingValidation &normalizationPPG-1 enginethresholds · min-n · gapsSimple resultsplain languageTechnical resultsrates · gaps · nExport · PrintExcel · share
From messy institutional exports to defensible equity findings.

Selected impact

Real numbers from real work

No vanity metrics — each of these is a specific, verifiable outcome from a project on this site.

300+
program websites processed in PSLO automation
300+
Excel workbooks generated automatically
~2 months
of manual effort saved in one cycle
~1,600
courses in the annual DoD TA XML workflow
~70
online programs identified for institutional review
0.719
ROC AUC, interpretable retention model

What I do

Four verbs, one job

The through-line across ten years and five industries: find the manual, messy, or ambiguous thing — and turn it into a system.

Analyze

SQL, statistics, dashboards, and modeling — turning raw records into answers people can act on.

  • SQL & Snowflake
  • Statistical analysis
  • Power BI & Tableau
  • Predictive modeling

Automate

Python, workflows, and data processing — replacing months of manual effort with reliable pipelines.

  • Python automation
  • Web scraping & Selenium
  • Excel automation
  • Workflow design

Build

Data tools, decision-support products, and integrations that people actually use.

  • Data products
  • Decision-support tools
  • APIs & XML pipelines
  • Dashboards

Translate

Business needs into technical solutions — requirements, documentation, and stakeholder alignment.

  • Requirements analysis
  • Process mapping
  • Documentation
  • Stakeholder communication

Selected projects

Case studies, not screenshots

All projects →
  • AutomationBusiness AnalysisAnalytics

    PSLO Automation System

    Institutional research, California community college

    A Python pipeline that collects and structures program learning-outcome information from 300+ program websites and generates 300+ formatted Excel workbooks — replacing roughly two months of manual copy-paste effort and removing the anticipated need for temporary staffing.

    program websites processed
    300+ program websites processed
    Excel workbooks generated
    300+ Excel workbooks generated
    manual effort saved
    ~2 months manual effort saved

    Read the case study

  • AutomationAnalyticsData ScienceIntegration

    Certificate Eligibility Discovery Pipeline

    Retention research, Coastline College

    Scraped hundreds of public program and course pages with Python and R, structured the certificate requirements, joined them against student records with SQL, and applied business-rule matching — identifying hundreds of potentially eligible students and feeding an operational outreach effort.

    Read the case study

  • Data ScienceAnalytics

    Student Success & Retention Modeling

    Retention research, Coastline College

    Built interpretable logistic-regression models to support student success and outreach work. The model reached ROC AUC ≈ 0.719, and held ROC AUC ≈ 0.679 on outreach validation — reported with limitations, not as a magic score.

    ROC AUC
    0.719 ROC AUC (interpretable model)
    ROC AUC
    0.679 ROC AUC (outreach validation)

    Read the case study

Professional journey

Five domains, one common thread

Cross-domain range is the point, not a detour: every one of these environments involved high-stakes data, messy systems, and stakeholders who needed translation.

  1. 01

    Public Safety Data

    9-1-1 database work — where a wrong record isn't a typo, it's a failed emergency response.

  2. 02

    Clinical Research

    Clinical research data roles — protocol-driven collection, validation, and documentation.

  3. 03

    Healthcare Technology

    Data services leadership at Kareo — moving practice data into and out of regulated systems at scale.

  4. 04

    Customer Success Operations

    Technology operations at Tebra — Snowflake, Salesforce, Gainsight, and the reporting that runs a CS org.

  5. 05

    Higher Education Analytics

    Institutional research at Coastline College and Orange Coast College — equity analytics, automation, and decision support.

Have a messy process or an unanswered data question?

That’s my favorite kind of email. I’m open to conversations about analytics, automation, and data product roles.