About Jack
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.
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.
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.
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.
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.
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
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