1054 IS Business Analyst-Principal, Administration Division, TCUP - SF Municipal Transportation Agency

Company Description

APPOINTMENT TYPE:  Temporary Exempt – Full Time not to exceed three (3) years - This position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the Appointing Officer.

Application Opening: July 23, 2025
Deadline to Apply: 11:59pm Pacific Time on August 7, 2025

Salary: $149,994 to $188,682 annually

Recruitment ID: 155470

Division: Administration

Unit(s): Technology Solutions and Integration – Data Services

Location: One South Van Ness Avenue, 3rd Floor, San Francisco, CA

Hours: Monday – Friday, 8:00 AM - 5:00 PM
 

⚠️IMPORTANT⚠️:  A completed application must include the following by the filing deadline:

1. Submission of online application
2. Attach cover letter to online application
3. Attach resume to online application
4. Submission of supplemental questionnaire only found here: https://forms.office.com/r/BNBqQnAbA6

Company Description:

The San Francisco Municipal Transportation Agency (SFMTA) is a department of the City and County of San Francisco responsible for the management of all ground transportation in the City. The SFMTA has oversight over the Municipal Railway public transit (Transit Division or “Muni”), as well as bicycling, paratransit, parking, traffic, walking, and taxis. SFMTA is currently in the process of implementing an upgrade of the technology used to manage light rail operations on the surface and in the subway.

The Train Control Upgrade Project (TCUP) is a multi-year, multimillion dollar project with the goal of replacing the existing train control system onboard vehicles and in the Muni Metro subway with a state-of-the-art radio-based technology. TCUP will expand supervision of trains by the train control system from the subway to the entire surface Muni light rail system. The TCUP vendor contract and installation work will be managed by a project management team within the Transit Division (“Muni”).

Information Technology is at the core of TCUP. SFMTA’s Technology Solutions and Integration (TSI) team will be delivering the technology scope for TCUP. The role will be supporting delivery of the information technology components.

Success requires significant investments in expanded network infrastructure, data architecture, wireless communication systems, servers, databases, and cybersecurity. Project systems will need data integration with existing enterprise and intelligent transportation systems. Changes need to be baselined, documented, designed, implemented, and tested.

This is an opportunity to work with stakeholders and business units across the SFMTA and take a pivotal step in your career. Your work will impact the lives of all users of our transportation services and infrastructure.

Job Description

Position Description:

Under the direction of the TCUP Technology Project Manager, the Business Analyst analyzes, plans, and executes changes to support data, database, and application integration of a new train control system into existing enterprise information systems.

Examples of Important and Essential Duties

• Collaborate with stakeholders to gather functional and technical requirements for data and application integration.
• Conduct gap analysis between the current enterprise systems and the new information system.
• Analyze existing enterprise data models and assess compatibility with the new system’s schema.
• Design and document data migration strategies, including mapping, transformation, and cleansing processes.
• Define database access policies and ensure compliance with enterprise standards.
• Collaborate with technical teams to design and implement APIs, middleware, or custom connectors for data and application integration.
• Define and document the interactions and dependencies between systems.
• Develop comprehensive integration test plans and scripts for data and application workflows.
• Act as a liaison between business users, IT teams, and third-party vendors to ensure alignment.
• Communicate technical concepts in business-friendly language to non-technical stakeholders.
• Create detailed documentation of integration processes, workflows, and configurations.
• Develop user manuals, integration guides, and best practices for stakeholders.
• Define SLA/KPI requirements for monitoring and reporting system perfo