University of Vermont

Director, Data Engineering at Devoted Health

Washington, District of Columbia, United States

Devoted Health

Director, Data Engineering

- Built scalable Airflow deployment on Kubernetes using Terraform and Helm to replace existing cron jobs; improving pipeline reliability and performance.
-  Developed internal tooling to allow Data Scientists to develop against Airflow without needing to know Python, Kubernetes, Helm, Docker; improving pipeline development speed
-  Led selection of Snowflake and migration from existing Redshift data warehouse; improving data platform scalability and query concurrency/performance
-  Mentoring Data Engineering team in using Kubernetes, Terraform, and Airflow. Organization had no prior expertise before my arrival

Staff Data Infrastructure Engineer

- Designed and implemented S3 Data Lake using AWS Glue for transformations and AWS Athena for querying; replaced existing solution of querying production replica
-  Wrote Terraform module for deploying Segment to Kinesis to S3 pipelines
-  Developed and open-sourced Terraform Provider for Segment API to allow Segment resources to be version controlled

Promoboxx

Data Consultant

- Led selection of Airflow to replace legacy cron jobs; improving monitoring and data quality
-  Replaced Spark Streaming solution with Kafka consumers written in Go; improving reliability and handling failure without data loss
-  Devised custom dynamic DAG framework for Airflow in Python; improving developer efficiency and reducing time to ingest new data sources
-  Introduced software development best practices to team, including CI/CD, automated testing/linting, and ETL configuration as code
-  Mentoring data engineers in data warehousing fundamentals and developing pipelines in Airflow with paired programming
-  Working closely with Data Science team to productionalize scripts and models
-  Deploying containerized applications on Kubernetes

DigitalOcean

Senior Data Engineer

- Led selection and implementation of Airflow for ETL orchestration
-  Developed data pipelines in PySpark
-  Replaced existing SQL Server data warehouse with S3 based data lake and Amazon Redshift/Presto
-  Led implementation of Qubole as a managed Data Platform for Spark, Hadoop, and Presto clusters

Carbonite

Lead Data Engineer

- Developed data pipelines in Python using Luigi framework
-  Designed and implemented homegrown data quality platform
-  Developed custom tooling in Python  for migrating existing Amazon Redshift data warehouse to Snowflake
-  Introduced open-source data dictionary solution, WhereHows
-  Led deployment of Looker as an alternative reporting solution to Tableau
-  Deployed applications on Apache Mesos clusters using Docker

Fitbit

Senior Business Intelligence Architect

- Managed and mentored Data Warehousing and Reporting teams
-  Led deployment of new Looker reporting solution on top of Snowplow Event Analytic Platform
-  Led  proof-of-concept project to explore the value of using Apache Spark for ETL with Databricks
-  Led team of BI Developers working to add new sources to existing data warehouse
-  Designed ETL processes for integrating data from a wide variety of systems across many business groups (Customer Support, Database Marketing, SalesForce, Marketing Attribution)
-  Introduced Tableau reporting platform to improve visualization and data exploration capabilities
-  Developed a SSAS solution to provide self-service reporting for power users and analysts

Senior Manager, Business Analytics

Manager, Business Intelligence

Senior Business Intelligence Developer

- Configured custom SaaS business intelligence solutions for a wide range of clients using proprietary reporting tool, SQL, and ColdFusion
-  Analyzed and integrated multiple data sources into structured database schema
-  Developed and maintained reporting queries, ETL scripts, and stored procedures for solutions
-  Led report development for several client projects simultaneously
-  Provided customer support for all production solutions

Deloitte

Analytic Application Engineer

Oco, Inc.

Solution Developer

- Wrote complicated ETL scripts to merge and cleanse hospital data from several sources
-  Developed custom reporting tool in Excel using VBA
-  Designed and maintained large MySQL databases of hospital admissions records

Byrne Healthcare

Data Analyst

- Developed requirements for integrating disparate sources of policy data after acquisitions
-  Worked with stakeholders to develop data feeds into downstream systems from policy database
-  Designed testing process that allowed end-users to analyze large volumes of data for discrepancies
-  Developed custom reports using a combination of SQL and Excel
-  Trained end-users in operating manual database entry system

Adam Boscarino