Summary
Work History
Education
Skills
Timeline
Overview
Generic

Bryan J. MacKenzie

Sr. Data Engineer, Data Engineering & Data Science
Swedesboro,United States

Summary

Experienced data engineer with a strong track record of delivering high-quality solutions across diverse industries, including healthcare. Proven ability to consistently meet company goals through a disciplined approach and strong problem-solving skills. Adaptable and capable of thriving in fast-paced environments, with a reputation for successfully navigating new challenges and enhancing organizational reputation.

Work History

Senior Data Engineer

PPLSI
Ada, OK
03.2022 - Current
  • Designed, built, managed data governance platform.
  • Managed data validation for operational data store and customer data graph applications.
  • Created and managed customer data platform for analytics and data science.
  • Built data pipelines from various APIs, between Microservices and Snowflake warehouse using python and SQL.
  • Created policies for data governance platform and customer data platform.
  • Created sentiment analysis POC for survey data to discover trends in customer comments as it relates to their rating.

Adjunct Instructor, College of Technology

Wilmington University
New Castle, DE
05.2019 - Current
  • Created and implemented course agendas, lesson plans and activities to successfully meet course objectives.
  • Undergraduate course list: Computer Science Fundamentals, Web Design and Development, Computer Architecture, Ethics for AI Data Analytics.
  • Graduate course list: Data Management, Internet Development & Design for Competitive Advantage.
  • Work with class sizes over 20+ students.
  • Mentor and tutor students to help them to succeed in their course work.
  • Plan and execute weekly lesson plans.

Adjunct Instructor, Computer Information Systems

Rowan College Of South Jersey
Sewell, NJ
05.2017 - Current
  • Create curriculum and supplemental materials for courses and lectures.
  • Establish and execute weekly lesson plans.
  • Increased student success through mentoring and tutoring.
  • Course list: Introduction to Computers, Technology Literacy, Fundamentals of Programming, Management Information Systems.

Sr. Engineer, Data Engineering & Operations

Comcast, Xfinity
Philadelphia, PA
01.2020 - 03.2022
  • Manage projects from technical and data engineering perspective.
  • Support and collaborate with management-level customers on new implementations.
  • Successfully created, implemented and migrated Customer Experience Framework in three different environments: Teradata, Hadoop, Kubernetes/MinIO using Apache Spark/PySpark.
  • Deploying pipelines to Kubernetes cluster using Docker and Concourse CI.
  • Creating automation for pipelines using Python and Apache Airflow.
  • Combining data from different platforms including Teradata, Hadoop, and AWS S3.
  • Identify enhancement options to data pipelines to more efficiently process hundreds of millions of records.
  • Performed troubleshooting and bug fixes that are found in data pipelines.

Data Engineer II, Research Information Systems

Children's Hospital Of Philadelphia, CHOP
Philadelphia, PA
04.2019 - 01.2020
  • Designed, created, and managed new data warehouse for Research Institute.
  • Developed and supported new data pipeline request submissions.
  • Created data pipelines using Alteryx ETL tools.
  • Created new reports and dashboards using Tableau.
  • Consulted C-Level, determining business needs within Research Institute.
  • Created stored procedure, views, and functions based on need.
  • Presented newly created dashboards and reports to senior leadership.
  • Collected, analyzed, and communicated metrics to director on daily business operations.

Senior Programmer, Financial

Inspira Health Network
Bridgeton, NJ
06.2016 - 04.2019
  • Led team for Ambulatory and Population Health data projects.
  • Created new ETL pipelines for data requests using SSIS packages.
  • Increased recovered revenue from Medicare/Medicaid through implementation of new data products.
  • Developed data governance processes and policies.
  • Worked directly with Vice President of Population Health to coordinate data needs and requirements.
  • Deployed dashboards and reports using Tableau.
  • Managed data warehouse project implementation for Population Health Org.
  • Presented dashboards and reports to C-Level for outreach and financial decision-making.

Clinical System Analyst II - Data Analytics

Inspira Health Network
Bridgeton, NJ
01.2013 - 06.2016
  • Served as team lead for several clinical data warehouse and reporting projects.
  • Met with department-level management for business requirements.
  • Presented new data products to senior management.
  • Decreased turn-around time for new report requests to 1 week.
  • Managed data warehouse implementation; including data modeling, migration, and validation.
  • Developed ETL pipelines for clinical data requests using SSIS.
  • Created stored procedures, views, and functions to meet requirements of customer requests.

HIM Specialist Analyst

Inspira Health Network
Bridgeton, NJ
08.2009 - 01.2013
  • Researched and implemented new technologies to improve reporting in department.
  • Decreased physician chart reviews by 50%.
  • Worked with director to develop workflows, processes, and procedures to increase operational efficiencies.
  • Created reports and presentations for director of HIM.

Education

MBA - Management Information Systems

Wilmington University
New Castle, DE
08.2016 - 12.2017

Bachelor of Science - Information Systems Management

Wilmington University
New Castle, DE
09.2014 - 06.2016

Associate of Applied Science - Health Science

Rowan College At Gloucester County
Sewell, NJ
09.2008 - 06.2013

Skills

    Languages: SQL, Python, PySpark, Bash, HTML/CSS

DBMS: SQL Server, GCP, Snowflake, Postgres, Teradata, HP Vertica, MySQL, Netezza, MinIO, Hadoop, AWS S3

ETL Tools: Apache Airflow, Apache Spark, Databricks, SSIS, Alteryx

Data Visualization: Tableau, PowerBI

DevOps: GitHub, Jira, Docker, CICD

Environments: Kubernetes, Hadoop, Linux

Timeline

Senior Data Engineer

PPLSI
03.2022 - Current

Sr. Engineer, Data Engineering & Operations

Comcast, Xfinity
01.2020 - 03.2022

Adjunct Instructor, College of Technology

Wilmington University
05.2019 - Current

Data Engineer II, Research Information Systems

Children's Hospital Of Philadelphia, CHOP
04.2019 - 01.2020

Adjunct Instructor, Computer Information Systems

Rowan College Of South Jersey
05.2017 - Current

MBA - Management Information Systems

Wilmington University
08.2016 - 12.2017

Senior Programmer, Financial

Inspira Health Network
06.2016 - 04.2019

Bachelor of Science - Information Systems Management

Wilmington University
09.2014 - 06.2016

Clinical System Analyst II - Data Analytics

Inspira Health Network
01.2013 - 06.2016

HIM Specialist Analyst

Inspira Health Network
08.2009 - 01.2013

Associate of Applied Science - Health Science

Rowan College At Gloucester County
09.2008 - 06.2013

Overview

14
14
years of professional experience
8
8
years of post-secondary education
Bryan J. MacKenzieSr. Data Engineer, Data Engineering & Data Science