Senior Systems Applications Programmer - Public Works (20532335)

The City of San José, the Capital of Silicon Valley, is one of the nation's best managed cities and one of the top 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. ?

Salary range for this classification is $ 123,658.08 - $150,368.40 . This salary range includes an approximate five percent (5%) ongoing non-pensionable compensation. Actual salary shall be determined by the final candidates' qualifications and experience.

The Department of Public Works is recruiting to fill a Senior Systems Applications Programmer (Sr. SAP) position to develop technology solutions , which will maximize the delivery of City products and services.

The focus of this Sr. SAP position is to actively engage in creating and maintaining technical solutions that enhance data processes and system efficiency. This role is entirely focused on individual contribution in developing solutions, resolving technical challenges , and collaborating across teams to support the Department and c itywide operations, ensuring seamless system integration across applications .

Key responsibilities and duties may include but are not limited to the following:

• Manage enterprise-scale databases, developing complex queries for data analysis, integration, and reporting.
• Master Smartsheet, including its advanced features, to build complex workflows, reports, and dashboards.
• Provide training and support to various teams on utilizing Smartsheet effectively.
• Develop/ maintain reports and dashboards, using different business intelligence reporting and analytics software.
• Support on-premise s web applications built with Node.js and Angular.

This position requires a candidate who is actively involved in daily technical tasks and direct problem solving. An ideal candidate will have the following key qualifications:

• Extensive experience in scripting languages for data analytics and process automation, such as SQL, Python, or JavaScript. U nderstanding of RESTful API design, development, and consumption, with knowledge of HTTP protocols, authentication, and data formats (JSON, XML).
• Strong knowledge of relational databases such as Oracle or MS SQL Server, with experience in design, complex queries.
• Experience with Smartsheet or ability to quickly learn and master Smartsheet with some training .
• Skilled in utilizing data reporting tools such as Tableau, Microsoft Power BI, or SAP Crystal Reports to create interactive dashboards and design advanced visualizations.

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.

Education: A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.

Experience: Three 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.

The ideal candidate will possess the following competencies, as demonstrated in past and current employment history. Desirable competencies for this position include:

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 interview s.

To be considered for this opportunity, please attach your resume (including employer's name, dates of employment , role, and project scope).

If you have questions about the duties of these positions, the selection or hiring processes, please contact Diana Gonzalez at diana.gonzalez@sanjoseca.gov .