Python Developer

Austin Smit

Data Engineer

760-***-**** **********.****@*****.*** https://www.linkedin.com/in/austinsmit https://github.com/AustinJSmit

PROFESSIONAL SUMMARY

Data Engineer specializing in SQL/Python automation, and orchestration. Rebuilt legacy SQL scripts for a core system

migration and delivered data with scheduled refresh, monitoring, and alerts. Strong in data modeling and focused on

expanding ownership in automation, unit testing, and ETL/ELT. Division I Water Polo has helped me stay disciplined, work as a

team, and value feedback.

SKILLS?

Programming Languages: Python, SQL

Databases/Warehouses: Microsoft SQL Server (MSSQL), PostgreSQL, Snowflake (basic)

Data Processing & Orchestration: Apache Airflow, dbt, Pandas

Data Engineering Concepts: ETL/ELT Pipelines, Data Modeling, Query optimization

DevOps & Tooling: Git, Unit Testing (pytest), Docker

BI & Visualization: Power BI (DAX/Power Query)

PROFESSIONAL EXPERIENCE

Monterey Financial Services, Oceanside, CA? ? ? ? ? ? August 2024 ? Present

Data Analyst

Rebuilt 50+ legacy SQL scripts for the Megasys to NLS migration, maintaining data integrity and reporting continuity

Built 10+ Power BI reports on SQL Server with scheduled refresh and alerting, improving risk visibility and providing

sales KPI tracking used during 30% YoY finance growth (2025 record year)

Designed concentration-limit monitoring and alerting with automated executive notifications, reducing top-10 clients?

share of total exposure from 60.0% to 53.3% 6.7 pp), excluding a designated exempt client

Performed cohort and risk-tier analysis (FICO, term, APR) of reserves and write-offs to identify loss drivers and inform

pricing changes, supporting a +$225M portfolio (~73K accounts)

California Fruit Company, Encinitas, CA? ? ? ? ? ? ? March 2024 ? July 2024

Business Analyst Intern

Automated weekly sales analytics workflow for 20 farmers' markets, calculating incremental performance metrics and

eliminating manual reporting overhead

Developed Power BI dashboards to visualize market trends and communicate actionable insights to leadership

Designed employee satisfaction survey framework with standardized data collection and centralized storage

TECHNICAL PROJECTS?

Consumer Finance ETL Pipeline July 2025

Built end-to-end Python ETL pipeline ingesting 10 financial CSV sources into normalized PostgreSQL schema using

pandas, SQL, and modular design patterns

Implemented parameter-driven transformation and validation framework verifying schema integrity, data types, and

business rule compliance

Designed relational data model with automated dataframe-to-table mapping; maintained version control with Git

Personal Finance Dashboard ? ? ? May 2023

Developed a Python script to merge financial CSVs, clean and transform data, and generate a transaction category field for

grouping and analysis, reducing manual budgeting time by 1 hour per month

Created a Python dashboard using Streamlit to report rollover cash flow, monthly net, and category-level performance

EDUCATION

Pepperdine University, Malibu, CA May 2023

Bachelor of Science in Business Administration

Google Data Analytics Professional Certificate July 2024

LEADERSHIP?

Pepperdine Men?s Water Polo, Malibu, CA August 2019 ? June 2023

NCAA Division I Athlete; GCC Champion (2019, 2020); Selected to Leadership Council

Contact this candidate