1044 Integration Engineer, TCUP (IS Engineer-Principal), Finance and IT Division - SF Municipal Transportation Agency

Application Opening: April 3, 2025

Deadline to Apply: April 18, 2025

Recruitment ID: 155993

Salary: $162,084 to $ 203,866 annually

Please Note: A cover letter and resume must be attached to the online application.

Appointment Type: Temporary Exempt (TEX).  This position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.

⚠️IMPORTANT⚠️: Your application MUST include responses to the supplemental questionnaire found here: https://forms.office.com/r/0W6vPeMDj3

Applicants must complete the supplemental questionnaire and the online application by the filing deadline. The application will not be reviewed without a completed supplemental questionnaire and vice-versa.

Division: Finance and Information Technology

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

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

Hours: Monday – Friday, 8:00am-5:00pm

About:

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.

Under the direction of the TCUP Technology Enterprise Architect, performs integration and testing of existing enterprise information systems with information systems for the new train control system (TCUP).

Examples of Important and Essential Duties:

1. Works with stakeholders to understand system requirements.
2. Creates and documents interface specifications, technical documents, and diagrams.
3. Identifies data dependencies and map between systems.
4. Creates scripts for data transformation and migration.
5. Configures and tests APIs, middleware, and messaging systems.
6. Implements version control and change management processes.
7. Develops test plans and cases for integration scenarios.
8. Conducts unit and end-to-end testing to ensure components meet requirements.
9. Tests for scalability, reliability, and latency under different loads.
10. Simulates failure scenarios to verify error handling.
11. Coordinates with operations teams for integration activities.
12. Assists in deploying the integrated system.
13. Ensures rollback plans are in place during deployment.
14. Coordinates user acceptance testing with stakeholders.
15. Performs related duties as assigned.

Minimum Qualifications

1. An associate degree in computer science, computer engineering, information systems, 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]; AND

2. Five (5) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

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.

1. Experience using APIs (REST, SOAP, gRPC) for communication between systems.
2. Familiarity with message queues (Azure Service Bus, Azure Event Hub) and middleware for asynchronous integration.
3. Proficiency in at least one language (Python preferred; Java, C++, or JavaScript acceptable) to develop integration scripts, tools, or automation workflows.
4. Proficiency with object-oriented software design and implementation.
5. Ability to write scripts for data transformation, system configuration, or test automation (e.g., Bash, PowerShell).
6. Experience in developing software for real-time data streaming systems using asynchronous and multi-threaded design principles.
7. Experience with tools for integration testing, such as Postman (for API testing) or SoapUI.
8. Experience with HTTP/HTTPS, FTP.
9. Experience building relational or non-relational queries for distributed software architectures.
10. Experience mapping, cleaning, and transforming data during integration using ETL tools or custom scripts.
11. Experience generating requirements and testing against them.
12. Proficiency in Git for managing integration artifacts and test cases.
13. Technical expertise and knowledge of intelligent transportation systems.
14. Ability to work well with a multi-disciplinary, diverse workforce, including operations staff, maintenance technicians, technical professionals, and contractors.

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
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement

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

For questions or inquiries, please contact the analyst, Tracy Pon 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.