Civic Data Analyst – Sustainable Mobility

Trilon Group

Civic Data Analyst at Alta Planning + Design working on sustainable mobility solutions and data analytics. Collaborating across disciplines to develop innovative analytical products and advanced transportation solutions.

Posted 7/30/2026full-timeHuntsville • Alabama • 🇺🇸 United StatesJunior💰 $65,000 - $76,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis and visualization using Python, R, and GIS to develop innovative transportation solutions. Proficient in quantitative analysis and capable of creating data-driven narratives to inform decision-making in planning contexts.

Highest-signal resume keywords

Proficiency In PythonProficiency In RGIS ProficiencyQuantitative AnalysisData Visualization

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData AnalysisCross TabulationData InterpretationCodingMachine Learning TechniquesApplied StatisticsAnalytical Solutions DesignData SpecificationsDatabase Management

Soft Skills

Strong Written CommunicationStrong Verbal Communication

Tools & Technologies

PostGISQGISArcGIS ProD3GgplotMatplotlibPlotlyTableauPowerBIDeltek VantagePoint

Certifications & Qualifications

AICP Certification

Industry Keywords

Transportation PlanningActive Transportation PlansSafety Action PlansComplete Streets PlanningMobility InsightsPublic Sector RequestsEconomic Benefit StudiesUrban PlanningEnvironmental SciencesConsulting Environment

Tech Stack

Tools & technologies

D3.jsDjangoFlaskPostGISPythonSQLTableau

About the role

Key responsibilities & impact

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.
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.
Identify 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.

Requirements

What you’ll need

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.
Master’s Degree in Urban Planning, Statistics, Data Science, Engineering, Math, or Social Sciences preferred.
1+ years of experience in a consulting environment or public entity preferred. You have experience working on responses to public sector requests for proposals.
AICP Certification preferred.
Experience using Deltek VantagePoint preferred.
Active participation in industry-relevant professional associations and committees preferred.
Demonstrated work of applied statistics or machine learning techniques to transportation challenges preferred.
Basic familiarity with deploying analytical solutions over the web with the use of Flask, Django, Fast-API, Tableau, PowerBI, ArcGIS Enterprise, or R-Shiny preferred.

Benefits

Comp & perks

Medical: PPO or HSA medical plans, Alta pays 75% of the cost
Dental/Vision: PPO, Alta pays 90% of the cost
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