Transportation Analyst

Cambridge Systematics, Inc.; Medford (MA); On-site; USD 80,000 - 95,000; Full time

Job summary

Cambridge Systematics, Inc. is seeking a Transportation Analyst in the United States to support travel demand modeling, asset management, and performance monitoring across transportation sectors.

You will develop scalable data processing, analysis, and visualization solutions, turning messy data into actionable insights, while collaborating with cross-functional experts. The role emphasizes designing database solutions, producing production-ready code for cloud environments, and contributing to

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

Skills

Python

SQL

Communication

Git/GitHub

Data Visualization

Education

Bachelor's degree

Master's degree

Tools

Tableau

Power BI

Databricks

Snowflake

BigQuery

Fabric

Airflow

dbt

Dagster

JavaScript

Job description

Cambridge Systematics, Inc.

EOE AA M/F/VET/DISABILITY

Category

Digital Transformation

Location

Open, United States

Position Title

Transportation Analyst

Description

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 cloudExperience 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

Equal Opportunity Statement

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.

We value all perspectives and life experiences and want to hear about yours.

Salary: $80k-95k

Equal employment opportunity, including veterans and individuals with disabilities.

PI287948817