"Alerted.org

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

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

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

+ Submission of online application

+ Attach cover letter to online application

+ Attach resume to online application

+ 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.

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 performance.

+ Conduct training sessions for end-users and technical teams on the integrated system.

+ Assist in defining project timelines, milestones, and deliverables for integration tasks.

+ Track integration progress and report deviations from the plan to project managers.

+ Recommend contractor selection, may review contractor and vendor billings; monitor and evaluate quality of contractor/consultant products and services; coordinate interactions and activities of vendors.

+ Analyze regulatory rules and regulatory issues for their impact on current operations.

+ May oversee certain project related production functions.

+ Support project management with administrative duties and supervision of subcontractors.

+ Performs other related duties as assigned.

Minimum Qualifications:

Education:

An associate degree in business administration, public administration, information systems, economics, finance, computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in one of the fields above or a closely-related field].

Experience:

Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

Substitution:

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Notes:

1. Applicants must meet the minimum qualifications by the final filing date unless otherwise noted.

2. One (1) year full-time experience is equivalent to 2000 hours. (2000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time experience.

Desirable Qualifications:

The stated desirable qualifications may be used to identify candidates advancing to the interview process and/or to identify job finalist(s) at the end of the selection process when referred for hiring.

+ 5 years’ experience utilizing Extract, Transform, Load (ETL) tools and methodologies for data migration.

+ 5 years’ experience working with RESTful and SOAP APIs for system integration.

+ 5 years’ experience developing integration test plans and scripts for data and application workflows.

+ 5 years’ experience with integration testing tools and methodologies.

+ 5 years’ experience with tools like JIRA, Trello, or Asana to manage tasks and track progress.

+ 5 years’ experience developing documentation using tools like Lucidchart, Visio, or Draw.io for process mapping and system design.

+ 5 years’ experience with capital project management in intelligent transportation systems related business.

+ 5 years’ experience gathering functional and technical requirements for large-scale projects across the full systems engineering lifecycle.

+ Knowledge of database functions, joins, and subqueries.

+ Ability to create and interpret data models, entity-relationship diagrams (ERDs), and data flow diagrams.

+ Proficiency in advanced Excel, Power BI, or comparable tools for data analysis and visualization.

+ Understanding of database connections, APIs, and middleware for integration.

+ Ability to test APIs using tools like Postman or Swagger.

+ Understanding of SDLC (Software Development Life Cycle) and Agile methodologies.

+ Ability to validate data integrity post-migration and identify anomalies.

+ Proficiency with Microsoft Office Suite, or similar for documenting requirements, workflows, and integration processes.

+ Familiarity with version control tools like Git for managing changes in code or documentation.

+ Skilled in designing reports and dashboards using Power BI or similar tools.

Verification:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/information-about-hiring-process#verification. Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Selection Process:

Applications will be screened for relevant qualifying experience.  Additional screening mechanisms may be used to determine candidates' qualifications.  Only those applicants who most closely meet the needs of the Agency will be invited to move forward in the selection process.

+ Information About the Hiring Process (https://sfdhr.org/information-about-hiring-process)

+ Conviction History

+ Employee Benefits Overview (https://sfdhr.org/benefits-overview)

+ Equal Employment Opportunity

+ Disaster Service Worker (https://sfdhr.org/disaster-service-workers)

+ ADA Accommodation

+ Right to Work (https://sfdhr.org/information-about-hiring-process#identification)

+ Copies of Application Documents

+ Diversity Statement (https://sfdhr.org/information-about-hiring-process#diversitystatement)

This recruitment may be utilized to fill similar positions in this classification at SFMTA.

For questions or inquiries, please contact the analyst, Melissa Lee at [email protected].

All your information will be kept confidential according to EEO guidelines.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.