Data Engineer Portfolio

Amir Mirkazemi

20+Snowflake ingestion pipelines
~40%fewer manual validation tickets
4.0UCSD MS Data Science GPA
SnowflakeAirflowPythonPySparkTrinoKubernetesGreat ExpectationsSQL

About Amir

I am a data engineer focused on metadata-driven ingestion, Python-based Airflow DAGs, Snowflake pipelines, PySpark jobs, Trino SQL views, and Great Expectations validation. My work sits close to production: reducing manual setup, fixing recurring pipeline failures, and making messy operational feeds reliable for reporting teams.

Experience

July 2025 - Present

Data Engineer

Credit One Bank

Las Vegas, NV

Python, SQL, Airflow, PySpark, Snowflake, Trino, Kubernetes

Building metadata-driven Snowflake ingestion pipelines, Airflow DAG tooling, Great Expectations quality checks, and production fixes across PySpark, Trino, Kubernetes, and schema migration work.

Sep 2023 - May 2025

Data Analyst

Advertising Checking Bureau

Tempe, AZ

SQL, Excel

Validated about 120 claims daily with SQL and automated recurring Excel reporting workflows, reducing report preparation from about an hour to under 15 minutes.

Projects

Cloud system visual for the weather ETL pipeline

Python, GitHub Actions, SQLite, API ingestion

Weather ETL Pipeline

An automated ETL pipeline that extracts live weather data from a public API, transforms it into typed records, and loads SQLite hourly with GitHub Actions.
Airflow DAG workflow graph for metadata generation

Airflow, Python, SQL metadata, Snowflake

Metadata Generator Airflow DAG

A production DAG that turns structured inputs, column definitions, unique identifiers, and file-pattern regex into SQL for pipeline metadata tables.
Global data network visual for Snowflake schema migration

Snowflake, Trino SQL, schema mappings

Snowflake Schema Migration

Migrated 20+ feeds and tables from core- to business-facing Snowflake schemas by rebuilding SQL views, definitions, and target mappings for Marketing reporting.

Engineering references

Technical stack

PythonSQLSnowflakeApache AirflowPySparkTrinoKubernetesGreat ExpectationsOracleSQL ServerPostgreSQLMySQLGitLabAWSExcelTableau

Education

Graduate data science training backed by information technology fundamentals and production data engineering work.

UCSD

University of California, San Diego

Master of Science in Data Science

Expected Apr 2027 / GPA 4.0 / Halicioglu Data Science Scholarship
ASU

Arizona State University

BS Information Technology

Completed Aug 2025 / GPA 4.0 / New American Scholarship / Dean's List