Data Analyst - Transportation

Overview

Kimley-Horn's Reston, Virginia (VA) office is looking for Data Analyst graduates with 1+ years of experience to join their Transit team. This is not a remote position. 

Responsibilities

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. 

Qualifications

• Bachelor’s Degree in a relevant program (e.g., planning, engineering, or computer science) 
• Demonstrated interest in transportation, transit, and the use of data in the transportation industry 
• Understanding of transportation policy and the importance of community engagement
• Ability to apply technical skills to meet project demands and solve problems for our clients
• Passion and drive to achieve goals and create multimodal communities
• Experience in Microsoft Office (Excel, Word, and PowerPoint), Microsoft Project, and Adobe Acrobat
• 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) 
• Excellent verbal and written communication skills exhibited by experience writing reports and giving presentations to technical and non-technical audiences 
• Use of creativity to recommend solutions to challenging problems 
• Attention to detail and ability to contribute to a positive work environment 
• Clear sense of urgency and self-initiative to meet deadlines 

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

Why Kimley-Horn?

At Kimley-Horn, we do things differently. People, clients, and employees are at the forefront of who we are. Clients know we prioritize achieving their goals and growing their success. Employees know our culture and approach to business are built on a desire to provide an environment for everyone to flourish. Our commitment to quality is only as good as the people behind it— that’s why we welcome and develop passionate, hardworking, and proactive employees. We take pride in how our employee retention, robust benefits package, and company values have led to Kimley-Horn’s placement on the Fortune “100 Best Companies to Work” list for 18 years!

Key Benefits at Kimley-Horn

• Exceptional Retirement Plan: 2-to1- company match on up to 4% of eligible compensation (salary + bonus) and additional profit-sharing contribution.
• Comprehensive Health Coverage: Low-cost medical, dental, and vision insurance options.
• Time Off: Personal leave, flexible scheduling, floating holidays, and half-day Fridays.
• Financial Wellness: Student loan matching in our 401(k), and performance-based bonuses.
• Professional Development: Tuition reimbursement and extensive internal training programs.
• Family-Friendly Benefits: New Parent Leave, family building benefits, and childcare resources.