Program data coordinator

Posting Date:

10/23/25

Department:

Transportation - Human Resources

Job Code:

X997 (#1482)

Sequence #:

Number of Hours Per Week:

19.5 hours/week, 3 or more days per week

Additional Work Hours Information:

Union Affiliation:

None

# of openings:

1

Type of Employment:

Regular

Civil Service Type:

None

ABOUT THE ROLE:

The Parking and Transportation Demand Management (PTDM) Ordinance is a national model for improving mobility and access, reducing congestion and air pollution, and increasing traffic safety by promoting walking, bicycling, public transit, and other sustainable modes.

DUTIES & RESPONSIBILITIES

Under the supervision of the PTDM Officer, the TDM Program Data Coordinator will be responsible for a variety of tasks related to annual TDM Program reporting, including database administration, bug tracking and testing, data analysis and visualization, user support, tracking and reviewing annual reports, and other areas as needed. In addition, the candidate will provide basic administrative support to the TDM Program.

Responsibilities include:

• Serve as the primary contact with the software vendor for the City’s cloud-based TDM data management system (OneCommute, an application built on Salesforce) to manage, improve, and test the system.
• Act as administrator for the TDM Program’s OneCommute package, managing user setup, roles, profiles, field changes, and data updates and exports and keeping up to date with Salesforce platform updates.
• Manage error tracking and perform thorough testing of system updates to ensure they meet business requirements and function as expected.
• Serve as the OneCommute Business Analyst, translating TDM Program needs into system enhancements and streamlining processes.
• Track and review annual reports from TDM Program properties for completeness and compliance with deadlines and project commitments.
• Communicate with property owners as part of the annual transportation monitoring and reporting processes.
• Serve as the first point of contact for OneCommute/Salesforce-related questions and issues from internal and external users, ensuring swift resolution or escalation as needed.
• Provide training and guidance to external users of the OneCommute system.
• Create and maintain training documents for internal use.
• Assist the PTDM Officer in managing, analyzing, and visualizing TDM Program data for internal use or to fulfill external requests.
• Oversee data integrity and ensure data quality through regular audits and data cleanup.
• Develop and maintain reports and dashboards in OneCommute.

MINIMUM QUALIFICATIONS:

• Excellent analytical skills and attention to detail.

• Ability and commitment to check data sets and analysis for accuracy.

• Strong quantitative skills using advanced Excel.

• Strong querying language skills (SQL or other query language).

• Excellent project planning and organizational skills.

• Excellent interpersonal, listening, oral and written communication skills.

• Strong software testing skills.

• Proficiency in maintaining data management integrity, including the accuracy, consistency, and reliability of data.

• Ability to make a two-year commitment.

Preferred qualifications:

• Experience in TDM and sustainable transportation planning.

• Expert quantitative analysis and critical reasoning skills to structure and carry out analyses using R or other statistical software.

• Experience with Salesforce products (e.g. OneCommute).

• Demonstrated ability to translate business requirements to solutions and the ability to work with technical teams to deliver these solutions.

Hours: 19.5 hours/week, 3 or more days per week

This is a part-time, non-management, non-benefitted position. After training, the position is eligible for remote work under the City’s remote work policy.

SUMMARY OF PART-TIME BENEFITS:

• Sick Incentive Pay Eligible

• City employee commuter benefits (MBTA pass subsidy, Bluebikes membership)

Full time schedule is Monday 8:30am-8:00pm, Tuesday-Thursday 8:30am-5:00pm, Friday 8:30pm-12:00pm

REQUIRED DOCUMENTS:

Please upload the following documents to complete your application:

• Resume

• Cover Letter

ABOUT THE CITY OF CAMBRIDGE

The City of Cambridge is a diverse and vibrant community that 120,000 residents of different ethnic, racial, religious, U.S. nationals and other backgrounds call home. We take pride in our City’s diversity and strive to create a workplace that is reflective of the community we serve - one in which all employees can thrive. The City is also deeply committed to creating an environment in which all our employees are treated equitably and feel included. In joining our team, you would work in a workplace environment that advances and values antiracism, diversity, equity, and inclusion (ADEI), and that is committed to embedding ADEI best practices and tenets in all aspects of our work. City of Cambridge residents are especially encouraged to apply to job openings.

EQUAL OPPORTUNITY / AFFIRMATIVE ACTION

The City of Cambridge is an Affirmative Action/Equal Opportunity Employer and does not discriminate based on race, color, sex, religion, age, national origin, disability, or any other protected category. Women, minorities, veterans, members of the LGBTQ+ Community, and persons with disabilities are encouraged to apply. The City is committed to advancing a workforce culture of antiracism, diversity, equity, and inclusion. Auxiliary aids and services, written materials in alternative formats, and reasonable modifications in policies and procedures will be provided to qualified individuals with disabilities free of charge, upon request by contacting Human Resources at [email protected].