Jonathan Stowell, Data Modeling Developer in Salt Lake City, UT, United States
Jonathan Stowell

Data Modeling Developer in Salt Lake City, UT, United States

Member since March 14, 2017
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.
Jonathan is now available for hire

Portfolio

  • Veraset
    SQL, PostGreSQL, PostGis, Spatial
  • iCrossing
    Adobe Audience Manager, MySQL, Google Sheets, Hive, Redshift, Tableau, AWS
  • iCrossing
    Redshift, MySQL, PostGreSQL, Netezza, Greenplum, Oracle, Erwin, Bash, Git...

Experience

  • SQL, 20 years
  • Oracle Database, 20 years
  • Data Modeling, 18 years
  • Oracle PL/SQL, 18 years
  • PL/SQL, 18 years
  • Agile, 13 years
  • MySQL, 5 years
  • DMP, 3 years

Location

Salt Lake City, UT, United States

Availability

Part-time

Preferred Environment

Windows, Linux, Git

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.

Employment

  • Contractor

    2019 - PRESENT
    Veraset
    • Created a data product from POI data using spatial techniques.
    Technologies: SQL, PostGreSQL, PostGis, Spatial
  • 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: Adobe Audience Manager, MySQL, Google Sheets, Hive, Redshift, Tableau, AWS
  • Senior Director, Data Services

    2007 - 2016
    iCrossing
    • Led the design and delivery of a marketing analytics data warehouse/business intelligence system using 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 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 2.
    • Established and implemented data security policies.
    Technologies: Redshift, MySQL, PostGreSQL, Netezza, Greenplum, Oracle, Erwin, Bash, Git, Sourcesafe, Pentaho Data Integrator, Tableau
  • CTO

    2003 - 2007
    Sharp Analytics
    • Created 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 Agile methodology to an existing software development team.
    • Designed and implemented a data warehouse framework SDK in Bash.
    Technologies: SQL, PL/SQL, Oracle, Pentaho Data Integrator, Netapp, Linux, Bash
  • 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 to give management insight into product inventory.
    • Administered an Oracle database cluster, including backup, recovery, HA, tuning, security, and integrations.
    Technologies: Oracle, SQL, PL/SQL, VB, Unix
  • 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: Oracle, SQL, PL/SQL, VMS, MS Access

Experience

  • PL/SQL and Bash Data Warehouse Framework (Development)

    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 (Development)

    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 (Development)

    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.

Skills

  • Languages

    SQL, Bash
  • Tools

    Atlassian, Tableau, Slack, Git, Microsoft Office
  • Storage

    PL/SQL, Oracle PL/SQL, PL/SQL Developer, MySQL, Redshift, Netezza, PostgreSQL, SQL Server 2012, PostGIS
  • Other

    Data Modeling, DMP, ETL Development
  • Paradigms

    Agile, Agile Software Development, ETL, Spatial Databases
  • Platforms

    Oracle Database, Linux

Education

  • Bachelor's degree in French
    1988 - 1992
    University of Utah - Utah
  • Bachelor's degree in Chemistry
    1988 - 1992
    University of Utah - Utah
Certifications
  • Adobe Certified Expert, AAM Business Practitioner
    MAY 2017 - JANUARY 2020
    Adobe

To view more profiles

Join Toptal
I really like this profile
Share it with others