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

This Opportunity

WSP is seeking a Data Analytics & Program Management Consultant to join its Critical & Emerging Technologies Team in support of a major public transit client. This role involves working on-site in Baltimore, MD 2–3 days per week and contributing to program management, data visualization, dashboard development, performance analysis, and strategic reporting efforts.

Your Impact

The consultant will support transit performance and operational data efforts across multiple modes of transportation. Key responsibilities include:

• Coordinating monthly performance meetings, including refreshing Power BI reports, validating data accuracy with subject matter experts, preparing agendas, and facilitating discussions.


• Developing and maintaining Power BI dashboards with a focus on DAX coding, visual design, and user experience.


• Conducting data literacy training sessions to support internal stakeholders’ use of dashboards and reports.


• Providing data-driven recommendations to enhance service performance and operational decision-making.


• Collaborating with stakeholders across departments to gather and refine data inputs, and improve data quality.


• Supporting performance initiatives by documenting scopes, stakeholder requirements, data sources, and tracking progress on action items.


• Working alongside WSP’s Critical & Emerging Technologies Team to develop data pipelines and coordinate other technical tasks as needed.


• Presenting analytical findings to client leadership and senior staff in a clear, actionable format.


• Managing multiple workstreams with strong prioritization, organization, and attention to detail.

Who You Are

Required Qualifications

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


• 0 to 1 years of relevant post education experience working as a data analyst or similar designation.


• Familiarity with business intelligence tools (e.g. Tableau), and big data technologies (e.g. Hadoop, Spark).


• Familiarity with computer programing databases, coding and testing (e.g. SQL).


• Familiarity with data management practices, performing exploratory data analysis, and employing research techniques.


• Analytical mindset with an ability to exercise sound judgement in evaluating situations, applying logic, and making decisions.


• Capable interpersonal and communication skills when interacting with others, and effectively articulating complex data in a simple, actionable manner.


• Capable self‑leadership with attention to detail, accuracy, multi‑tasking, and prioritization of responsibilities in a dynamic work environment.

Priority Skills:

• Strong analytical, communication, and organizational skills


• Experience presenting to client leadership and collaborating with stakeholders at multiple levels

Technical Skills:

• Intermediate to advanced proficiency in Power BI and SQL


• Experience with Python, R and AWS Data base is a plus


• On-site attendance required 2–3 days per week at the client’s Baltimore office (Inner Harbor area)


• The selected analyst must not be absent for more than 10 consecutive business days (excluding official holidays)

CORE REQUIREMENTS

• On-site attendance required 2–3 days per week at the client’s Baltimore office (Inner Harbor area)


• The selected analyst must not be absent for more than 10 consecutive business days (excluding official holidays)

Preferred Qualifications:

• A member of and/or actively participate in local professional practice organizations.

WSP provides a comprehensive suite of benefits focused on providing health and financial stability throughout the employee’s career. These benefits include coverage related to medical, dental, vision, disability, and life; retirement savings; paid sick leave; paid vacation (or other personal time); paid parental leave; and paid time off for purposes of bereavement, voting, and/or attendance at naturalization proceedings.

Compensation
Expected Salary (all locations): $70,000 - $80,000

WSP USA is providing the compensation range that the company in good faith believes it might pay and offer for this position, based on the successful applicant’s education, experience, knowledge, skills, abilities in addition to internal equity and specific geographic location. WSP USA reserves the right to ultimately pay more or less than the posted range and offer additional benefits and other compensation, depending on circumstances not related to an applicant’s sex or other status protected by local, state, and/or federal law.