Transit Data Analyst
Overview:
Kimley-Horn, one of FORTUNE Magazines 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 Baltimore and across the firm.
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.
At Kimley-Horn, our analysts benefit from hands-on experience, technical and consulting trainings, mentorship opportunities, and developmental programs geared toward growing the firms 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.
Qualifications:
Bachelors 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 a familiarity with how relational databases function (eg.
Oracle or Microsoft SQL Server) Intermediate data analysis and visualization experience using the following applications:
Flexible coding language (e.
g.
SQL, 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 Recommended Skills Adobe Acrobat Algorithms Analytical Attention To Detail Big Data Coaching And Mentoring Estimated Salary: $20 to $28 per hour based on qualifications.
Kimley-Horn, one of FORTUNE Magazines 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 Baltimore and across the firm.
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.
At Kimley-Horn, our analysts benefit from hands-on experience, technical and consulting trainings, mentorship opportunities, and developmental programs geared toward growing the firms 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.
Qualifications:
Bachelors 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 a familiarity with how relational databases function (eg.
Oracle or Microsoft SQL Server) Intermediate data analysis and visualization experience using the following applications:
Flexible coding language (e.
g.
SQL, 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 Recommended Skills Adobe Acrobat Algorithms Analytical Attention To Detail Big Data Coaching And Mentoring Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
