Kwame Asante
Data Engineer · dbt, Snowflake, Airflow & Kafka
Pittsburgh, PA(412) 555-0162kwame.asante@email.comlinkedin.com/in/kwameasantegithub.com/kasante
Summary
Data engineer with 8 years building batch and streaming pipelines for insurance and pharmacy data. Moved a legacy SSIS estate to dbt on Snowflake and owns warehouse cost, testing and on-call for the claims domain. Works in SQL and Python, with Terraform for the infrastructure around it.
Experience
Data Engineer II · Highmark HealthJan 2022 – Present
Pittsburgh, PA
- Moved 140 nightly SSIS jobs for claims reporting to dbt models on Snowflake under Airflow; the nightly run fell from 6.5 hours to under 2.
- Built a Kafka to Snowflake path with Snowpipe Streaming for member eligibility events, taking dashboard freshness from next-day to under 10 minutes.
- Cut Snowflake spend by about $18,000 a month by right-sizing warehouses, tightening auto-suspend, and clustering the two largest claims tables.
- Added dbt tests and Monte Carlo monitors across 320 models; bad-data tickets from actuarial analysts fell from about 12 a month to 3.
- Wrote a data contract template with 4 source-system owners so schema changes arrive with notice instead of as failed loads.
Data Engineer I · UPMC Health PlanJul 2018 – Dec 2021
Pittsburgh, PA
- Maintained 60+ Python ETL jobs loading prior-authorization data from PostgreSQL into Redshift for product and finance reporting.
- Rewrote the daily prescriber-activity job in PySpark on EMR, cutting run time from 3 hours to 25 minutes as volume passed 40M rows a day.
- Handled pipeline on-call one week in six and wrote runbooks for the 8 most common failure modes.
Education
B.S. Computer Science and Engineering · The Ohio State UniversityMay 2018
Skills
Languages: SQL, Python, PySpark, Bash
Data platform: Snowflake, dbt, Airflow, Kafka, Spark, Redshift, PostgreSQL
Cloud and ops: AWS (S3, EMR, Glue, IAM), Terraform, GitHub Actions, Docker, Monte Carlo
Modeling: Dimensional modeling, Slowly changing dimensions (Type 2), Data contracts
Certifications
SnowPro Core Certification (Snowflake)