About Jack

September 2013 - June 2017

Student at University of Denver

Majored in Information Systems/Business Analytics and Minored in Leadership

Attended the University of Denver from 2013 to 2017. Graduated from the Daniel's College of Business with majoring in Business Information Systems/Business Analytics and minoring in Leadership.

While at the University of Denver, Jack participated in Club Waterpolo as well as raced club mountain bikes. Additionally while at DU, Jack worked from being a Teaching Assistant to a Teaching Coordinator. As a TA Coordinator, Jack helped develop the Business School's Microsoft Office curriculums and lead around 10-15 Teaching Assistants.

During Jack's last year at the University of Denver, he was in a serious mountain bike accident that delayed his job start by 10 months. During those 10 months, Jack worked with the University of Denver to develop an Advanced Excel curriculum.

January 2018 - January 2020

Automation Analyst and Developer at Metric Theory

Specialized in building API Integrations, ETL packages in-house with Google Cloud Platform and within Integrations.io software

In January 2018, Jack started as a Pay-Per-Click Analyst for a marketing agency called Metric Theory. After a few weeks of being a PPC Analyst, Jack looked into automating a component of his job. After some time and research, Jack learned how to use Google Apps Scripts and wrote a few scripts that helped speed up daily tasks.

After being noticed for the automation tasks, Jack received a promotion to be a Junior Automation Analyst, and rose to the Automation Analyst, and then to a Developer.

During these roles, Jack was responsible for building ETLs for the internal reporting tool, Compass. These ETLs were primarily made within integration.io's Xplenty software, but some were fully custom and would be built within Google Cloud Platform with Python. Additionally, Jack worked on a prototype UI that helped users utilize the LinkedIn Ads Experiments functionality, which was only available through the API at the time this was written.

February 2020 - June 2020

Attended Flatirons Software Engineering Bootcamp

Learned languages JavaScript and Ruby, while also using React, Rails, Vue, and more.

During February 2020, Jack enrolled in a Software Engineering bootcamp called Flatirons.

In the bootcamp, Jack learned JavaScript, HTML, CSS, SCSS, and Ruby languages. For libraries and frameworks, Jack learned about ReactJS, VueJS, Rails, Express, Material UI, and Bootstrap.

During the bootcamp, Jack was able to develop some Web Applications, which have YouTube and GitHub links located in the projects section of this website.

September 2020 - September 2021

ETL Automation Developer and Data Engineer at Digible, Inc.

Developed API Integrations and web scrapers, and worked on in-house data pipeline within AWS

Jack was enrolled in a few computer science classes at the University of Denver during this time period; as a result, he started a Part-Time job at Digible, Inc as an ETL Automation Developer.

In this role, Jack worked on contributing the internal data pipeline, the Eisenhower, and also worked on developed API integrations. One API integration project was to integrate Google Analytics API data for the agency. This was completed with the use of Python and AWS services.

During the Spring of 2021, Jack decided to switch to Full-Time at Digible, Inc and was promoted to a Data Engineer.

During this role, Jack was responsible for helping finalize the data pipeline components of the Fair Housing detection product.

September 2021 - September 2022

Senior Developer at Media.Monks

Lead development of in-house data pipeline, CI/CD pipeline, and internal Web Application, all within Google Cloud Platform

In September 2021, Jack had the opportunity to go back to Metric Theory, except this time it was acquired by S4 Capital and was apart of Media.Monks brand.

In this new role as a Senior Developer, Jack was tasked with replacing the integrations and ETL softwares with an internally developed tool, Gaea.

Jack developed this tool with the use of the Python language, as well as utilized SQL and Bash in different sections of the tool. Additionally this tool uses a variety of Google Cloud Platform services

For Python, Jack used black formatter, flake8 linter, pytest/pytest-mock, and Poetry dependency manager and package builder/publisher.

Bash was used within bash scripts used in automation and in the separate CI/CD pipeline.

SQL was used within BigQuery and was generated for each ETL programmatically.

The following Google Cloud Platform services are used:

  • Cloud Tasks
  • Cloud SQL
  • Cloud Scheduler
  • Cloud Functions (gen 1 & 2)
  • Cloud Run
  • Pub/Sub
  • BigQuery
  • Cloud Storage
  • Cloud Build
  • Deployment Manager


Overall, Gaea is a strong data pipeline that fetches 40+ different custom API integrations daily, lands the data to BigQuery, transforms it with BigQuery, and has it ready for being integrated to Google Data Studio reports.

September 2022 - August 2023

Data Engineer - Integrations

Utilize Python, Docker, Snowflake, and more on a daily basis to help fuel the company app, Fiona

During September 2022, Jack decided to head back to Digible, Inc. In his new role as a Data Engineer - Integrations, he was tasked with helping to rebuild infrastructure, as well as utilize and implement some new technologies into the company's tech stack.

Jack has worked with implementing the orchestration software, Prefect within Amazon AWS Fargate, as well as worked to help build the in-house data extraction tool, Fetchy, which is built within Zyte Cloud and utilizes Python and Scrapy.

Jack currently is still working at Digible Inc., and is using the following technologies on a regular basis:

  • Python
  • Pytest
  • Docker
  • Prefect
  • SQL/Snowflake
  • AWS/GCP/Zyte services
  • Salesforce
  • GitHub Actions
  • Python Poetry
August 2023 - Present

Data Engineer at Foundation Direct

Developing Cloud/Data Pipeline Infrastructure

  • Python
  • Pytest
  • Docker
  • Prefect
  • SQL/BigQuery
  • GCP/Zyte services
  • Salesforce
  • GitHub Actions
  • Python Poetry
  • GoLang

Skills

Card image cap

Amazon Web Services


S3 Boto3 ECR ECS Fargate Lambdas CloudWatch EventBridge
Card image cap

Apache Beam


Google Cloud Dataflow DirectRunner
Card image cap

Bash


Scripting Custom Commands
Card image cap

CSS


Bootstrap CSS SCSS
Card image cap

dbt


SQL Snowflake Jobs Environments Cloud UI Cloud Core
Card image cap

Django


APIs Templating MVC Framework
Card image cap

Docker


Dockerfile Docker-Compose ECR GCP Artifact Registry
Card image cap

GitHub


GitHub Actions Git Version Control
Card image cap

Go


GoLang Extraction ELT Scripts
Card image cap

Google Cloud Platform


Cloud Functions Cloud Run App Engine API Gateway BigQuery IAM gCloud
Card image cap

JavaScript


Automation Web Apps NodeJS/Express
Card image cap

Kestra


Kestra Orchestration
Card image cap

Poetry


Python Tools Dependency Management
Card image cap

Prefect


Orchestration within ECS Fargate Cloud UI Prefect CLI tool
Card image cap

Python


Web Scraping ETL Processes Pandas Asyncio
Card image cap

React


React Material-UI Framework React-Router
Card image cap

Ruby on Rails


API MVC Framework Routing Authentication File Uploads
Card image cap

Snowflake


SQL IAM Integrations ETL
Card image cap

SQL


PostgreSQL BigQuery SnowFlake SQLite MongoDB