Transportation Analyst in Medford, Massachusetts at Cambridge Systematics, Inc.

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