jmcbroom.dev

Resumé

Education

  • Cranbrook Kingswood HS, Bloomfield Hills, MI, USA (2001-2005)
  • Columbia University, New York, NY, USA (2005-2010)

Work experience

Data Engineer City of Detroit
Nov 2016 — present
  • lead architect for enterprise data warehouse that powers internal processes and public applications
  • implementing an evolving free & open source modern data stack, used by departments across the city
  • build and maintain web tools to manage internal data and expose public open data for easy consumption
Spatial Data Engineer Regrid (fka Loveland Technologies)
Jan 2015 — Sep 2016
  • built and automated end-to-end data pipelines which extracted, transformed, and published parcel data as raster and vector tilesets
  • led effort to achieve 100% unified US parcel coverage through a variety of extraction/acquisition methods
  • helped guide migration of back-end spatial database from MySQL to PostgreSQL
GIS Analyst Southeast Michigan Council of Gov'ts
May 2013 — Aug 2015
  • cleaned and augmented regional building footprint data to support modelling and operations
  • developed custom Python scripts to automate commonly performed tasks in Esri ArcMap and other software
  • created interactive web mapping visualizations using d3.js and Esri JavaScript API
  • developed accessibility measures using GTFS schedule data for area transit providers

Proficiencies

Languages: Python, JavaScript, HTML + CSS

Software/frameworks: Airflow, dbt, Esri/ArcGIS, QGIS, Maplibre, React, Vue, Svelte

Databases: PostgreSQL + PostGIS, Snowflake