Early Professional, Transportation Data Scientist

Overview

Analyze real-time transit data, create Power BI dashboards, and develop data pipelines for MTA.

Key Responsibilities

• data quality
• real-time analysis
• dashboard development
• data visualization
• etl pipelines
• stakeholder coordination

Tasks

-Assist with implementing systems to catch bugs and monitor data quality, ensuring production data is always accurate and available. -Provide data driven recommendations by utilizing analytical insights to improve customer experience. -Perform Real-Time Transit Operation Data Analysis: Analyze real-time transit operation data to identify trends, patterns, and opportunities for service optimization. Use statistical techniques to derive meaningful insights from the data. Develop clear and concise reports and visualizations to communicate analytical findings effectively. Provide data driven recommendations by utilizing analytical insights to improve customer experience. -Ensure data visualizations are accurate, intuitive, and facilitate data-driven decision making. -Design, develop, and maintain interactive and dynamic dashboards in Power BI and responsive webpages. -Utilize Code to Parse and Process Data: Create and optimize queries and custom scripts to clean, process, and prepare data for various analyses and reporting requirements. -Analyze real-time transit operation data to identify trends, patterns, and opportunities for service optimization. -Coordinate with Multiple Agency Stakeholders: Work closely with different departments and teams within the agency to gather data, ensure data quality and address specific analytical needs. -Collaborate with other real-time team members in building data pipelines to store and transform the data (ETL and ELT) for real-time and historical reporting purposes. -Create and optimize queries and custom scripts to clean, process, and prepare data for various analyses and reporting requirements. -Use statistical techniques to derive meaningful insights from the data. -Assist in Automating Data Flows: Collaborate with the Real-Time and MTA IT teams to automate data flows, assisting with buildout of streaming data pipelines and SQL jobs/stored procedures to reduce manual efforts and improve data accuracy. -Collaborate with the Real-Time and MTA IT teams to automate data flows, assisting with buildout of streaming data pipelines and SQL jobs/stored procedures to reduce manual efforts and improve data accuracy. -Work closely with different departments and teams within the agency to gather data, ensure data quality and address specific analytical needs. -Develop and Maintain Real-Time Reports: Design, develop, and maintain interactive and dynamic dashboards in Power BI and responsive webpages. Ensure data visualizations are accurate, intuitive, and facilitate data-driven decision making. -Develop clear and concise reports and visualizations to communicate analytical findings effectively.

Requirements

• sql
• python
• power bi
• aws
• spark
• bachelor's

What You Bring

-Knowledge in data modeling, data access, and data storage techniques in big data platforms. -Strong ability to communicate technical concepts and implications to business partners. -Experience contract management. -Prior experience supporting real-time arrival initiative for transit agencies in North America -Familiarity with D3.js or similar frameworks is a plus. -Bachelor's degree in computer science, Data Science, Information Technology, Statistics, or an related field. -Experience working with batch processing/real-time systems using various open source technologies like Spark, MapReduce, NoSQL, Hive, etc. a plus. -Strong proficiency in SQL, Power BI, and data analysis tools. Ability to code in Python/R preferred. -Excellent problem-solving skills, critical thinking and conceptual thinking abilities. -Analytical mindset with a keen eye for identifying and predicting insights from large datasets. -Comfortable with web application development for building responsive web-native dashboards and visualizations. -Knowledge of project and program management software such as Bluebeam, MS Project, and Primavera -Master’s Degree in similar, technical field -Ability to work collaboratively in a team and coordinate with multiple agency stakeholders. -Demonstrated experience in data analysis, data visualization, and report generation for technical and non-technical staff. -Familiarity with AWS data services (RDS, Redshift, Glue, Athena, Kinesis, Lambda Functions, etc.) -1 to 3 years of applicable experience. -High level of attention to detail and commitment to data accuracy.

People Also Searched For

About Wsp

-Partners with clients to create sustainable, efficient, and resilient solutions. -Known for iconic projects like the One World Trade Center and London's Crossrail. -Provides cutting-edge services in transportation, energy, water, and commercial developments. -Blends technical expertise with deep industry knowledge to solve complex challenges globally.

Sector Specialisms