What are the responsibilities and job description for the Transportation Data Analyst/Coordinator position at Metropolitan Transportation Commission?
JOB
DEADLINE TO APPLY IS SUNDAY, MARCH 9, 2025, AT 11:59 PM IF YOU ARE INTERESTED, PLEASE APPLY IMMEDIATELYA resume and cover letter are not required with your application, but highly encouraged.Be ready to rethink your assumptions about the public sector. Dedicated and motivated colleagues? Beautiful, high amenity building for on-site work and collaboration? Flexible schedules and hybrid work options? Yes, yes, and yes! ABOUT MTC MTC was created by the California Legislature in 1970. The federal government, state Legislature and Bay Area voters have assigned MTC a wide-ranging portfolio of duties. For starters, MTC is the metropolitan planning organization for the nine-county San Francisco Bay Area. MTC is also the regional transportation planning agency for the Bay Area. MTC directly distributes more than $700 million a year to local public transit agencies and other recipients, and prioritizes requests from local agencies for millions more in scarce state and federal funds. Acting as the Bay Area Toll Authority, (BATA) MTC collects in excess of $600 million a year in bridge tolls, and allocates these funds for the operation and upkeep of the region's seven state-owned toll bridges. We plan, invest and coordinate to keep the Bay Area mobile, sustainable and prosperous. At the same time as addressing the needs of a growing population, we are committed to preserving the diverse communities and natural beauty that make the Bay Area a desirable place to live and work.ABOUT THE ROLEThe Program Coordinator/Analyst, Transit and Asset Management Data role will be filled at the Assistant/Associate level and is under the general supervision of a Principal Program Coordinator. The Program Coordinator for Transit and Asset Management Data, as a member of the Funding Policy and Programs section staff, will be responsible for analyzing, visualizing, and interpreting financial and performance data related to the transit fiscal cliff, as well as the development of policy recommendations for transit funding programs. Additionally, they will manage the Regional Transit Asset Management Program, which involves tasks such as coordination with transit agency staff, database maintenance, and data analysis and visualization. The Program Coordinator may also provide data and program management assistance to various key agency projects.
EXAMPLE OF DUTIES
Project Support Transit Fiscal Cliff ResponseAnalysis of financial and performance data related to transit operations and transit operating funding shortfalls (“fiscal cliff”)Development of visualizations and dashboards using programs such as Tableau and ExcelCollaboration with transit agency staff to gather data and input on policy proposals related to the fiscal cliffAssist with administration of funding programs providing emergency operations funding, such as Senate Bill 125Transit Asset Management ProgramCoordination of asset management activities with the transit operators.Enhancement and maintenance to the existing Regional Transit Capital Inventory, (a comprehensive regional database of the transit assets that are owned by transit agencies in the San Francisco Bay Area). Supporting the development of workflows for the integration of spatial data from multiple project databases.Working with consultants, staff, and transit agencies, on strategic planning efforts related to transit asset management.Prepare and present materials for Commission consideration; follow agency procedures and standards and work cooperatively with project sponsors and MTC staff to ensure that materials are timely, accurate, and professional.Database AdministrationData integration workflows and providing primary database administrative support for multiple projects.Other - Technical/Data Analysis Research and analyze complex and technical issuesInterpret data for a general audience through dashboards and visualizationsWork with large and diverse data sets.Create repeatable workflows using scripting languages (e.g., Python, R) for integrating disparate datasets/databasesDocument and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policiesAnalyze, synthesize, and project future needs and utilizing FTA software called TERM LiteOther – Program ManagementCommunication: Provide updates to the Transit Finance Working Group on available transit funding opportunities (e.g. the Bipartisan Infrastructure Law).
SUPPLEMENTAL INFORMATION
EMPLOYMENT REQUIREMENTSSuccessful completion of a background check, professional references and the Employment Eligibility Verification Form I-9. DISABILITYThe Human Resources Department will make reasonable efforts in the recruitment or skills assessment process to accommodate applicants with disabilities. If selected for an interview or testing, and you require accommodation, please notify the Human Resources Department when confirming your interview or test.APPLICATION ASSISTANCEIf you need technical assistance with your on-line application, please contact NEOGOV's Applicant Support Line at (855) 524-5627, available from 8:00 AM to 5:00 PM (PST) Monday through Friday, excluding holidays.All MTC employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.
DEADLINE TO APPLY IS SUNDAY, MARCH 9, 2025, AT 11:59 PM IF YOU ARE INTERESTED, PLEASE APPLY IMMEDIATELYA resume and cover letter are not required with your application, but highly encouraged.Be ready to rethink your assumptions about the public sector. Dedicated and motivated colleagues? Beautiful, high amenity building for on-site work and collaboration? Flexible schedules and hybrid work options? Yes, yes, and yes! ABOUT MTC MTC was created by the California Legislature in 1970. The federal government, state Legislature and Bay Area voters have assigned MTC a wide-ranging portfolio of duties. For starters, MTC is the metropolitan planning organization for the nine-county San Francisco Bay Area. MTC is also the regional transportation planning agency for the Bay Area. MTC directly distributes more than $700 million a year to local public transit agencies and other recipients, and prioritizes requests from local agencies for millions more in scarce state and federal funds. Acting as the Bay Area Toll Authority, (BATA) MTC collects in excess of $600 million a year in bridge tolls, and allocates these funds for the operation and upkeep of the region's seven state-owned toll bridges. We plan, invest and coordinate to keep the Bay Area mobile, sustainable and prosperous. At the same time as addressing the needs of a growing population, we are committed to preserving the diverse communities and natural beauty that make the Bay Area a desirable place to live and work.ABOUT THE ROLEThe Program Coordinator/Analyst, Transit and Asset Management Data role will be filled at the Assistant/Associate level and is under the general supervision of a Principal Program Coordinator. The Program Coordinator for Transit and Asset Management Data, as a member of the Funding Policy and Programs section staff, will be responsible for analyzing, visualizing, and interpreting financial and performance data related to the transit fiscal cliff, as well as the development of policy recommendations for transit funding programs. Additionally, they will manage the Regional Transit Asset Management Program, which involves tasks such as coordination with transit agency staff, database maintenance, and data analysis and visualization. The Program Coordinator may also provide data and program management assistance to various key agency projects.
EXAMPLE OF DUTIES
Project Support Transit Fiscal Cliff ResponseAnalysis of financial and performance data related to transit operations and transit operating funding shortfalls (“fiscal cliff”)Development of visualizations and dashboards using programs such as Tableau and ExcelCollaboration with transit agency staff to gather data and input on policy proposals related to the fiscal cliffAssist with administration of funding programs providing emergency operations funding, such as Senate Bill 125Transit Asset Management ProgramCoordination of asset management activities with the transit operators.Enhancement and maintenance to the existing Regional Transit Capital Inventory, (a comprehensive regional database of the transit assets that are owned by transit agencies in the San Francisco Bay Area). Supporting the development of workflows for the integration of spatial data from multiple project databases.Working with consultants, staff, and transit agencies, on strategic planning efforts related to transit asset management.Prepare and present materials for Commission consideration; follow agency procedures and standards and work cooperatively with project sponsors and MTC staff to ensure that materials are timely, accurate, and professional.Database AdministrationData integration workflows and providing primary database administrative support for multiple projects.Other - Technical/Data Analysis Research and analyze complex and technical issuesInterpret data for a general audience through dashboards and visualizationsWork with large and diverse data sets.Create repeatable workflows using scripting languages (e.g., Python, R) for integrating disparate datasets/databasesDocument and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policiesAnalyze, synthesize, and project future needs and utilizing FTA software called TERM LiteOther – Program ManagementCommunication: Provide updates to the Transit Finance Working Group on available transit funding opportunities (e.g. the Bipartisan Infrastructure Law).
SUPPLEMENTAL INFORMATION
EMPLOYMENT REQUIREMENTSSuccessful completion of a background check, professional references and the Employment Eligibility Verification Form I-9. DISABILITYThe Human Resources Department will make reasonable efforts in the recruitment or skills assessment process to accommodate applicants with disabilities. If selected for an interview or testing, and you require accommodation, please notify the Human Resources Department when confirming your interview or test.APPLICATION ASSISTANCEIf you need technical assistance with your on-line application, please contact NEOGOV's Applicant Support Line at (855) 524-5627, available from 8:00 AM to 5:00 PM (PST) Monday through Friday, excluding holidays.All MTC employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.
Salary : $600 - $700
