Summary
Andrew Lindstrom is an Associate GIS and Data Analyst in Seattle with eight years of cross-industry experience blending urban planning, transportation policy, and financial data analytics. He applies geospatial mapping and automated data workflows to inform planning and housing research, most recently supporting BERK Consulting after graduate work at Portland State and eviction research with Evicted in Oregon. Comfortable translating complex regulatory and financial requirements into repeatable reporting pipelines, he has built Python integrations with Snowflake and automated reporting at multiple organizations. A committed transit and active-transportation advocate (trolleybuses get a shout-out), he also publishes urban planning and route-focused writing on city-hikes.com. His background in physics and competitive swimming hints at a quantitative rigor and disciplined, team-oriented approach to problem solving. Outside work he bikes, blogs about walking and hiking, and does crosswords with his wife.
8 years of coding experience
4 years of employment as a software developer
Master's degree, Urban and Regional Planning, Master's degree, Urban and Regional Planning at Portland State University
Bachelor of Science - BS, Physics, Bachelor of Science - BS, Physics at The Ohio State University