Ethan G Monk, Developer in Fort Worth, TX, United States
Ethan is available for hire
Hire Ethan

Ethan G Monk

Verified Expert  in Engineering

Data Developer

Location
Fort Worth, TX, United States
Toptal Member Since
August 5, 2020

Ethan is a passionate analytics/data engineer striving to leverage data for actionable, and ultimately human purposes. He has led teams and implementations of backend data structures and processes, and devised data/analytics productization strategies on behalf of major Fortune 500 companies and startups alike. With a broad range of experience across multiple industries and disciplines, Ethan has been exposed to a wide array of technologies and methodologies over the years.

Data EngineeringData WarehousingData Warehouse DesignSQLDatabasesPostGISPostgreSQLETLPythonRedshiftMicrosoft SQL ServerRAmazon Web Services (AWS)Google Cloud Platform (GCP)MySQL

Portfolio

PMG Worldwide
R, Tableau Server, Plotly, Google BigQuery, Redshift, Python, SQL
PMG Worldwide
R, Tableau Server, Google BigQuery, Redshift, Python, SQL
Trademark Property Company
QGIS, PostGIS, PostgreSQL, T-SQL (Transact-SQL), Microsoft SQL Server

Experience

Databases - 8 yearsLocation Services - 6 yearsGeospatial Analytics - 5 yearsPython - 4 yearsETL - 4 yearsData Engineering - 4 yearsMarketing Analytics - 3 yearsData Warehouse Design - 3 years

Availability

Part-time

Preferred Environment

Apache Airflow, Python, Google BigQuery, Redshift, Data Warehouse Design, Data Warehousing, Microsoft SQL Server, MySQL, PostgreSQL, Microsoft Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS)

The most amazing...

...cloud-based data warehousing system I've architected and implemented facilitated all marketing analytics for a major, multi-brand, Fortune 500 retailer.

Work Experience

Senior Analytics Manager

2019 - 2020
PMG Worldwide
  • Strategized and implemented productization of agency-wide analytics platform.
  • Led and promoted back-end data processes scaling analytics solutions across the agency.
  • Devised strategic roadmap for the incorporation of analytics data processes and products into the “Alli” ecosystem.
  • Managed and grew a team of data/analytics engineers to facilitate agency-wide analytics initiatives and technologies.
Technologies: R, Tableau Server, Plotly, Google BigQuery, Redshift, Python, SQL

Analytics Coordinator/Analytics Manager

2017 - 2019
PMG Worldwide
  • Managed and led the back-end analytics development team to power reporting/insights for major brands.
  • Engineered and automated big data processing and ETL solutions.
  • Collaborated with advertisers to enable multi-dimensional insights from disparate web analytics and digital marketing platforms.
Technologies: R, Tableau Server, Google BigQuery, Redshift, Python, SQL

Research and IT Associate

2015 - 2017
Trademark Property Company
  • Developed a device driven analytics service utilizing geospatial datasets and mobile device location feeds which transformed the research department into a revenue center.
  • Designed and implemented company research/reporting infrastructure.
  • Administered and scaled company Microsoft SQL database and reporting framework.
Technologies: QGIS, PostGIS, PostgreSQL, T-SQL (Transact-SQL), Microsoft SQL Server

Analyst/Senior Analyst

2014 - 2015
Healthcare Payment Specialists
  • Developed back-end processes for a new product line to maximize distressed hospital Medicare reimbursement using publicly available data.
  • Scrubbed, implemented, queried, manipulated, and analyzed various forms of data.
  • Created, automated, and improved operating procedures/processes.
Technologies: T-SQL (Transact-SQL), Microsoft SQL Server

QGIS Mapzen Isochrone Plugin

https://github.com/spatialmonk/qgsMapzenIsochrones
A Python-based plugin for QGIS that generated travel-time isochrones on a map given several different options/parameters. The plugin is several years old and is no longer supported as the Mapzen Isochrone API is deprecated. The plugin has over 10,000 downloads from the QGIS Plugin Repository.

Spatial Monks Website

https://www.spatialmonks.com/
This is an in-progress website for my small data and analytics engineering agency. The website is built using the Django framework. It is very minimalistic at this point but built in a way to easily allow new additions via Django's powerful templating language.

Languages

SQL, Python, R, T-SQL (Transact-SQL)

Paradigms

ETL

Storage

PostGIS, PostgreSQL, Redshift, Databases, Microsoft SQL Server, MySQL

Other

Geospatial Analytics, Google BigQuery, Marketing Analytics, Data Engineering, Data Warehousing, Location Services, Data Warehouse Design, Health IT, Microsoft Azure, Tableau Server, QGIS

Tools

Apache Airflow, Plotly

Platforms

Amazon Web Services (AWS), Google Cloud Platform (GCP)

2012 - 2014

Bachelor of Science Degree in Economics

Texas Christian University - Fort Worth, TX