Los Angeles, CA · Open to work

Joseph Heupler

Software Engineer

Data pipelines, BI systems, and revenue operations — SQL, Power BI, Salesforce. UC Berkeley Data & Cognitive Science.

Brio Water Technology

About

Data systems that drive revenue ops.

I'm a Software Engineer focused on building data systems that make operations and revenue easier to understand and act on.

dbt, SQL/Python ETL/ELT, and governed KPI models across CRM, ERP, and eCommerce

Power BI (DAX, Power Query), Salesforce, and automated reporting for executive decision support

Salesforce, Sage 100, Shopify, Gorgias, and Aircall unified into clean operational datasets

Looking for software engineering, data engineering, and business systems roles where I can keep building practical, high-impact data infrastructure.

Experience

Sep 2025 — Present/City of Industry, CA

Designed and maintained a centralized dbt data layer integrating Salesforce, Sage 100 ERP, Shopify, Gorgias, and Aircall for revenue, backlog, QA, and ops reporting
Built and governed analytics models with standardized KPI definitions across CRM, ERP, eCommerce, telephony, and support data
Engineered scheduled SQL/Python ETL/ELT pipelines with orchestration, monitoring, validation, and lineage controls
Implemented data quality checks across 100K+ wholesale invoices — 70% less manual reporting time
Developed Power BI dashboards (DAX, Power Query) for real-time KPIs, backlog visibility, and executive decision support
Built AI-assisted knowledge workflows with LLM APIs, RAG, embeddings, and vector search for support ops
Automated reporting with Power Automate and Excel Online; designed QA analytics that cut performance variance by 51%
Systems reduced reconciliation time by 70% and unnecessary product replacements by 18–32%

NavAR

Jun 2024 — Sep 2025/Remote, USA

Owned navigation analytics by instrumenting ARKit and beacon map lifecycle events into measurable KPIs
Built SQL ETL/ELT pipelines from Firebase into a warehouse for release-, venue-, and device-level analysis
Developed dbt models across staging, fact, and dimension layers for relocalization, map quality, and navigation reliability
Orchestrated Airflow workflows for ingestion, dbt transforms, validation, and reporting refreshes
Built dashboards and performance tooling to monitor regression risk by app version, location, and device
Integrated Jenkins and GitHub Actions with release validation and post-launch monitoring

May 2022 — Sep 2022/Berkeley, CA

Built full-stack web app with Node.js, React, and REST APIs for dynamic data-driven UIs
Developed Flask microservice for NLP sentiment analysis with NLTK
Proposed AI-driven automation workflows for local clinics — 10+ hours/week less manual communication
Integrated backend services and frontend components for end-to-end data processing

Projects