Civic Data Analyst II

Department: Planning

Employment Type: Full Time

Location: Seattle, WA

Compensation: $80,000 – $97,500 / year

Description

Alta Planning + Design seeks a Civic Data Analyst II for our Seattle office . This position is a great opportunity for someone who believes in the importance of active, multimodal, and sustainable transportation and who is interested in growing their career as a transportation planning professional. If you are looking to join an innovative organization and do work that connects people to places while advancing social justice, safety, and environmental resilience, apply with Alta today!
About Alta
Alta Planning + Design is a sustainable transportation company dedicated to creating active, healthy communities through planning, landscape architecture, engineering, and education/encouragement programs. Alta was founded in 1996 when communities were calling for safer streets for people walking and bicycling as the non-motorized transportation movement developed into a profession in the United States. We pioneered the field of active transportation, evolving our planning and design work into a visionary global practice that empowers people to live active, healthy lives and gets them to where they need to go.  

Our core values and work bring about positive change by creating places that are geared toward moving people rather than cars, connecting community members to daily needs and human experience, and empowering every person to live an active healthy life. As a global leader in mobility innovation for over 26 years with over 200 staff, we are dedicated to connecting people to places by working across disciplines and scale to address social justice, safety, and environmental resilience.

Day to Day

Serve as a technical expert and analyst across various disciplines, project types, and regions. Develop prototypes of repeatable analysis in R, Python, and GIS to advance place-based sustainable transportation solutions. Over time, foster an entrepreneurial approach to analysis through staff training, research, tool development, and custom web applications.

Engage across Alta’s disciplines to understand data analytics needs, priorities, and expectations, fostering a data-informed decision-making culture. Lead the development of new analytical products that align with the firm’s objectives and the multidisciplinary nature of the practice. Collaborate closely with planners, designers, and engineers in tasks related to data analysis and visualization, ensuring the developed solutions bring valuable mobility insights and can scale organization wide.

Delve into data analysis and visualization components of client projects and R&D efforts, employing complex methodologies. Address mobility and access challenges through innovative analytical solutions, and articulate data-driven narratives effectively through reports, technical memos, and presentations. Be proactive in identifying labor-intensive processes and analysis, exploring avenues to streamline and automate them to create organization-wide value

Work on a range of projects including active transportation plans, safety action plans, complete streets planning, safe routes to school, new mobility plans, and economic benefit studies. Each day, you will keep a community-focused perspective by pushing forward solutions that help communities inform narratives about people, address multifaceted community goals, prepare communities for change, and build a more just transportation system. 

Qualificiations

Required

This position requires a combination of skills, experience and education including, but not limited to

• 1+ years of experience in a consulting environment or public entity. You have experience working on responses to public sector requests for proposals.
• Bachelor’s Degree in Statistics, Mathematics, Computer Science or another quantitative field with demonstrated experience in the transportation planning field, OR a Bachelor’s Degree in Planning, Landscape Architecture, Environmental Sciences, or Engineering with some experience in the software development and/or data science fields.
• Proficiency in Python and/or R, SQL
• Proficiency in Quantitative Analysis: A solid background in data analysis, cross tabulation, and data interpretation is essential. Candidates should be able to apply data driven techniques to inform evidence-based decision-making in planning and design contexts.
• Strong understanding of databases, GIS, coding, and familiarity with transportation planning at an advanced level.
• GIS Proficiency – both open-source (PostGIS, QGIS, geopandas, etc.) and the ESRI suite (ArcGISPro, Spatial Analyst, Network Analyst, etc.).
• Ability to create informative data visualizations through code (e.g. D3, ggplot, matplotlib, plotly, kepler.gl, etc.).
• Experience designing, implementing, and documenting analytical solutions using code. Ability to execute an analysis entirely with code. 
• Data specifications & database acronyms like OSM, MDS, GTFS, GBFS, GPS, CDS don’t scare you. 
• Proficient in MS Excel, Word, PowerPoint, similar products.
• Strong written and verbal communication skills. 

There are a number of additional skills, experience, and education that would be beneficial to this position including, but not limited to:

• Master’s Degree in Urban Planning, Statistics, Data Science, Engineering, Math, or Social Sciences
• AICP Certification.
• Experience using Deltek Vision.
• Active participation in industry-relevant professional associations and committees. 
• Demonstrated work of applied statistics or machine learning techniques to transportation challenges.
• Basic familiarity with deploying analytical solutions over the web with the use of Flask, Django, Fast-API, Tableau, PowerBI, ArcGIS Enterprise, or R-Shiny. 

What We Offer

Flexible ScheduleAlta offers a flexible, hybrid work schedule where most employees work from home three days per week. In-office days support our collaborative culture, one of our core values. The Seattle office is located in the heart of downtown Seattle and accessible to bike and public transit. 

Compensation
The pay range for this job in Seattle is $80,000-$97,500 annually. Placement within the range is based upon experience, skill-sets, and qualifications.

BenefitsAlta offers comprehensive benefits to all full-time employees:

• Medical: PPO or HSA medical plans
• Dental/Vision: PPO
• Life Insurance: Alta pays 100% of the premium for life and AD&D, equal to your base compensation
• 401(k): Alta provides a match up to 3%
• PTO: 21 days accrued annually to start
• Holidays: 11 total company paid holidays
• Paid Parental Leave/Short-Term Disability 
• Additional Benefits: Wellness reimbursement up to $800 annually, Alta Gets Around benefit of up to $900 annually, 5-year travel award, and professional development opportunities

*The following statements pertain to US Candidates Only*