Systems Applications Programmer I/II - Department of Transportation

The Department of Transportation (DOT) plans, develops, operates, and maintains transportation facilities, services, and related systems which contribute to the livability and economic health of the City. We comprise a team of more than 500 people ready to serve the needs of our residents to improve the efficiency and safety of San José streets. We are an energetic and innovative team that is improving transportation in one of the nation’s largest cities, while focusing on safety, sustainability, and active public life! For more information about DOT, visit www.sanjoseca.gov/transportation. 

The Department of Transportation is supported by its own IT team.  The DOT IT team coordinates, develops, and delivers all activity surrounding technology, innovation, and strategic IT investments to support the department and transportation network of the future.   The DOT IT team works across departments to ensure that City IT governance, policies, and procedures are followed when implementing new and existing technology solutions.

The Department of Transportation is currently seeking to fill 1 or more vacancies in the Administrative Services division. If you are interested in employment in these classifications, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

 Salary ranges for these classifications are: 

• Systems Application Programmer I: $88,932.48 - $108,086.16
• Systems Application Programmer II: $98,629.44 - $119,945.28

This salary range(s) includes an approximate five percent (5%) ongoing non-pensionable compensation. Actual salary shall be determined by the final candidates’ qualifications and experience. 

Under direct supervision of the Information Systems Analyst, the System Applications Programmer (SAP) I/II will:

• Assist other DOT IT developers and GIS specialists in the design, implementation, and maintenance of applications that support various engineering, administrative, and field maintenance teams throughout the Department of Transportation;
• Partner with City service subject matter experts to develop reports, dashboards, and data visualizations that analyze operational data, monitor key performance indicators (KPIs), and identify opportunities to improve operational efficiency and support data-driven decision-making;
• Collaborate with end users to document business processes and functional requirements, develop technical specifications, conduct application training, provide technical support, and assist in implementing application enhancements;
• Develop and maintain test plans and test cases, perform regression testing following software enhancements, but fixes, and system upgrades, and verify that applications meet functional requirements and quality standards prior to release.
• Additional duties as required. 

 
Desirable skills and experience include but are not limited to:

• Experience developing Lightning Web Components, Apex, and Salesforce platform administration
• Strong database scripting knowledge (Python, SQL, etc.)
• Prior development and support experience with City/County applications 
• Working knowledge of data warehouse/lake/Lakehouse infrastructure
• Analytics experience 1-3 years preferably with Power BI 

Education: A bachelor’s degree from an accredited college or university in Computer Science, Management Information Systems, Business Administration, or a closely related field. 

Experience: One (1) year experience in computer systems applications programming.

Acceptable Substitutions: Additional years of directly related work experience may be substituted for up to a maximum of two (2) years of the educational requirement on a year-for-year basis.  There will be no substitute for the one (1) year work experience requirement.

Certifications/Licenses: Possession of a valid driver’s license authorizing operation of a motor vehicle in the State of California.

The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.

• Job Expertise: Demonstrates knowledge of and experience with applicable professional/technical principles and practices, Citywide and departmental procedures/policies and federal and state rules and regulations. In addition, knowledge and experience in the following:
  • Business intelligence, reporting and data integration
  • Salesforce development (Apex, LWC, declarative) and GIS

• Communication Skills: Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and displays openness to other people's ideas and thoughts.

• Constructive Energies: A demonstration of energy and drive that comes from within, and a willingness to approach all aspects of work with a generally positive attitude; possessing the inclination to take appropriate action rather than waiting to be told what to do; examples of Constructive Energies include but are not limited to: enthusiasm, honesty, integrity, empathy, dedication, reliable, proactive, respectful, confidence, ethical, and a willingness to help others

• Customer Service: Demonstrates the ability to anticipate customers' needs and deliver services effectively and efficiently using professional demeanor.

• Analytical Thinking: Approaching a problem or situation by using a logical, systematic, sequential approach.

• Collaboration: Develops networks and builds alliances; engages in cross-functional activities.

• Decision Making: Identifies and understands issues, problems, and opportunities; uses effective approaches for choosing a course of action or developing appropriate solutions.

• Initiative: Exhibits resourceful behaviors toward meeting job objectives; anticipates problems, is proactive, and avoids difficulties by planning ahead; displays willingness to assume extra responsibility and challenges; pursues continuing education opportunities that promotes job performance.

• Teamwork & Interpersonal Skills: Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.

Selection Process: 

The selection process will consist of an evaluation of the applicant's training and experience based on the application and responses to all the job specific questions. Only those candidates whose backgrounds best match the position will be invited to proceed in the selection process. Additional phases of the selection process will consist of one or more interviews.

If selected, the Conditional Offer of Employment may be contingent upon you providing proof of a valid State of California driver’s license, and an assessment of your California DMV Employer Pull Notice (EPN) as per the DMV Release of Driver Record Information form. Failure to pass the DMV Pull Notice assessment will deem you ineligible for employment.

If you have questions about the duties of these positions, the selection or hiring processes, please contact Keana Tran at [email protected].