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 ABOUT MTC 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 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. About the Position 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: Ability to: 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. Knowledge of: 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 Desirable Skills/Experience: Prior TERM Lite experience Knowledge of Github/Git for code version control Tableau or other visualization software Front end web development HTML, Javascript, CSS. (Bootstrap and Angular JS are a plus) Understanding of transit operations Understanding of capital asset costing and life cycle planning Understand transportation planning principles and policy MINIMUM QUALIFICATIONS 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: Project Support: 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. Database Administration: Data integration workflows and providing primary database administrative support for multiple projects. Policy Analysis: Perform complex policy analysis related to state and regional transportation projects and programs. Technical/Data Analysis: 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. Policy Development: 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.