Systems Applications Programmer, Senior

Salary: $123,658.08 - $150,368.40 Annually
Location : San Jose Metropolitan Area
Job Type: Full-Time
Job Number: 202300694
Department: Public Works
Opening Date: 10/04/2024
Closing Date: 10/28/2024 11:59 PM Pacific
Our diverse and inclusive workforce of more than 7,000 employees play a key role in the success of San José, the heart of the Silicon Valley. All City of San José employees work together as one team to make San José a vibrant, innovative, and desirable place to live and work. Visit to learn more about our One Team Leadership Values and Expectations, including quality and excellent customer service and here to learn more about San José.
About the Department
The City of San José, the Capital of Silicon Valley, is one of the nation's best managed cities and one of the top ten cities in which to live, work, and do business. Moreover, San José is the center of cultural, government and economic activity for the region. The employees of the City of San José have embraced the following values: Integrity, Innovation, Excellence, Collaboration, Respect and Celebration. The City's Public Works Department is seeking an individual whose values align with the values of the City's employees.
The Department of Public Works is responsible for delivering capital improvement projects for a wide variety of City facilities and infrastructure, maintaining City facilities and fleet assets, facilitating, and regulating development activities, and providing animal care and services. The Department is committed to high-quality service, partnering with the community, and providing an excellent environment in which to work.
Position Duties
The Department of Public Works is recruiting to fill a Senior Systems Applications Programmer (Sr. SAP) position to support Animal Care and Services (ACS). The focus of this position is to develop and maintain technology solutions that will maximize the effective delivery of City services.
Salary range(s) for this classification is $123,658.08 - $150,368.40 annually. 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.
Key responsibilities and duties may include but are not limited to the following:

• Manage enterprise databases, including developing complex queries, data cleansing, integration, and reporting.

• Develop and maintain intelligent dashboards and reports using business intelligence reporting and analytics software, including Tableau, Microsoft Power BI, and SAP Crystal Reports.

• Build integrations between various business systems and platforms, including on-premises and SaaS platforms.

• Administer on-premises client-server applications and various web-based applications and subscription services.

• Interact with business staff and end users to gather requirements, coordinate validation, conduct training, provide support, and promote effective adoption and use of technical tools.

• Write documentation, including user guides, technical operating procedures, functional requirements, and scope of work.

This is a hands-on technical role requiring a candidate with strong data analysis and troubleshooting skills, who will take full ownership of projects and work independently to develop solutions and resolve complex technical issues.
The ideal candidate will possess the following key qualifications:

• Thorough knowledge of databases (SQL and/or Oracle) and ability to develop complex SQL queries, views, and scripts.

• Proficiency with analytics and reporting tools, including Tableau, Microsoft Power BI, and SAP Crystal Reports.

• Experience programmatically integrating data from various systems and formats, including APIs, relational databases, and file-based formats (Excel, CSV, etc.).

• Knowledge of scripting languages for data analytics and process automation, such as SQL, Python, or JavaScript.

• Experience administering, supporting, and troubleshooting enterprise applications, including applications hosted on-premises and cloud-hosted/SaaS applications.

• Excellent written and spoken communication skills, including proven experience interfacing with end users and writing technical and project documentation.

