Applications Systems Analyst / Developer III

Manages and maintains complex applications systems; designs, develops, and enhances computer applications systems; manages the process of designing and developing high performance platform and/or platform components; performs as technical lead for project and/or support teams, that may include various Information Technology personnel, technical contractors, consultants, or other internal or external entities; and ensures platform is meeting the needs of stakeholders for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (JPB), and the San Mateo County Transportation Authority (TA).

• Acts as technical team expert and maintains responsibility for analysis, design, and implementation of projects as assigned, including complex and highly specialized applications
• Hands on Development experience in various technologies
• Designs, develops, and enhances applications systems on behalf of client departments
• Conducts the most complex programming, system analysis, and design of highly complex systems using Information System Development Methodology in a multi-platform infrastructure and environment
• Consults and advises user departments and other Division of Innovation & Technology support teams on system requirements and enhancements and supports large computer systems for various departments
• Recommends approval of system designs and interacts with user department in a senior technical capacity
• Leads technical personnel in support of related systems
• Monitors and maintains systems health and security
• Performs data manipulation
• Identifies, diagnoses, and resolves highly difficult problems in large highly complex applications systems using highly proactive problem management, diagnosis, and resolution methods/techniques
• Defines technical development and security guidelines
• Sets guidelines and exercises technical skills to establish and meet target dates on large and highly complex projects involving multiple systems
• Spearheads the preparation of project reports such as technical overviews, client recommendations, alternatives to business requirements, feasibility studies, project proposals, and requests for proposals for the purchase of new software and hardware
• Leads consultants in the analysis, design, implementation, and integration of application business systems
• Leads the evaluation, configuration, implementation, and integration of commercial off-the-shelf (COTS) software
• Develops software and hardware specifications and standards
• May provide 24-hour and 7-days per week support as required.
• Manages projects within a defined budget and schedule set by management
• Provides guidance, coaching, mentoring, training, and oversight for assigned employees in area of expertise
• Perform other related job duties as required

Sufficient education, training, and experience to demonstrate the knowledge and ability to successfully perform the essential functions of the position. In lieu of a degree, work-related experience that demonstrates the skills and experience necessary to perform this role will be accepted. Development of the required knowledge and abilities is typically obtained through but not limited to:

Education:

• Bachelor’s degree in computer science, Business Information System Technology, Computer Engineering, or a related field; Master’s degree in a related field preferred

Experience:

• Ten plus (10+) years of progressively responsible experience in application development, enterprise application support, systems integration, technical administration and designing applications and systems. Five+ (5+) years of technical experience working knowledge in the area of assignment.

Knowledge of (defined as a learned body of information that is required for and applied in the performance of job tasks)

• Theories, principles, and practices related to information systems and supported business areas
• Applicable local, state, and federal laws, rules, and regulations governing information systems for a public agency
• Project management methodology, techniques, and tools
• Mathematics used in complex business applications
• Problem solving techniques
• Principles of supervision
• Software and computer operating systems
• For IT Data & Analytics Positions Analytics systems (Power BI, Tableau, Snowflake, etc.), AI tools (Claude, CoPilot, etc.) and business process and systems process modeling

• For Transit application positions Trapeze, Hexagon, Hastus, CAD/AVL, APC, GTFS, fare/payment systems, transit asset-management systems

• For Enterprise application positions, PeopleSoft HCM & FSCM, Oracle Fusion Applications, Oracle Enterprise Performance Management (EPM), Salesforce
• Technical development proficiency in various development technologies like Oracle, Microsoft, Salesforce or Other Open-Source platforms.

Skill in (defined as the proficient manual, verbal, or mental utilization of data, people, or things)

• Communicating effectively orally and in writing
• Analyzing situations, identifying problems, finding and implementing solutions, and evaluating outcomes in a cost-effective manner
• Troubleshooting and correcting operations problems
• Interacting professionally with internal and external representatives
• Clearly defining system integration and interface requirements
• Data analysis and data modeling
• Learning new technology and complex systems
• Identifying opportunities for innovation
• Operating a personal computer, computer terminal, and general office equipment

Ability to (defined as a present competence to perform an observable behavior or produce an observable result)

• Lead the design and development of complex information systems using software engineering techniques
• Resolve highly difficult problems regarding highly complex programming and systems logic
• Perform highly complex systems implementation and integration tasks
• Perform complex programming in various languages such as SQL (Structured Query Language), PL/SQL (Procedural Language for SQL), HTML, XML Publisher, CSS (Cascading Style Sheets), SQL Server, Oracle applications, Oracle Developer, Oracle Database Management System, Power BI, Snowflake, Github, JavaScript, AngularJS, Java Developer, Python, MS SQL Server, VB (Visual Basic), Visual Studio, C/C+/C++, or other specified languages.

• Develop integrations using Integration Platform, REST/SOAP APIs, file-based interfaces, ETL processes, job scheduling and message-based integrations.

• Provide technical project management across multiple projects and concurrent tasks
• Develop and implement web-based computer applications
• Analyze and evaluate system changes to determine feasibility
• Clearly define system integration and interface requirements
• Identify and resolve conflicting project and/or client requirements
• Understand, interpret, and apply laws, business rules, regulations, policies, procedures, contracts, budgets, and labor/management agreements to support business processes
• Prepare reports, proposals, presentations, and correspondence in a professional manner
• Exercise sound judgment and creativity in making decisions
• Meet tight time constraints and frequent deadlines
• Maintain confidentiality regarding sensitive information
• Read, write, speak, and understand English

• This job specification is not to be construed as an exhaustive list of duties, responsibilities, or requirements
• The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job