Assistant/Associate Program Coordinator - Asset Management
Metropolitan Transportation Commission
Assistant/Associate Program Coordinator - Asset Management
San Francisco, CA
$87,984.00 - $128,648.00 Annually
THIS POSITION IS OPEN UNTIL FILLED AND MAY BE CLOSED AT ANYTIME
IF YOU ARE INTERESTED IN THIS OPPORTUNITY, WE ENCOURAGE YOU TO APPLY IMMEDIATELY
The Metropolitan Transportation Commission (MTC) is the transportation planning, financing and coordinating agency for the nine-county San Francisco Bay Area. For more information about MTC, visit www.mtc.ca.gov.
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. 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. We are committed to preserving the diverse communities and natural beauty that make the Bay Area a desirable place to live and work, while addressing the needs of a growing population,
The Program Coordinator - Asset Management position will be filled at either the Assistant or Associate level and is under the supervision of the Principal - Asset Management. The person in this position will support the transportation asset management program, as well as project-related database integration and analysis efforts, and manage other programs as necessary. The primary focus of the position will be on supporting the following:
- Data integration workflows and providing primary database administrative support for multiple projects;
- 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);
- Implementation of regional transit asset management systems in response to federal authorization;
- Coordination of asset management activities with the transit operators; and
- Other duties as may be assigned, to include local streets and roads and highway asset management programs as needed.
SKILLS AND ABILITIES
The ideal candidate will have the following knowledge, skills and abilities:
- Work with large and diverse data sets
- Work with a variety of spatial data formats, including ArcGIS common formats (shapefile, gdb, arcsde) and WKT/GeoJSON
- Communicate clearly and concisely (both orally and in writing)
- Create repeatable workflows for integrating disparate datasets/databases
- Prioritize and undertake multiple tasks
- Research and analyze complex and technical issues
- Document and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policies
- Carry assignments through to completion, on time and with minimal supervision
- Represent MTC and develop consensus among local agencies
- Prepare correspondence, reports, and presentations to a wide variety of audiences
- Work independently.
- Microsoft SQL Server/MySQL/PostgreSQL or transferrable knowledge of other database platforms
- Advanced Excel (Pivot Tables, Spreadsheet Models, Advanced functions, LOOKUPS, Conditional Functions, String Manipulation)
- Databases conceptual and physical design, creation, management and optimization techniques or have an understanding of data APIs and how they can be used to share data between different databases/systems
- ArcGIS / ArcGIS Server / ArcGIS Online
- Quantitative analysis
- Prior TERM Lite experience
- Knowledge of Github/Git for code version control
- Tableau or other visualization software
- Understanding of transit operations
- Understanding of capital asset costing and life cycle planning
- Understand transportation planning principles and policy
An appropriate combination of education and experience that has provided the required knowledge, skills and abilities is qualifying. A typical way of obtaining the required qualifications is:
Education: Completion of a bachelor's degree from an accredited college or university, in an appropriate field related to the area of assignment, such as transportation planning, project management, public finance, transportation engineering, economics, business or public administration, or a related discipline. (Applicants with a degree issued from an institution outside of the United States must have their transcripts evaluated by an academic accrediting service and provide proof of equivalency along with the application.). A Master's degree is preferred.
Experience: One year of experience in an appropriate field related to the area of assignment.
Preference will be given to applicants with additional professional work experience.
License/Certificate: Possession of a valid California Class C driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Under the supervision of the Principal - Asset Management, the essential duties and responsibilities include, but are not limited to, the following:
- Coordination 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).
- Support the development of workflows for the integration of spatial data from multiple project databases (e.g. Regional Transportation Plan and Transportation Improvement Program databases).
- Work 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.
- Data integration workflows and providing primary database administrative support for multiple projects.
- Perform complex policy analysis related to state and regional transportation projects and programs.
- Research and analyze complex and technical issues.
- Work with large and diverse data sets.
- Create repeatable workflows for integrating disparate datasets/databases,
- Document and translate technical analyses for policy makers and lay audiences, and apply data to practical uses for achieving broad policies,
- Maintain a regional transportation asset inventory for the Bay Area's transit systems (RTCI). Ensure data from the systems are consistent and regionally compatible.
- Analyze, synthesize, and project future needs and utilize FTA software called TERM Lite.
- Assist with activities related to a regional Safety/Vision Zero program; specifically, around development of a regional safety data system, rolling out safety policies and coordination of a regional Safety/Vision Zero task force.
- Support Transportation Asset Management implementation and policy development.
The Program Coordinator - Asset Management will perform other job related duties as assigned.
All employees at MTC are classified as Disaster Services Workers.
Moss Landing, CA 94105