DATA FOR THE PEOPLE
DATA FOR THE PEOPLE

Ben Carneiro is a web developer in Austin, TX.

Ben makes free, public tools for government data

ben@roadway.report

Resume

512 632 2715

Photo of Me Photo of Me
  • Web Application Development
  • Database Architecture
  • Data Modeling
  • Data Engineering
  • Systems Administration (Linux)
  • Deployment / Testing
  • Information Security
  • Programming Languages
    • Python
    • Ruby
    • Go
    • Javascript / CSS / HTML
  • Frameworks
    • Django
    • django-ninja
    • Rails
    • Flask
    • FastAPI
    • ReactJS
    • HTMX
  • Databases
    • PostGIS
    • MySQL
    • PostgreSQL
    • Sqlite
    • T-SQL
    • Snowflake
    • Databricks
  • GIS Tech
    • PostGIS, GeoDjango, GeoPandas, shapely, ArcGIS, QGIS, Maplibre, Mabox, tippecanoe, pmtiles, Leaflet, Folium
  • Data & Analytics
    • Pandas, matplotlib, Metabase, Tableau, ArcGIS, QGIS, sklearn, recharts, chartJS, google sheets, pyspark, apache spark, databricks, dbt, kafka, kinesis
WORK
WORK

roadway.report

roadway.report

"The Nationwide Vision-Zero Map"

Chicago
NYC
Los Angeles
Miami
A chart of pedestrian fatalities (They're going up)
A Chart of bicycle fatalities (they're going up)
THe whole death map
Pedestrian fatalities are up up up!

censusmaps.org

censusmaps.org

Make Demographic Maps of Any US City


Los Angeles
Chicago
Phoenix
Phoenix
Phoenix
Los Angeles
Los Angeles
Phoenix

transit.observer

transit.observer

Search public transit data for any agency in the USA


King County Pandemic Recovery
LIRR Pandemic Recovery
Cost per Passenger Mile Traveled (Austin)
Fare Recovery Ratio (Austin)
Passengers per hour of vehicle service
Passengers per hour of vehicle service
Passengers per hour of vehicle service
cost per passenger mile traveled
EXPERIENCE EXPERIENCE

2025

Full-Stack Bartender

  • Searching for the right place to pursue a meaningful career
  • Willing to relocate
  • Bonus points for Public Sector / Public Interest Jobs
  • Bonus points for work with GIS, Web Development, or Databases

2024

Engineer, Founder @ roadway.report

Hacked all summer to release roadway.report, The Nationwide Vision-Zero Map.

  • roadway.report is a map of every traffic death in America
  • Led end-to-end development of data-driven platform, achieving 100K+ unique users
  • Engineered high-performance PostGIS database architecture handling 100M+ requests, delivering nationwide traffic mortality visualization data through Python/Django
  • Engineered FOSS API infrastructure enabling developers to generate location-specific mortality data visualizations across United States jurisdictions

2024

Engineer, Founder @ censusmaps.org

  • Built a web-application to let users make free demographic maps from US Census data
  • Leveraged PostGIS, Python, and Django to launch a dynamic web platform, enabling users to generate interactive 3D demographic visualizations
  • Streamlined census data access and visualization processes
  • Enabled user-friendly GeoJSON export functionality, empowering users to create customized mapping solutions with comprehensive demographic data

2024

Tour Guide @ Hippie City Bike Tours

I started running bike tours out of my apartment. I also built the website. Book a tour today at hippie.city

2023

Data Engineer (Contract) @ WizeHire

  • Designed a financial data warehouse, enhancing data accessibility and decision-making processes.
  • Implemented end-to-end ETL architecture integrating financial data from multiple sources
  • Streamlined data integration from Stripe, Salesforce, and PandaDoc, establishing robust pipelines for real-time financial reporting and analysis
  • Developed mission-critical dashboards tracking key metrics including MRR, ARR, and CAC, enabling data-driven decision making across business operations
  • Utilized free technology (Python, Django, Linux, MySQL, CRON) to eliminate cloud computing costs, ensuring cost-effective solutions

2023

Engineer, Founder @ transit.observer

  • Developed comprehensive transit analysis tool, enhancing data accessibility and decision-making
  • Implemented end-to-end system architecture, managing MySQL database design, Python / Django API development, and ReactJS frontend integration for seamless user experience.
  • Pioneered development of intuitive visualization tools that transform raw transit data into actionable performance metrics for stakeholders

2021-2022

Intern -> Software Engineer @ Wizehire

  • Engineered full-stack Django/React solutions while building robust ETL pipelines, enhancing data operations and streamlining cross-departmental analytics workflows
  • Implemented automated lead generation workflows and commission tracking systems, driving operational efficiency and sales team productivity
  • Executed critical data recovery protocols and migration strategies, ensuring data integrity while maintaining comprehensive audit trails
  • Developed custom SQL solutions for complex analytics challenges, enabling data-driven decision making across departments
  • Partnered with analysts to optimize KPI dashboards, resolve SQL complexities

2020

Auditing the Bus

  • Learned to code by auditing CapMetro's finance and performance
  • Initial experience with data processing and data visualization in python

2020

Pandemic

"Wow I don't want to be a waiter!"

2016-2020

Bullshit Jobs

  • I served something in the neighborhood of half a million people
  • Yes, the dressing is on the side

2013-2016

Radio-Television-Film @ University of Texas

  • Minors in Chemistry, Math
  • Proficient in Media Production / Post-Production
  • Sound Recording
  • I made a LOT of really weird art about clowns