Michelle Lee

Michelle Lee

Data engineer in Los Angeles

I build the pipelines that move orders, returns and product data between Shopify, JD Edwards and Oracle at AG Jeans, and I run the CI platform those pipelines are scheduled on.

See my projectEmail me
Illustrated portrait of Michelle
Portrait by DJARN

What I do at work

AG Jeans designs its clothing, makes some of it in-house and sources most from vendors, then sells online, in its own stores and wholesale. Here’s how its data connects, and the parts I build and run.

Keep every order flowingOrders, cancellations and returns from our two online stores and our retail stores reach the warehouse correctly.

Online and retail orders each run on their own integrations, along with catalog and inventory updates going back to the stores. I own all of them, and rebuilt the returns and exchanges process when the company switched returns providers.

Shopify, JD Edwards, Oracle Integration Cloud

Keep product data consistentStyles, pricing and seasons match between the design team’s system and the business system.

These syncs run in both directions and are among our most complex automations. Sales and product data are also copied into a reporting database, set up so a rerun never creates duplicates.

Python, SQL, PolyPM, SQL Server, Oracle Autonomous Database

Connect the apps the business usesThird-party apps that support different sides of the business stay in sync with our systems.

Wholesale orders from department-store partners are imported from order files into the business system. In-store traffic data lands in the reporting database. New-customer forms load straight into the business system. I also build custom syncs for very specific data other teams rely on.

Python, REST APIs

Run the automation platformI manage the platform our scheduled jobs run on.

That covers who has access, where the code lives and shared pipeline templates. As part of a small team, I helped move 28 automations off an aging integration tool and rewrite them in Python.

GitLab, GitLab CI, Linux

Watch every scheduled jobOne app shows whether each job is turned on and when it last finished successfully.

Our jobs are scheduled across several systems, and GitLab only shows schedules one project at a time. I built a monitoring app that brings them all into one view.

GitLab, Oracle Cloud Infrastructure

Build new internal appsI’m building an app to support the company’s move to vendor-made clothing.

It’s built in Oracle APEX, the modern option we’re adopting for new business tools.

Oracle APEX, SQL

Train the teamI’m the go-to person for our code and platform, and I write the training.

That includes primers and hands-on exercises for Oracle Integration Cloud, the one part of our stack where AI coding tools can’t help.

Oracle Integration Cloud, AI-assisted coding

Outside work

A pipeline I’m building on my own time, held to the same standards as the ones I run at work.

Budget Pipeline

In progress

Python · DuckDB · dbt · Prefect

Shopping is my most expensive hobby. My bank only shows an Amazon charge as a single total, so I’m building a pipeline that matches each charge to the items in the order emails. The goal is to see exactly where my money goes and set spending limits I’ll actually keep.

  • Done Raw, staging and mart layers in DuckDB, built by dbt with 18 passing tests, run end to end by a Prefect flow and verified rerun-safe on synthetic data.
  • Next Connecting the live bank (SimpleFIN) and Gmail extractors, then scheduling it.
Read the case study

Experience

  1. Dec 2023 – nowData EngineerKoos Manufacturing (AG Jeans)
  2. 2022Web DeveloperCrescendo Interactive
  3. 2021B.S. Computer Information SystemsCal Poly Pomona

Before data work I built websites with React and JavaScript, which is where this site started in 2020.

Let’s talk

I’m interested in data engineering roles focused on pipelines and the platforms they run on. Email is the fastest way to reach me.

hello@michulee.com