Scroll To View More
Josh Chapman, Data Modeling Developer in Los Angeles, CA, United States
Josh Chapman

Data Modeling Developer in Los Angeles, CA, United States

Member since August 24, 2019
Josh is an engineering leader and architect with a special passion for data. He's been building data warehouses and reporting platforms for top retailers and eCommerce startups for over a decade. He loves learning and meeting new teams, and he's well-versed in the latest trends and tools in data.
Josh is now available for hire

Portfolio

  • The Honest Company
    Amazon Redshift, Python, Airflow, Talend, RDS, MySQL, PostgreSQL, Bash, SQL...
  • Nordstrom
    Amazon Redshift, Spectrum, Google BigQuery, Pentaho Data Integration, Python...
  • ideel
    MySQL, Pentaho, MicroStrategy, MS SQL, Talend, Epicor, Netsuite, Bash

Experience

  • SQL, 16 years
  • Data Modeling, 16 years
  • Data Warehousing, 16 years
  • ETL, 16 years
  • Business Intelligence (BI), 14 years
  • Pentaho Data Integration (Kettle), 8 years
  • MySQL, 8 years
  • Redshift, 5 years
Los Angeles, CA, United States

Availability

Part-time

Preferred Environment

Mac, Linux, JetBrains IDEs, Atom, Git

The most amazing...

...projects are those that have the biggest impact, not the fanciest code. I've built data warehouses using cheap tools that saved hundreds of person-hours a week.

Employment

  • Manager, Data Engineering

    2019 - PRESENT
    The Honest Company
    • Built data warehouse in Amazon Redshift.
    • Integrated with new SaaS vendors including Salesforce Commerce Cloud.
    • Implemented managed Airflow service Astronomer.
    • Brought modern data SDLC practices to data engineering team.
    • Transformed reporting environment.
    Technologies: Amazon Redshift, Python, Airflow, Talend, RDS, MySQL, PostgreSQL, Bash, SQL, Tableau, Domo, AWS, data warehousing, dimensional modeling
  • Engineering Manager, Data Services

    2014 - 2019
    Nordstrom
    • Scaled up the data warehouse while improving performance and availability.
    • Implemented a data lake on AWS.
    • Scripted all infrastructure provisioning and configuration using Terraform and Ansible.
    • Redesigned and rewrote the ETL loading our Amazon Redshift Data Warehouse.
    • Built team from zero to seven engineers.
    Technologies: Amazon Redshift, Spectrum, Google BigQuery, Pentaho Data Integration, Python, Ansible, Terraform, MySQL, AWS, Bash, SQL
  • Manager of Data Services

    2011 - 2014
    ideel
    • Led the effort to design and build ideeli's enterprise data warehouse.
    • Served as the team's architect and senior developer - designing, building, reviewing, deploying and supporting ETL jobs, SQL scripts, and reports.
    • Led combined onshore/offshore team in the implementation of MicroStrategy for end-user reporting and analysis.
    • Designed the company's ETL architecture from scratch, using Pentaho Data Integration (Kettle) and custom MySQL routines. Led development and production support.
    • Designed a key data integration system between the ERP and Warehouse Management systems, using PDI and MySQL.
    • Debugged reports in a wide range of technologies: MicroStrategy, Pentaho, MySQL, MS SQL Server, SSAS, MS Access, Excel, Epicor, NetSuite, Talend ETL, Hive, shell scripts.
    Technologies: MySQL, Pentaho, MicroStrategy, MS SQL, Talend, Epicor, Netsuite, Bash
  • Software Developer

    2009 - 2011
    Bridgewater Associates
    • Designed and developed the data model, ETL process, and reports for the system used to monitor counterparty exposure. Ran status meetings with sponsors, and managed the project plan. (SSIS, T-SQL, SSRS, AgilePoint).
    • Quickly got up to speed on previously unfamiliar business concepts – for instance, developed the database portion of a major new risk-control monitoring tool within a month of joining.
    • Played a key role in a reorg to separate production support responsibilities from the development team: Designed the training and certification plan for new support associates; improved the procedures for incident handling and escalation; served as lead trainer.
    Technologies: MS SQL Server, SSRS, SSIS, Stored procedures
  • Senior Consultant

    2005 - 2008
    Palladium Group
    • Designed and led the development of a budget-analysis application for a leading office-supply retailer. (MS SQL Server, Hyperion Essbase, Windows batch scripting).
    • Led redesign of sales-reporting app for a leading yellow-pages publisher. (Informatica, Oracle).
    • Designed and developed database components of a sales reporting and forecasting tool for a.
    • major quick-service restaurant company. (PL/SQL, Bash, Hyperion Planning, Hyperion Reports).
    Technologies: Informatica, MS SQL Server, Oracle DB, PL/SQL, Hyperion Essbase, Hyperion Reports, Bash, Windows batch scripting
  • Consultant

    2003 - 2005
    CGI
    • Served as a data warehouse developer on a long-term engagement for a large telecom.
    • Reviewed requirements and data models, wrote designs, wrote and tested code, and supported production.
    • Served as tech lead for major redesign of an existing marketing data warehouse. (Informatica PowerCenter, Oracle PL/SQL, Bash).
    Technologies: Informatica, Oracle DB, PL/SQL, Bash

Experience

  • Flask App for Interactive Commands in Slack (Development)
    https://github.com/joshuahchapman/birders-slackbot

    This is a fun hobby project of mine. It's a simple Flask app that runs on Heroku with a Postgres database. It handles interactive commands for a Slack workspace that I created and maintain.

Skills

  • Languages

    SQL, Python
  • Tools

    Pentaho Data Integration (Kettle), Domo, Salesforce Marketing Cloud, Talend ETL, Tableau, AWS EBS, Stitch Data
  • Paradigms

    ETL, Business Intelligence (BI), Database Design, Agile
  • Other

    Data Warehousing, Data Modeling, Software Development, Google BigQuery, MicroStrategy, eCommerce, SSRS Reports, Fivetran, Informatica, Analytics
  • Platforms

    AWS EC2, Google Analytics 360
  • Storage

    Redshift, MySQL, PostgreSQL, SQL Server 2012, Data Lakes, Data Integration, AWS S3, SQL Server Integration Services (SSIS), Salesforce Commerce Cloud

Education

  • Bachelor's degree in Computer Science, German Studies
    1998 - 2002
    Amherst College - Amherst, MA, USA
I really like this profile
Share it with others