Jonathan Stowell, Developer in Salt Lake City, UT, United States
Jonathan is available for hire
Hire Jonathan

Jonathan Stowell

Verified Expert  in Engineering

Data Modeling Developer

Location
Salt Lake City, UT, United States
Toptal Member Since
June 18, 2020

Jon does data. For over 20 years, he has built many different database systems, data warehouses, data visualization, and reporting systems. He has experience in different industries (advertising, pharmaceutical, publishing, CPG, software etc.) and a broad range of exposure to the tech stack (network, OS, database, UI), but his strength is in data related challenges. He is a team player as well as a great collaborator and communicator.

Portfolio

Pfizer
Data Modeling, Python, Data Engineering, Redshift, Linux, Neo4j, SQL
Sourcewater, Inc.
Amazon Web Services (AWS), Data Modeling, Data, Spatial Databases...
Haus.com
Amazon Web Services (AWS), Data Modeling, Python, Boto 3, Data, AWS Lambda...

Experience

Availability

Part-time

Preferred Environment

Linux, Git, Windows

The most amazing...

...product I've created was a data warehouse and visualization solution that was the primary contributor leading to a corporate multi-million dollar sale.

Work Experience

Data Engineer

2020 - PRESENT
Pfizer
  • Composed Python code to reliably extract data from Redshift and load it to Neo4j.
  • Designed business practices and procedures in a graph model.
  • Developed methods to improve and ensure the quality of the graph.
  • Supported all data engineering needs for a critical supply chain application.
Technologies: Data Modeling, Python, Data Engineering, Redshift, Linux, Neo4j, SQL

GIS Data Engineer

2020 - PRESENT
Sourcewater, Inc.
  • Ingested and analyzed large data sets to identify behavioral patterns.
  • Analyzed road usage and traffic and published a report of findings.
  • Used GPS data to identify cohorts of users and measure the flow of resources.
Technologies: Amazon Web Services (AWS), Data Modeling, Data, Spatial Databases, Data Engineering, Slack, Agile, Database Design, PostgreSQL, PostGIS

Data Warehouse Engineer

2020 - PRESENT
Haus.com
  • Designed a data warehouse star schema of Kimball style facts and dimensions.
  • Worked closely with business leaders to answer business-critical questions that add value.
  • Integrated multiple sources using Stitch and other means.
  • Wrote ETL procedures to orchestrate regular loads.
  • Evaluated and recommended third-party tools based on functionality and price.
Technologies: Amazon Web Services (AWS), Data Modeling, Python, Boto 3, Data, AWS Lambda, Data Engineering, Stitch Data, Slack, Linux, Microsoft 365, Snowflake, Agile, Business Intelligence (BI), Database Design, Data Warehouse Design, Data Warehousing

Contractor

2020 - 2020
eCommerce Retailer
  • Mapped eCommerce flow and identified optimization opportunities.
  • Formulated an optimization plan and presented it to executive leadership.
  • Developed techniques to automate integration paths between multiple off-the-shelf products.
Technologies: eCommerce, Data, Shopify Plus, Data Engineering, eCommerce Analysis, Microsoft 365, HIPAA Electronic Data Interchange (EDI), NetSuite, Logistics, Intuit QuickBooks, Shopify

Contractor

2019 - 2020
Volvo Cars Americas
  • Supported a data lake project to catalog a large list of internal data sources.
  • Vetted and chose an off-the-shelf data catalog product from 19 competitors.
  • Presented the results of the data catalog selection process to senior leadership verbally and in writing.
  • Helped define a data strategy for the Salesforce DMP.
Technologies: Amazon Web Services (AWS), Data, Microsoft 365, Atlassian, Oracle PL/SQL, PL/SQL, Catalogs

Contractor

2019 - 2020
Veraset
  • Created a data product from POI data using spatial techniques.
  • Used SQL to transform and analyze positional data.
  • Used PostGIS functions to perform a complex geospatial analysis.
Technologies: Data Modeling, Data, Spatial Databases, Data Engineering, Microsoft 365, Database Design, PostGIS, PostgreSQL, SQL

VP, Product Engineering

2016 - 2019
iCrossing
  • Created a new data management platform practice in the company and delivered services to clients.
  • Managed an Apache Spark development team that processed large amounts of weblog data continuously,.
  • Managed and led a data warehouse product team that delivered insights to clients.
  • Envisioned and prototyped a new data-driven product including database design and creation.
  • Architected a new data strategy for an existing data product in order to monetize existing investments.
Technologies: Amazon Web Services (AWS), Data Modeling, Data, Slack, DMP, Linux, Microsoft 365, Agile Software Development, Agile, Business Intelligence (BI), Database Design, Data Warehouse Design, Data Warehousing, Datorama, Tableau, Redshift, Apache Hive, Google Sheets, MySQL, Adobe Audience Manager

Senior Director, Data Services

2007 - 2016
iCrossing
  • Led the design and delivery of a marketing analytics data warehouse/business intelligence system using the Agile methodology.
  • Managed all database systems across the company, consisting of five major database platforms—over 50TB of data—in four major products, with nine direct reports on two continents.
  • Built a team of remote database administrators (DBAs).
  • Built a profitability model and tracked the value of the organization.
  • Onboarded a Netezza data warehouse to reduce the processing time of daily jobs from over 24 hours to less than two.
  • Established and implemented data security policies.
