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
- 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
Preferred Qualifications
- Master’s 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.
If you think you have what it takes but aren’t sure you meet all the requirements of this job, we invite you to connect with us. We value all perspectives and life experiences and want to hear about yours.
EOE AA M/F/VET/DISABILITY
Salary: $80k-95k
Bachelor's degree in transportation engineering, computer science, data analytics, applied statistics, or related field; 0-4 years experience; intermediate Python; SQL and database technologies; data visualization with Tableau or Power BI; Git/GitHub.
Key Responsibilities
- analyzing requirements
- designing databases
- developing data pipelines
Skills & Tools
Python, SQL, Tableau, Power BI, Git, GitHub, Databricks, Snowflake, BigQuery, Fabric, Airflow, Dagster, dbt
Job Details
- Category: Data and Analytics
- Seniority: Entry Level
- Commitment: Full Time
- Workplace: Remote — United States
- Salary: USD 80,000 – 95,000 / year
- Languages: English
About Cambridge Systematics
A transportation consulting firm providing innovative policy, planning, and technology solutions. — Industry: Consulting Services