Michael Wang
Streamwood
Summary
Senior Data Engineer with 8+ years of experience designing, automating, and operating cloud-based data platforms across healthcare and pharma. Expertise in AWS (Glue, Redshift, S3), Python-based ETL, and enterprise financial and analytics integrations. Proven track record of eliminating manual workflows, improving data reliability, and enabling scalable, audit-ready reporting.
Overview
8
8
years of professional experience
Work History
Senior AWS Data Engineer Consultant
College of American Pathologists
03.2025 - Current
- Architect and operate cloud-native ETL pipelines on AWS (Glue/PySpark, S3, Redshift) processing high-volume financial and operational data.
- Design end-to-end integrations from relational sources into Redshift, enabling automated reconciliation and downstream reporting.
- Implement data quality checks and source-to-target validation, reducing post-load discrepancies and manual QA.
- Own production pipeline monitoring and issue resolution, including schema changes, data quality failures, and performance bottlenecks.
- Partner with finance and analytics stakeholders to deliver governance-aligned, scalable data solutions.
Senior Data Engineer
Karyopharm Therapeutics
06.2021 - 09.2024
- Architected financial and commercial data integrations across 12+ source systems, saving 300+ engineering hours annually.
- Built and deployed machine learning models identifying high-value HCP prescribers to support commercial strategy.
- Designed and maintained a cloud data warehouse supporting cross-functional analytics and executive reporting.
- Automated recurring workflows with Python, improving productivity by ~25% across a six-person team.
- Established Git-based SDLC standards, improving reliability and collaboration.
Data Engineer
Bristol Myers Squibb
12.2019 - 05.2021
- Developed predictive manufacturing models in Python, increasing output by ~15% across three sites.
- Built forecasting tools and analytics reports supporting senior operations leadership.
- Achieved ~92% accuracy predicting reactor end times.
Analyst
Bioverativ
06.2018 - 12.2019
- Automated financial and operational data consolidation, reducing processing time from hours to minutes.
- Led Tableau-to-Qlik migration and trained an eight-person analytics team.
- Applied machine learning techniques to improve key production metrics by ~18%.
Education
M.S. - Computer Science
University of Massachusetts Amherst
Amherst, MA01.2022
B.S - Operations
University of Massachusetts Amherst
Amherst, MA01.2018
Skills
- Python (Pandas, NumPy, PyTorch, TensorFlow)
- SQL (Postgres, Redshift, MySQL)
- AWS (Glue, S3, Redshift, CloudFormation)
- Spark
- Airflow
- Databricks
- Snowflake
- Tableau
- Power BI
LEADERSHIP
Founder, Chicago Neighborhood Soccer — Built and scaled an inclusive community organization coordinating events, logistics, and participant engagement.
Timeline
Senior AWS Data Engineer Consultant
College of American Pathologists
03.2025 - Current
Senior Data Engineer
Karyopharm Therapeutics
06.2021 - 09.2024
Data Engineer
Bristol Myers Squibb
12.2019 - 05.2021
Analyst
Bioverativ
06.2018 - 12.2019
M.S. - Computer Science
University of Massachusetts Amherst
B.S - Operations
University of Massachusetts Amherst