Transportation Analyst

North American Transportation Management Institute; Medford (MA); On-site; USD 80,000 - 95,000; Full time

Job summary

Cambridge Systematics, Inc. is seeking a Transportation Analyst to contribute to travel demand modeling, asset management, operations, and performance monitoring.

You will work cross-functionally to develop scalable data processing, analysis, and visualization solutions that turn messy data into actionable insights. The role emphasizes collaboration, design of database solutions, and production-ready code in cloud environments, with strong Python and SQL capabilities and experience in data

Qualifications

• Bachelor's degree in Transportation Engineering, Computer Science, Data Analytics, Applied Statistics, Data Science, or related field.
• 0-4 years of applicable experience.
• Intermediate Python programming capabilities.
• Proficiency in SQL and database technologies, including knowledge of data modeling and data warehousing principles.
• Experience with data visualization software such as Tableau or Power BI.
• Ability to collaborate effectively using Git/GitHub.
• Excellent oral and written communication skills.

Responsibilities

• Analyzes requirements to understand technical and business implications.
• Designs and implements database solutions to support projects and tools.
• Designs data analysis/data engineering methods to meet today7s needs, while providing for likely future needs.
• Develops production ready code that is applied in the cloud.
• Provides clear, concise, and thorough documentation as required.
• Produces and delivers exceptional quality work that is thorough, polished, and reflects well on CS.
• Possesses the technical skill necessary to complete assignments effectively and efficiently.
• Adapts quickly to new project contexts and learns new tools and technologies quickly.
• Identify opportunities to address client requirements through the development of innovative data analysis/data engineering solutions.
• Learn new tools and technologies as appropriate.

Skills

Python

SQL

Data visualization

Git/GitHub

Communication

Education

Bachelor's degree in Transportation Engineering, Computer Science, Data Analytics, Applied Statistics, Data Science, or related field

Tools

Tableau

Power BI

Job description

Cambridge Systematics, Inc.

EOE AA M/F/VET/DISABILITY

Category: Digital Transformation

Location: Open, United States,

Position Title: Transportation Analyst

Cambridge Systematics, Inc. (CS) is shaping the future of transportation. We are industry leaders, transportation specialists dedicated to ensuring that transportation investments can deliver the best possible results. By providing innovative policy and planning solutions, objective analyses and technology applications, we help our clients anticipate and meet future transportation needs while improving the performance of existing infrastructure and operations. Above all, we are committed to our clients success in making transportation better for future generations.

The Analytics business unit works to research, develop, and apply innovative and practical decision support tools, including transportation models. Our practice is built on a foundation of expert skills, quality assurance, customer service, and effective teamwork. We successfully leverage a variety of planning, engineering, market research, statistical analysis, visualization, and software development and application techniques to provide insights into existing conditions and problems, forecast alternative outcomes, and explain complex traveler (and consumer) behavior mechanisms.

The Analyst will contribute to our delivery of innovative, practical tools that support travel demand modeling, asset management, operations and performance monitoring, transit planning, location-based services analytics, and other disciplines within CS. Working cross-functionally with subject matter and technical experts, the Analyst will develop and engineer scalable, repeatable data processing, analysis, and visualization solutions that turn messy data into actionable insight. The Analyst may also be asked to contribute to business development and project management activities.

Essential Duties and Responsibilities

• Analyzes requirements to understand technical and business implications
• Designs and implements database solutions to support projects and tools
• Designs data analysis/data engineering methods to meet today's needs, while providing for likely future needs
• Develops production ready code that is applied in the cloud
• Provides clear, concise, and thorough documentation as required
• Produces and delivers exceptional quality work that is thorough, polished, and reflects well on CS
• Possesses the technical skill necessary to complete assignments effectively and efficiently
• Adapts quickly to new project contexts and learns new tools and technologies quickly
• Identify opportunities to address client requirements through the development of innovative data analysis/data engineering solutions
• Learn new tools and technologies as appropriate

Position Requirements

• Bachelors degree in Transportation Engineering, Computer Science, Data Analytics, Applied Statistics, Data Science, or related field
• 0-4 years of applicable experience
• Intermediate Python programming capabilities
• Proficiency in SQL and database technologies, including knowledge of data modeling and data warehousing principles
• Experience with data visualization software such as Tableau or Power BI
• Ability to collaborate effectively using Git/GitHub
• Excellent oral and written communication skills

Preferred Qualifications

• Masters degree in Transportation Engineering, Computer Science, Data Analytics, Applied Statistics, Data Science, or related field
• Experience managing analytics in an enterprise environment
• Experience developing production ready code and applying in the cloud
• Experience with one or more cloud-based analytics platforms such as Databricks, Snowflake, BigQuery, or Fabric
• Ability to build scalable data pipelines with modern technologies such as Airflow, Dagster, and dbt
• Working knowledge of continuous-integration/continuous-delivery systems
• Front-end development experience using JavaScript frameworks

Cambridge Systematics is an equal opportunity employer. We strive to create a culture in which every voice is valued, where employees have a sense of belonging and connection with one another and to the organization, and they feel empowered to do their best work. We are committed to providing an inclusive culture within the firm and we encourage people of all backgrounds to apply to our open positions.

Salary: $80k-95k

PI287948696