Hey!

I'm Carston Hernke. I build data pipelines, interactive maps, and the occasional slide deck.

Check out Honeycomb , my latest project!

Feel free to get in touch about jobs, freelance projects, or just coffee: hernk009@umn.edu

Projects
Honeycomb
A browser-based tool for interactive geospatial analysis
JavaScript DuckDB
Bike Lane Analysis
A visualization for TIER Mobility, comparing scooter rides with bike lane infrastructure
CARTO OpenStreetMap
Polygon to H3 Converter
A simple tool for easily converting polygons to h3 indexes
React H3.js Turf.js
Minneapolis: 1890 and Today
A map produced in 1890 digitized and overlaid on a modern web map.
JavaScript Deck.gl

Tools to apply styling from CSS (Cascading Style Sheets) to dashboards created in Tableau. Private GitHub repository for copyright reasons - reach out for more information.

Python CSS Tableau

For my honors thesis, I used geospatial analysis techniques to find evidence of disparities in access to dockless scooters in Minneapolis, MN.

R sf LaTeX

CSCI 4511W Final Project. Uses various search algorithms to optimize for score, navigating Ms. Pacman towards points and away from ghosts.

Python OpenAI Gym LaTeX

An experimental approach to creating cartograms that replace geographic distance with travel time, revealing which places are truly close to each other.

Python R OpenCV

A system designed to track the campus shuttle busses at the University of Minnesota - Twin Cities. Pulls data from the existing NextBus API, cleans and interpolates it, and generates predictions using the scikit-learn machine learning library.

AWS Postgres Python scikit-learn pandas
About Me

I'm currently available for freelance projects or full-time employment!

I love seeing data projects all the way from idea to execution. My unique experience spanning software development and consulting means I can see all the way from business value to implementation details.

In my latest role, I worked as a Senior Analytics Engineer at TIER Mobility in Berlin, Germany. At TIER, I helped build data products for our partner cities, including Berlin, Paris, and Oslo. One of the projects I'm most proud of is the Bike Lane Analysis, where I combined usage data from our vehicles with Open Street Map data to show cities the gaps in their bike lane networks.

Prior to joining TIER, I was part of the Data & Analytics team at Slalom Consulting. At Slalom, I was a data engineering consultant that worked with digital product teams at a variety of companies.

I have a bachelor's degree from the business school at the University of Minnesota, where I also completed a minor in computer science. For my thesis I analyzed the usage and equity of scooters in the Minneapolis area using geospatial techniques.

When I'm not in front of a computer screen, I enjoy running (check me out on Strava), open-water swimming, and cross-country skiing. I love learning new things and am currently working towards fluency in Norwegian - jeg har en lang vei å gå...

Skills
Languages
  • JavaScript
  • Python
  • SQL
  • Go
  • Rust
Technologies
  • Cloud Data Warehouses
  • DuckDB
  • Deck.gl
  • Kafka
Tools
  • dbt
  • Git & Github
  • Jekyll
  • bash/zsh
Viz
  • Looker
  • Deck.gl
  • Carto
  • Unfolded
  • Superset
  • Tableau
Professional Experience
Sep 2021 - Present
Senior Data Engineer, Geospatial
Jul 2019 - Aug 2021
Consultant, Data Engineering
Dec 2018 - May 2019
Intern, Data Science
Aug 2018 - May 2019
Director
May 2017 - August 2018
Intern, Data Engineering
Jan 2018 - May 2018
Intern, Business Strategy
Jun 2016 - Aug 2016
Technology Development Program
Jan 2015 - Aug 2015
Intern, Global Trading Analytics
View My Resume