Jack Stehn

Data & Analytics Engineer

San Francisco, California • jack@ste.hn

Download PDF

Summary

Data & Analytics Engineer who builds the pipelines, warehouses, and models that turn messy, multi-system data into numbers people trust. I've designed modern data stacks (Dagster, dbt, dlt, BigQuery) end to end, from ingestion and data quality checks to the semantic layers, dashboards, and production ML models stakeholders rely on. I bring a software engineering mindset—CI/CD, testing, and modular design—so data systems stay maintainable, observable, and useful.

Experience

Data Engineer / Customer Delivery Engineer (Contract)

Innovare · Chicago, Illinois (Remote)

Mar 2026 — Present
  • Pipeline Reliability: Own the stability and scalability of production data pipelines feeding high-stakes EdTech dashboards, ensuring datasets remain accurate and auditable for enterprise school district customers.
  • Medallion Architecture Design: Co-designing a transition to a Medallion (bronze/silver/gold) data architecture on BigQuery, defining layer contracts, freshness SLAs, and lineage to improve traceability and downstream analytics velocity.
  • Modern Stack Advocacy: Proposed adopting Terraform (IaC), dlt (ingestion), dbt (transformation), Dagster (orchestration), Cube.js (semantic layer) to replace ad-hoc workflows — enabling version control, automated testing, and unified observability across the platform.
  • Workflow Automation: Replacing manual customer delivery workflows with automated, idempotent pipelines, reducing turnaround time and eliminating recurring sources of data drift between systems.
  • Cross-System Integration: Manage complex data flows across disparate EdTech sources, designing for schema evolution, late-arriving data, and the operational realities of multi-tenant customer delivery.

Data Scientist (Lead: Data Engineering, MLOps) - Ed Pioneers Fellow

Caliber Public Schools · Richmond, California

Sep 2024 — Oct 2025
  • Modern Data Stack Architecture: Architected and built a scalable platform on GCP. Orchestrated ELT pipelines using Dagster, dbt, and dlt to ingest data from disparate SIS (School Information Systems) and HR platforms into BigQuery.
  • Engineering Maturity (ROI): Engineered a comprehensive People Team data pipeline, reducing manual consistency checks from months of collective annual work to seconds. Built a custom automated data quality framework to catch inconsistencies between systems.
  • API Integration & Interoperability: Solved complex data interoperability challenges by designing integrations between Schoolmint and PowerSchool. Reverse-engineered undocumented APIs to create a unified data model for cross-functional analysis.
  • Solo Data Lead: Owned the full data lifecycle as the sole data professional, partnering directly with C-suite and department heads to move the org from manual spreadsheets to automated warehousing.
  • Predictive Modeling: Built and deployed an explainable staff-turnover model (Logistic Regression, Deep Learning) with a tunable risk threshold so leadership could match precision/recall to hiring capacity.

Data Scientist (Data Engineering, MLOps)

SetSail · San Mateo, California

Aug 2021 — Feb 2023
  • Pipeline Architecture (AWS): Led a critical overhaul of the AWS data infrastructure (S3, Athena, EMR). Implemented 'SQL Push-down' strategies and asynchronous DAGs, reducing data processing latency by 75% and scaling to multi-terabyte datasets.
  • Scalable Data Modeling: Architected scalable Star Schema data models and optimized ETL/ELT processes, ensuring data readiness for ML and LLM integration.
  • Engineering Best Practices: Championed the adoption of CI/CD pipelines (GitHub Actions), unit testing (pytest), and Agile methodologies within the data science team.
  • Business Impact: Contributed to infrastructure enhancements that achieved 33% faster ramp times, 16% higher revenue, and 15x ROI for customers.
  • Production ML: Developed and deployed propensity scoring and churn models, using NLP on unstructured email metadata to surface sales signals.

Education

University of California, Berkeley

Bachelor of Arts in Data Science (Domain Emphasis: Quantitative Social Science)

GPA: 4.00/4.00

Highest Distinction (Summa cum laude). Outstanding Data Science Undergraduate Award (Top of Class).

Aug 2019 — May 2021

Skills

Data Engineering & Cloud Platforms

AWS Cloud (EC2, S3, Lambda, Athena)GCP Cloud (BigQuery, GCS)Data Pipelines (Dagster, dbt, dlt)Data Warehousing (BigQuery, Athena)Database Modeling (Star, Snowflake)ETL/ELT Design & ImplementationAPI Design & IntegrationDocker & ContainerizationMLOps Principles & Tools

Programming & Core Data Skills

Python (Pandas, NumPy, SciPy)SQL (PostgreSQL, BigQuery)RBash/Shell ScriptingFeature EngineeringUnstructured Data Analysis

Machine Learning

Predictive Modeling (Scikit-learn)Classification & RegressionExplainable MLModel Eval & SelectionNLP (spaCy, HuggingFace)

Software Engineering & DevOps Practices

Production Code Quality/PracticesObject-Oriented Programming (OOP)Software Design PatternsTesting (Unit, Intg, E2E, Pytest)CI/CD Pipelines (GitHub Actions)Version Control (Git, GitHub)Agile Methods (Scrum, Kanban)Code Review & Collaboration

Data Visualization & BI Tools

Plotly (Dash for web apps)TableauLooker StudioInteractive Dashboard DesignBusiness Intelligence Reporting

Familiar Technologies & Other Tools

JavaJavaScriptHTML/CSSDatabases (PostgreSQL, MySQL)Web Scraping (Beautiful Soup, Selenium)Apache Spark (PySpark basics)Jupyter Notebooks & Lab

Awards

2020-2021 Outstanding Data Science Undergraduate Award

UC Berkeley

Recognized for excellence in Data Science undergraduate studies, research, and community contributions at UC Berkeley.

May 2021

Volunteer & Community

Impact Fellow (Placement @ Caliber Public Schools)

Education Pioneers

Sep 2024 — Oct 2025

Selected for national fellowship applying leadership/management skills to advance educational equity via capacity-building projects.

  • Capacity Building: Building organizational capacity through strategic data engineering projects at placement site.

Data Team Lead

San Francisco Gay Men's Chorus

Dec 2023 — Present

Provide data-driven insights for policy-making and organizational growth through survey creation and analysis (qualitative & quantitative).

  • Team Leadership: Led volunteer team providing data analysis for organizational strategy.
  • Survey Analysis: Designed & analyzed surveys (qual/quant) informing policy & growth.
  • Executive Presentation: Presented data-driven insights to chorus leadership.

Mentor and Trans Support Leader

San Francisco Gay Men's Chorus

Jan 2018 — Present

Support members through mentorship and leadership within trans support initiatives, coordinating meetings and events.

  • Peer Mentorship: Provided mentorship and peer support to chorus members.
  • Community Leadership: Led coordination for trans member support group meetings and events.
  • Inclusive Culture: Contributed to fostering an inclusive environment within the organization.