Open to opportunities

Josh Smith

@joshsmith

Message

I build reliable SQL and Python data pipelines for operational, analytical, and ML workloads.

United States

Message

What I'm looking for

I’m seeking to bring my SQL/Python data engineering foundation and production ownership to a cloud-based fintech data platform.

At Kenny Pipe & Supply, I’m the sole engineer designing and maintaining SQL Server data architectures and Python/pandas ETL pipelines for a multi-branch wholesale operation.

I own roughly 45 scheduled production jobs and built the monitoring around them: a universal run wrapper, SQLite run-history store, automated failure alerts, a 24/7 Streamlit dashboard, and missed-run polling. I also profiled multi-million-row SQL workloads, identified missing indexes, and reduced large export runtimes by about 23 seconds.

I build practical data products, including a LightGBM pricing model trained on more than 700,000 order lines, PDF parsing pipelines for credit/AR and treasury reporting, and B2B e-commerce REST API integrations. I also operate a 24/7 Flask/Waitress reporting portal used by about 30 people.

With a mathematics degree and hands-on Snowflake exposure, I’m focused on bringing my SQL/Python foundation and production ownership to a cloud-based fintech data platform.

Experience

Work history, roles, and key accomplishments

Current

Software Engineer

Current

Kenny Pipe & Supply

Jan 2022 - Present (4 years 7 months)

Sole engineer designing and maintaining scalable SQL Server data architectures and Python/pandas ETL pipelines supporting operational, analytical, and ML workloads. Built end-to-end data quality and monitoring infrastructure for ~45 scheduled production jobs.