Systems Applications Programmer, Senior

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 here 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 contac t Crystal Diaz at crystal.diaz@sanjoseca.gov .

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 CityCareers@sanjoseca.gov 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 benefits pagefor 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 website. You will be able to view information based on different Sworn/Federated job classification.

In additional to the benefits above, there is an additional perks siteto 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.

Closing Date/Time: 10/28/2024 11:59 PM Pacific

• 

• City of San Jose

• 408-535-1285

Show more