Technologies: Data Modeling, Data, Analytics, Database Administration (DBA), ETL Development, Netezza, Oracle Database, Slack, Linux, Microsoft 365, Snowflake, Agile Software Development, Agile, Business Intelligence (BI), Database Design, Data Warehouse Design, Data Warehousing, Tableau, Pentaho, Visual SourceSafe, Git, Bash, Erwin, Oracle, Greenplum, PostgreSQL, MySQL, Redshift

CTO

2003 - 2007
Sharp Analytics
  • Developed a flexible digital marketing data warehouse system to manage the unique needs of each client.
  • Created data cleansing procedures to speed up the onboarding of client data.
  • Selected the best of bread technologies for data visualization and dashboarding needs and then implemented client-facing dashboards.
  • Introduced and implemented the Agile methodology to an existing software development team.
  • Designed and implemented a data warehouse framework SDK in Bash.
Technologies: Data Modeling, Data, Analytics, Database Administration (DBA), ETL Development, Oracle Database, Linux, Microsoft 365, Agile Software Development, Agile, Business Intelligence (BI), Oracle PL/SQL, PL/SQL, PL/SQL Developer, Database Design, Data Warehouse Design, Data Warehousing, Bash, NetApp, Pentaho, Oracle, SQL

Manager, Scientific Computing

2001 - 2003
Lexicon Pharmaceuticals
  • Wrote a PL/SQL library as an API to the database for all internally developed apps.
  • Developed a security model, implemented, in PL/SQL, that was used by all client applications.
  • Redesigned a large database model (~100 entities) for increased efficiency and usability.
  • Wrote SQL reports which gave management insights into product inventory.
  • Administered an Oracle database cluster, including backup, recovery, HA, tuning, security, and integrations.
Technologies: Data Modeling, Data, Database Administration (DBA), Oracle Database, Linux, Microsoft 365, Oracle PL/SQL, PL/SQL, PL/SQL Developer, Database Design, Unix, SQL, Oracle

Manager, Chemical Systems and Application Development

1994 - 2001
Institute for Scientific Information
  • Developed QA programs to ensure data quality.
  • Developed an MS Access application to automate manual processes.
  • Administered an Oracle database that served as the core of a data product, including installation, security, backup, recovery, availability, and integrations with third-party tools.
  • Served as the system administrator of the VAX VMS systems that powered the database and product systems.
  • Envisioned and proposed possible new product ideas, including documentation and feasibility studies.
  • Provided on-site and overseas training and support for the flagship data product, all in French.
Technologies: Data Modeling, Database Administration (DBA), Oracle Database, Microsoft 365, Oracle PL/SQL, PL/SQL, PL/SQL Developer, Database Design, Microsoft Access, VMS, SQL, Oracle

Data Warehouse for Fintech Startup

Created a multi-dimensional data warehouse with conformed dimensions to support key business decisions including portfolio valuation, multi-channel attribution, and IRR. Implemented the model, ETL, monitoring, and logging from dev to production. Built in Snowflake, using Stitch and AWS Lambda functions.

PL/SQL and Bash Data Warehouse Framework

In this system, I created a series of PL/SQL stored procedures and functions that managed the entire DW process, from fact and dimension creation to data cleansing and ETL. The project also included a bash shell framework to set up and manage the server components (i.e., FTP, etc.) of the data warehouse. Taken together, the system allowed for easily configuring a data warehouse system that was generalized but also customized for each client.

Marketing Data Warehouse Using Redshift and Tableau

I was the principle architect. We first designed a metadata model and then reusable ETL components. Rather than a fixed set of data sources, this system had to support a fixed set of data source "type" as each client data feed could be different. The data warehouse model contained facts and dimensions that were conformed to meet the needs of all customers. This system, with is accompanying Tableau dashboards, was the principle means of measuring clients' digital marketing ROI.

Generating Application Code at Scale

While working on delivering services to a client, I saw the difficulty they had translating their business strategy into a data strategy. I envisioned and created a process and then a tool to make this possible to the non-technical business owner. I first created a low-cost prototype using advanced features of Google Sheets to demonstrate the value, then developed a metadata model and designed a user interface to make it more easily used and scalable. The basic idea is to capture the business logic in metadata and then generate application logic that implements this strategy in the application.

Languages

SQL, Python, Snowflake, Bash

Tools

Atlassian, Stitch Data, Tableau, Slack, Google Sheets, Visual SourceSafe, Microsoft Access, Boto 3, Git, Datorama, Shopify Plus, Erwin

Paradigms

Database Design, Business Intelligence (BI), Agile, Agile Software Development, ETL, Spatial Databases

Storage

PL/SQL, Oracle PL/SQL, PL/SQL Developer, Database Administration (DBA), Neo4j, MySQL, Redshift, Apache Hive, Greenplum, NetApp, Netezza, PostgreSQL, SQL Server 2012, PostGIS

Other

Data Engineering, Data Modeling, DMP, Data Warehousing, Data Warehouse Design, Analytics, ETL Development, eCommerce Analysis, Data, VMS, Catalogs, Logistics, NetSuite, HIPAA Electronic Data Interchange (EDI), Microsoft 365, Intuit QuickBooks, eCommerce

Platforms

Oracle, Oracle Database, Windows, Adobe Audience Manager, Pentaho, Unix, Shopify, AWS Lambda, Amazon Web Services (AWS), Linux

1988 - 1992

Bachelor's Degree in French

University of Utah - Utah

1988 - 1992

Bachelor's Degree in Chemistry

University of Utah - Utah

MAY 2017 - JANUARY 2020

Adobe Certified Expert, AAM Business Practitioner

Adobe