John Wang
@johnwang2
Senior data engineer building governed, high-performance ETL for analytics.
United StatesWhat I'm looking for
I’m a Senior Data Engineer with 9+ years building large-scale data platforms and pipelines for enterprise analytics and advertising systems. I deliver high-performance, reliable ETL/ELT workflows and data models using Python, SQL, PySpark, Spark, Snowflake, Databricks, AWS, and Azure.
At Chewy, I engineered a Sponsored Ads data platform on Databricks/Snowflake, orchestrating streaming ETL with Apache Kafka, AWS Kinesis, Glue, and Airflow to improve data freshness and enable near real-time Power BI reporting. I also built an MLOps pipeline using AWS SageMaker/MLflow to automate ad relevance model training and deployment with reproducible feature generation.
I’ve designed governed, scalable architectures for BI, ML, and reporting—strengthening data quality and compliance with HIPAA, RBAC, and validation using Great Expectations. I’ve also focused on performance and cost optimization by improving SQL query performance, reducing ETL run time, and tuning Spark jobs with partitioning and caching.
Across roles at Slalom, Admiral, and Exactech, I’ve migrated warehouses, implemented lakehouse patterns, and delivered self-serve analytics through dbt models and dimensional design. I enjoy collaborating with product, data science, and BI teams to translate requirements into scalable data solutions aligned to business SLAs and user needs.
Experience
Work history, roles, and key accomplishments
Senior Data Engineer
Chewy, Inc.
Mar 2023 - Present (3 years 4 months)
Engineered Chewy's Sponsored Ads data platform on Python, SQL, and PySpark using Databricks and Snowflake, ingesting 20M+ daily events and improving data freshness for real-time advertiser analytics in Power BI. Orchestrated streaming ETL with Kafka, AWS Kinesis, Glue, and Airflow, and built an MLOps pipeline with SageMaker and MLflow for automated model training and deployment.
Senior Data Engineer
Slalom
Oct 2019 - Mar 2023 (3 years 5 months)
Architected a scalable analytics platform for an enterprise client using Snowflake, Databricks (PySpark), and Azure Data Factory, processing 20M+ records daily and reducing BI report generation time. Built and migrated data warehouse components to Snowflake/Redshift, implemented Delta Lake on ADLS and AWS S3, and developed Airflow pipelines with CI/CD and data governance using Glue Catalog/IAM and
Data Engineer
Admiral
May 2018 - Oct 2019 (1 year 5 months)
Engineered streaming ETL pipelines in Python (Spark) to ingest and process 10M+ daily events using Kafka and AWS Kinesis. Built enrichment services with AWS Lambda for consent/user metadata to support GDPR/CCPA compliance, and developed batch analytics pipelines with Spark and AWS Glue including dimensional schema development in Redshift.
Data Analyst/ Data Engineer
Exactech
Sep 2017 - May 2018 (8 months)
Built executive Power BI dashboards and SQL queries to analyze orthopedic surgery outcomes and implant usage across 100K+ de-identified patient records. Developed star/snowflake schemas in PostgreSQL with optimized views and stored procedures, managed HIPAA-aware data practices, and automated weekly/monthly ETL with Python scripts.
Education
Degrees, certifications, and relevant coursework
University of Florida
Bachelor of Science in Computer Science, Computer Science
2013 - 2017
Earned a Bachelor of Science in Computer Science at the University of Florida in Gainesville, Florida from 2013 to 2017.
Tech stack
Software and tools used professionally
Availability
Location
United StatesAuthorized to work in
Job categories
Skills
Interested in hiring John?
You can contact John and 90k+ other talented remote workers on Himalayas.
Message JohnGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
