Transportation Data Analyst Jobs

Kimley-Horn, one of FORTUNE Magazine’s “100 Best Companies to Work For,” is seeking an ambitious data analyst and transportation enthusiast to support the transit and planning practice areas local to Northern Virginia and across the firm.

At Kimley-Horn, our analysts benefit from hands-on experience, technical and consulting trainings, mentorship opportunities, and developmental programs geared toward growing the firm’s next generation of leaders. You will have opportunities to quickly gain exposure to client interactions, project financials, and serve in task management roles. As a valuable addition to our team, you will solve complex problems, exercise creativity, and collaborate with partners to provide excellent products for our clients. Your contributions will support the missions of embracing technology in transportation design, using advanced analytic techniques to make better informed decisions, and leverage cutting-edge data to advance the transportation industry. The successful candidate will have a strategic mindset and a passion for public transportation/transit planning projects and data. 

Our team is looking for an analyst to support data analysis and evaluation using a variety of data analysis platforms (e.g., advanced Microsoft Excel, VBA, Python, R, Power BI, and Tableau). The sources of data will vary from project to project, but will include GTFS data, ridership data, socioeconomic data, and data generated by in-house algorithms. You would be responsible for initial data cleaning, data processing and advanced computing techniques, and final presentation of data in easy-to-understand tables and graphics. 

• Intermediate data analysis and visualization experience using the following applications:  
  • Flexible coding language (e.g., Python or R) 
  • Advanced applications of Microsoft Excel, including exposure to VBA coding 
  • Data visualization platforms (e.g., Power BI or Tableau) 
• Ability to apply technical skills to meet project demands and solve problems for our clients
• Use of creativity to recommend solutions to challenging problems 
• Understanding of transportation policy and the importance of community engagement
• Flexible coding language (e.g., Python or R) 
• Bachelor’s Degree in a relevant program (e.g., planning, engineering, or computer science) 
• Experience in Microsoft Office (Excel, Word, and PowerPoint), Microsoft Project, and Adobe Acrobat
• Advanced applications of Microsoft Excel, including exposure to VBA coding 
• Demonstrated interest in transportation, transit , and the use of data in the transportation industry 
• Passion and drive to achieve goals and create multimodal communities
• Excellent verbal and written communication skills exhibited by experience writing reports and giving presentations to technical and non-technical audiences 
• Clear sense of urgency and self-initiative to meet deadlines 
• Attention to detail and ability to contribute to a positive work environment 
• Data visualization platforms (e.g., Power BI or Tableau) 

Preferred qualifications: 

• Advanced understanding of Python coding and experience with common data analysis packages, python dashboards, and object-oriented programming 
• Transportation and transit -related industry experience (e.g., university coursework, internships, full-time positions) 
• Experience working with Big Data