Integration Engineer– Administration Division – SF Municipal Transportation Agency (1043)

City and County of San Francisco • San Francisco, CA

2d • Hybrid

About The Position

The San Francisco Municipal Transportation Agency (SFMTA) is seeking an Integration Engineer to support the technology scope for the Train Control Upgrade Project (TCUP). This multi-year, multimillion-dollar project aims to replace the existing train control system with a state-of-the-art radio-based technology, expanding supervision of trains across the entire Muni light rail system. The role involves delivering information technology components, including expanded network infrastructure, data architecture, wireless communication systems, servers, databases, and cybersecurity. Project systems will require data integration with existing enterprise and intelligent transportation systems. This is an opportunity to work with stakeholders across the SFMTA and contribute to a project that impacts the lives of transportation service users.

Requirements

• 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].
• Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.
• One year of additional experience as described above may be substituted for the required degree.
• Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Nice To Haves

• 3+ years’ experience using APIs (REST, SOAP, MQTT, gRPC, WebSocket) for communication between systems.
• 3+ years’ experience with message queues (e.g., Azure Service Bus, Azure Event Hubs) and middleware technologies supporting asynchronous integration.
• 3+ years’ experience developing, deploying, and supporting serverless integration solutions using cloud platforms such as Microsoft Azure Functions, Azure Logic Apps, AWS Lambda, or similar technologies.
• 3+ years’ experience creating, deploying, maintaining, and troubleshooting Docker container images and containerized applications in development, testing, and production environments.
• Proficiency in at least one language (Python preferred; Java, C++, or JavaScript acceptable) to develop integration scripts, tools, or automation workflows.
• Proficiency with object-oriented software design and implementation.
• 3+ years’ experience developing, executing, and troubleshooting integration, system, and user acceptance testing using tools such as Postman, SoapUI, or similar platforms.
• 3+ years’ experience in developing software for real-time data streaming systems using asynchronous and multi-threaded design principles.
• 3+ years’ experience with communication protocols and technologies including HTTP/HTTPS, FTP/SFTP, Server-Sent Events (SSE), and other technologies used for system integration.
• 3+ years’ experience querying, mapping, transforming, and validating data in relational or non-relational environments using ETL tools or custom scripts.
• Proficiency with Git and source control practices for managing integration artifacts, scripts, and test assets.
• 3+ years’ experience developing, reviewing, or maintaining Interface Control Documents (ICDs), interface specifications, testing procedures, and technical design documentation for complex multi-system environments.
• 3+ years’ experience integrating Intelligent Transportation Systems (ITS), rail systems, transit management systems, CAD/AVL platforms, communications systems, or other operational technology environments.
• 3+ years’ experience supporting deployment, commissioning, cutover, migration, and operational readiness activities for mission-critical systems.
• Experience collaborating with diverse stakeholders and fostering an inclusive environment that values different perspectives, backgrounds, and expertise to drive effective decision-making.

Responsibilities

• Collaborate with stakeholders, vendors, project teams, and operational personnel to define requirements, coordinate testing activities, and resolve integration issues.
• Provide technical input and recommendations regarding integration approaches, interface design, system architecture, and testing methodologies.
• Create and document interface specifications, technical documents, and diagrams.
• Identify data dependencies and map between systems.
• Create scripts for data transformation and migration.
• Configure and test APIs, middleware, and messaging systems.
• Analyze, troubleshoot, and resolve integration issues across enterprise and operational technology platforms with minimal disruption to system performance.
• Implement version control and change management processes.
• Develop and execute integration, performance, reliability, and end-to-end test plans and test cases, including validation of failover and error-handling scenarios.
• Support deployment, commissioning, operational readiness, business continuity, rollback planning, incident response, and post-deployment stabilization activities for mission-critical transportation systems.
• Review and evaluate vendor-provided designs, interface specifications, test results, and technical deliverables for compliance with project requirements and agency standards.
• Support configuration management and maintenance of development, test, staging, and production integration environments.
• Performs related duties as assigned.

Benefits

• Temporary Exempt, Category 18: This position is excluded by the Charter from the competitive Civil Service examination process, shall serve at the discretion of the Appointing Officer and are considered to be "at-will" employees.
• The duration of this appointment shall not exceed 36 months.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree