Transit Data Analytics & Program Management Consultant

WSP; Baltimore (MD); On-site; USD 70,000 - 80,000; Full time

Benefits offered by this job

Comprehensive benefits package

Job summary

WSP invites a Data Analytics & Program Management Consultant to join the Critical & Emerging Technologies Team in support of a major public transit client. The role is on-site in Baltimore 2–3 days per week, contributing to program management, dashboards, performance analysis, and strategic reporting.

Responsibilities include refining data inputs, presenting findings to senior leadership, and coordinating cross-functional data efforts to enhance transit performance.

Qualifications

• Bachelor’s degree in a related field and 0–1 year of data analytics experience.
• Familiar with BI tools (Tableau) and big data technologies (Hadoop, Spark).
• Knowledge of SQL, coding and testing practices.

Responsibilities

• Coordinate monthly performance meetings, refresh Power BI reports and validate data with SMEs.
• Develop and maintain Power BI dashboards focusing on DAX, design, and UX.
• Deliver data literacy trainings to internal stakeholders.
• Provide data-driven recommendations to improve service performance.
• Collaborate across departments to gather data and improve quality.
• Document scopes, requirements, data sources, and track action items.
• Develop data pipelines and coordinate related tasks with the team.
• Present analytical findings to client leadership in a clear format.
• Manage multiple workstreams with strong prioritization and attention to detail.

Skills

Strong analytical skills

Communication skills

Organizational skills

Power BI

SQL

Python

R

AWS

Education

Bachelor’s Degree in Math, Data Analysis, Accounting, Finance or related field

Tools

Tableau

Hadoop

Spark

Job description

WSP invites a Data Analytics & Program Management Consultant to join the Critical & Emerging Technologies Team in support of a major public transit client. The role is on-site in Baltimore 2–3 days per week, contributing to program management, dashboards, performance analysis, and strategic reporting.

Responsibilities include refining data inputs, presenting findings to senior leadership, and coordinating cross-functional data efforts to enhance transit performance.