Minimum Qualifications
Education: A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.
Experience: Three (3) years of increasingly progressive 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 years of the educational requirement on a year-for-year basis.
Other Qualifications
The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.
Job Expertise: Demonstrate knowledge of and experience with applicable professional/technical principles and practices of application management, citywide and departmental procedures/policies and federal and state rules and regulations.
Customer Service: Demonstrates the ability to anticipate customers' needs and deliver services effectively and efficiently in a timely, accurate, respectful, and friendly manner.
Problem Solving: Approaches a situation or problem by defining the problem or issue; determines the significance of the problem or issue; identifies a set of features, parameters, or considerations; collects and analyzes information; uses logic and intuition to arrive at conclusions and recommendations that achieve the desired outcome.
Project Management: Ensures support for projects and implements agency goals and strategic objectives.
Teamwork & Interpersonal Skills: Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.
Communication: Communicates and listens effectively and responds in an timely, effective, positive and respectful manner; written reports and correspondence are accurate, complete, current; well-organized, legible, concise, neat, and in proper grammatical form responds to statements and comments of others in a way that reflects understanding of the content and the accompanying emotion; asks clarifying questions to assure understanding of what the speaker intended, ensures consistent communication takes place within area of responsibility
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. You must answer all questions to be considered or your application may be deemed incomplete and withheld from further consideration. 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 you have questions about the duties of these positions, the selection or hiring processes, please contact Crystal Diaz at
Additional Information:
Employment Eligibility: Federal law requires all employees to provide verification of their eligibility to work in this country. Please be informed that the City of San Jose will NOT sponsor, represent or sign any documents related to visa applications/transfers for H1-B or any other type of visa which requires an employer application.
Please note that applications are currently not accepted through CalOpps or any other third party job board application system.
This recruitment may be used to fill multiple positions in this, or other divisions or departments. If you are interested in employment in this classification, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.
Please allow adequate time to complete the application and submit before the deadline or the system may not save your application. If your online application was successfully submitted, you will receive an automatic confirmation email to the email address you provided. IF YOU DO NOT RECEIVE THE CONFIRMATION, please email and we will research the status of your application.
The City of San Jose offers a wide range of core health benefits including Medical, Dental, Vision, Employee Assistance Program, Life Insurance, Disability, and Savings Plans. Please visit the City's for detailed information on coverage, cost, and dependent coverage.
For information on the City's Retirement Plan(pension for full-time employees), please visit the Office of Retirement Services You will be able to view information based on different Sworn/Federated job classification.
In additional to the benefits above, there is an to explore further benefits of working for the City of San Jose like paid leave, educational reimbursements, and holiday pay are specific to the job classification and union membership.
01
What is the highest level of education you have completed?

• High School Diploma or the equivalent (GED)
• College (1 to 29 semester units/ 1 to 44 quarter units)
• College (30 to 59 semester units/ 45 to 89 quarter units)
• College (60 to 89 semester units/ 90 to 134 quarter units)
• College (90 to 119 semester units/ 135 to 179 quarter units)
• College (120 or more semester units/ 180 or more quarter units)
• Associate's Degree
• Bachelor's Degree
• Master's Degree
• Doctoral Degree
• Other
• None of the above

02
If you have a bachelor's degree or higher from an accredited college or university in a related field, please state the field of study and the issuing accredited college or university.
03
How many years of experience do you have in increasingly progressive experience in computer systems applications programming?

• Less than 3 years
• 3 years or more

04
An acceptable education substitution for the Senior Systems Applications Programmer position is additional years of directly related work experience may be substituted for up to a maximum of two years of the educational requirement on a year-for-year basis. Please describe your experience in the area above
05
Select the technical areas below in which you have proficiency. Check all that apply or None if you do not have proficiency in any areas listed. Proficiency as used above means that you have prior experience with these technologies in a professional setting and advanced skill level.

• Relational databases, such as SQL Server or Oracle
• Tableau and/or Power BI
• Crystal Reports
• Scripting languages, such as SQL, Python, or JavaScript
• Application administration and support
• Technical writing
• None of the above

06
Based on your answer to the previous question, please outline your experience in the technical area(s) that you noted proficiency. Identify the employer's name, timeframe, role/projects where you gained this experience, and specific tools or programming languages that you used. Your response should align with the professional experience listed on your resume.
07
Describe a dashboard, report, or other product/application that you have built to analyze data and deliver actionable information to users. In your response, please include the employer's name and timeframe when you developed this solution and the business problem it solved. If possible, provide a URL or upload a document (PDF) to support your response.
Required Question