Data Analytics & Program Management Consultant

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.

#LI-AC1

About WSP

WSP USA is the U.S. operating company of WSP, one of the world's leading engineering and professional services firms. Dedicated to serving local communities, we are engineers, planners, technical experts, strategic advisors and construction management professionals. WSP USA designs lasting solutions in the buildings, transportation, energy, water and environment markets. With more than 15,000 employees in over 300 offices across the U.S., we partner with our clients to help communities prosper.

www.wsp.com

WSP provides a flexible and agile workplace model while meeting client needs. Employees are also afforded a comprehensive suite of benefits including medical, dental, vision, disability, life, and retirement savings focused on providing health and financial stability throughout the employee’s career.

At WSP, we want to give our employees the challenges they seek to grow their careers and knowledge base. Your daily contributions to your team will be essential in meeting client objectives, goals and challenges. Are you ready to get started?

WSP USA (and all of its U.S. companies) is an Equal Opportunity Employer Race/Age/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Disability or Protected Veteran Status.

The selected candidate must be authorized to work in the United States.

NOTICE TO THIRD PARTY AGENCIES:

WSP does not accept unsolicited resumes from recruiters, employment agencies, or other staffing services. Unsolicited resumes include any resume or hiring document sent to WSP in the absence of a signed Service Agreement where WSP has expressly requested recruitment/staffing services specific to the position at hand. Any unsolicited resumes, including those submitted to hiring managers or other business leaders, will become the property of WSP and WSP will have the right to hire that candidate without reservation – no fee or other compensation will be owed or paid to the recruiter, employment agency, or other staffing service.