Applications Analyst Ii

City of Sunnyvale
Full Time 30 per week $55 - $70 Per hour CA 650 W Olive Ave, Sunnyvale, CA 94086, United States
Advertisement

Overview

Regular Full-Time Employment Opportunity 
The position opens Tuesday, June 18, 2024 and the final filing date is Monday, July 22, 2024 at 5:00 pm or after receiving 75 qualified applications, whichever is first. 

Future Salary Increases
  • 3.5% effective July 2024
  • 3.5% effective July 2025
Benefits:
  • Eligible for overtime pay
  • Retiree medical benefit
  • California Public Employees' Retirement System (CalPERS) Pension 
  • 11 paid Holidays, plus 30 hours* of Floating Holidays (*Prorated based on date of hire)
  • Paid Time Off (PTO) accruals
  • Generous medical contribution towards medical, dental, and vision. 
  • The City does not participate in Social Security. 
  • Potential hybrid schedule after probationary period
  • Onsite gym
The City of Sunnyvale is looking for an Applications Analyst II to join the Information Technology Department (ITD) who is service-oriented and has a passion for meaningful work  with enterprise applications (e.g. ERP, EDMS, GIS). The team focuses on strong customer service business-to-technical skills and experience in configuring and maintaining applications for department use and using problem-solving skills to provide the best solutions.

The IT Department manages the enterprise GIS and this positionwill focus on creation-of and support-of GIS based applications for various City functions along with system configuration and user support of other applications.  Under direction of a Principal Applications Analyst, or Information Technology Manager within the Applications and Analytics Division, performs technical and analytical work in the design, creation, maintenance, and utilization of enterprise applications.

To view the full job classification, click .

DISTINGUISHING CHARACTERISTICS
Applications Analyst / Project Coordinator I is the entry-level classification for the Applications Analyst/Project Coordinator job series. Initially, incumbents perform assigned duties under general supervision, while learning related standards, policies and procedures.  Applications Analyst / Project Coordinator I is distinguished from Applications Analyst / Project Coordinator II by the performance of less than the full range of duties assigned to the Applications Analyst / Project Coordinator II. As experience is gained, there is a greater independence of action within established guidelines.
Applications Analyst / Project Coordinator II is the next level  classification in the series. Incumbents are expected to independently perform the full scope of duties associated with the design, selection, maintenance and implementation of application and business intelligence solutions and/or project management. Applications Analyst / Project Coordinator II is distinguished from the higher-level classification of Senior Applications Analyst / Project Coordinator in that the Senior Applications Analyst / Project Coordinator is the advanced journey level in the series responsible for more complex application systems, interfaces, reporting and queries and business intelligence solutions. Positions in this class are flexibly staffed and are normally filled by advancement from the Applications Analyst / Project Coordinator I level once the incumbent meets the qualification standards of the classification, demonstrates an ability to perform the full scope of work, and meets performance expectations. Incumbents are not automatically promoted to the higher level; the needs of the department determine the level of assignment.
The Applications Analyst / Project Coordinator classification series has four distinct areas of focus listed below.  To be hired as a Applications Analyst / Project Coordinator, the candidate must demonstrate the minimum qualifications with an emphasis in at least one of the areas of focus below:
  • Configured Off the Shelf/Software-As-A-Service (COTS/SaaS) Application Configuration:  Responsible for application configuration, including configuring and modifying the configuration of packaged systems to meet evolving and ongoing functional needs of City departments.
  • Business Requirements Analysis, System Documentation and Product functionality mapping:  Responsible for business requirements, system documentation and product functionality mapping.
  • Application/Interface Development, Database Development and Support, and Support of Custom-developed applications: Responsible for application interfaces, database development.
  • Project Management/Coordination Activities:  Responsible for managing projects from inception to implementation including all project-related functions coordinating, project plan, risk management plan and communication plans.

Essential Job Functions

(May include, but are not limited to, the following):

  • Installs, upgrades and supports application systems, interfaces, queries, database, scripting activities and business intelligence/reporting solutions to achieve optimum performance in accordance with the IT Service Level Agreement (SLA).
  • Completes service requests in a timely manner and provides support to end users; guides and assists others in completing service requests.   
  • Troubleshoots, upgrades, or configures application, database or reporting systems to determine cause(s) or failure and resolves problems, to include cybersecurity issues.
  • Documents, develops, codes, tests, and debugs applications and interfaces.
  • Documents and develops extract, transform, load (ETL) processes to ensure accessibility of data from business systems for reports or use by other systems.
  • Ensures systems and applications, including the City’s Internet and Intranet, are patched and kept current on all security patches and upgrades.
  • Assists in the development and execution of preventive maintenance programs identifying weaknesses of current systems to determine critical application, reporting or system issues, including cybersecurity.
  • Communicates clearly and concisely, both verbally and in writing.
  • Assists in the creation of operational procedure manuals.
  • Sets timelines and expectations for tasks within project plans.
  • Reviews product documentation and release notes to make installation recommendations, ensuring functional compliance and vendor support.
  • Designs and develops reports against Configured Off the Shelf (COTS) and Software as a Service (SaaS) system databases utilizing available standard reporting tools.
  • Coordinates end-user support for and writes user tests and test scripts.
APPLICATIONS ANALYST II:
Above, plus the following:
  • Plans, designs and recommends application systems, interfaces, queries, database, scripting activities and business intelligence/reporting solutions to achieve optimum performance in accordance with the IT Service Level Agreement (SLA).
  • Designs applications, interfaces, extract, transform, load (ETL) processes based on business requirements.
  • Analyzes, validates, and documents business processes, and system requirements using standard Business Analysis tools and methodologies for the development or procurement of software systems.
  • Conducts design sessions and develops design documents.
  • Evaluates and monitors acquisition cost of applications, scripting, and reporting tools related items to obtain the best results, meet budget guidelines, and ensure system compatibility.
  • Develops technical system documentation, training materials, and provides training to users and support staff.
  • Coordinates activities performed by IT, departmental, and vendor resources for operations and projects in accordance with the project plan.
  • Prepares presentation materials for meetings; documents and follows up on actions and decisions from meetings.
  • Assists in the development and operations of the IT Strategic Plan (ITSP).
  • Provides input, recommendations on new technology and solicits technical specifications.
  • Sets timelines and expectations for team tasks within project plans.
  • Provides guidance to team members and acts as a liaison between the various divisions to other departments.
  • Provides subject-matter expertise on complex technical issues.
  • Leads and meets user requirements through understanding relationships between the system and business operations.
  • Coordinates vendor support, City IT staff and functional users to enable business operations.
WORKING CONDITIONS
Position requires prolonged sitting, standing, walking, reaching, twisting, turning, kneeling, bending, squatting and stooping in the performance of daily activities. The position also requires grasping, repetitive hand movement and fine coordination in using a computer keyboard.  Additionally, the position requires near and far vision in reading reports and work related documents and using a computer. Acute hearing is required when providing phone and personal customer service. The need to lift, drag and push equipment and materials weighing up to 50 pounds is also required. Some of these requirements may be accommodated for otherwise qualified individuals requiring and requesting such accommodation.

Minimum Qualifications

Education and Experience:
The minimum qualifications for education and experience can be met in one of the following ways:

  • A Technology Certificate from an accredited college, university, or trade school in information technology, computer applications, web technologies, computer information systems, application development, database design, programming, technology project management or closely related field AND three years of experience in any one of the focus areas; OR
  • An Associate’s degree or completion of 60 semester or 90 quarter units at an accredited college or university in business information systems, computer science, information technology, software information systems or closely related field AND two years of experience in any one of the focus areas; OR
  • A Bachelor’s degree or completion of 120 semester or 180 quarter units from an accredited college or university with concentration in computer science, information technology, engineering, informatics, web science, business information systems or closely related field; AND one year of experience in any one of the focus areas; OR
  • At least one of the following certifications: Project Management Professional (PMP), Program Management Professional (PgMP), Professional in Business Analysis (PMI-PBA), Agile Certified Practitioner (PMI-ACP), Certification in Capability in Business Analysis (CCBA), Oracle Certified Professional (OCP), Microsoft Certified Solutions Associate (MCSA), Capital Asset Pricing Model (CAPM), Risk Management Professional (PMI-RMP), Project Scheduling Professional (PMI-SP), SQL Certification or Certified Business Analyst Professional (CBAP) certificate; AND three years of experience in any one of the focus areas.
Applications Analyst I:
Knowledge of:
  • Principles and practices of excellent customer service.
  • Principles and practices of ITSM (IT Service Management) systems to include Incident/Problem Management; Request Fulfilment; Knowledgebase; Asset Management and IT Service Catalogs.
  • Fundamentals of Business Analysis Core Concept Model (BACCM) framework defined in Business Analysis Body of Knowledge (BABOK).
  • Concepts of project management from Project Management Body of Knowledge (PMBOK)
  • Contemporary industry practices in Business Analysis, Project Management and SaaS or Cloud-based implementations.
  • Database design and basic administration of database platforms like SQL Server and Oracle.
  • Object-oriented programming languages and associated best practices.
  • Basic cybersecurity principles.
  • Knowledge of applicable security and data privacy practices and laws.
  • Principles, practices, methods and techniques of training and providing technical and functional support to end-users.
  • Principles of project management, execution, task completion and resource management.
  • Applicable industry and safety codes and technology standards.
  • Principles of project management and task completion.
  • Principles, practices, methods and techniques of providing customer service, training and providing technical and functional support to end users.
  • Office methods, procedures, software and equipment.
  • Methods and techniques of troubleshooting systems, connections and infrastructure issues.
  • Principles and practices of assuring data security.
  • Microsoft Office, Microsoft Project and Microsoft Visio.
Ability to:
  • Provide excellent customer service.
  • Communicate effectively, both orally and in writing; translate between technical and non-technical terms.
  • Effectively organize, prioritize and complete work assignments in an expedient and customer service orientation.
  • Plan, design, document, install, and support application systems, scripting, business intelligence reports for both enterprise and departmental needs.
  • Gather, document, and implement requirements for new systems and system changes of varying scope and complexity.
  • Prepare clear and concise written reports and technical documentation.
  • Respond promptly and effectively to requests for service, including cybersecurity incidents.
  • Develop complex reports using business intelligence tools; convert data into information.
  • Learn new business systems, programming languages, reporting tools, databases and other technology tools as required to support the City’s operations.
  • Perform cost/benefit analysis for applications, reports, systems enhancement or replacement.
  • Demonstrate initiative and exercise good judgment in the performance of duties.
  • Prepare clear and concise written reports and technical documentation.
  • Work independently and as a team member; recognize and set priorities and meet deadlines.
  • Work with vendors, ensuring the priorities of the City are met.
  • Recognize, set, and follow priorities to meet deadlines.
  • Respond to cybersecurity issues and remediate in a timely manner.
  • Serve as a client liaison to identify and define project requirements, scope and objectives.
Applications Analyst II:
Knowledge of:
Above, plus the following:
  • Principles of Information Technology Infrastructure Library (ITIL).
  • Basic Principles of Portfolio Management as defined by Project Management Institute (PMI).
  • Principles of project management from Project Management Body of Knowledge (PMBOK)
  • Intermediate level of Business Analysis Core Concept Model (BACCM) framework defined in BABOK.
  • Intermediate practitioner in SaaS or Cloud-based implementation and support.
  • Intermediate level in Database Application design.
  • Knowledgeable in database administration for SQL Server and Oracle.
  • Principles and practices of effective working team environments.
Ability to:
Above, plus the following:
  • Define and implement solutions for documented system function requirements, including system upgrades and participation in RFP/RFQ process.
  • Implement new systems and system changes of intermediate complexity.
  • Generate user instructions written, oral, diagrammatic or schedule form.
  • Analyze cybersecurity issues and remediate in a timely manner.
  • Act as a task coordinator or lead of small projects.
  • Assist in evaluating new technologies; provide feedback to management on ways to increase efficiencies.
  • Prepare written reports, instructions, memos, alerts, knowledgebase or newsletter articles.
  • Follow oral instructions, work with minimal supervision to accomplish goals and objectives and complete assigned project task on time.
  • Plan effectively, prioritize requests and assignments and meet deadlines.
  • Use independent judgment to identify and resolve problems.
Willingness to:
  • Provide emergency response to reduce downtime, correct errors or monitor vendor activity surrounding critical system failures, off-hours scheduled maintenance downtime or work on call on a scheduled and as needed basis.
  • Provide services in different geographical locations throughout the City as requested by users or needed.

Licenses/Certificates:
Possession at time of hire and continued maintenance of a valid California driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.

DESIRABLE QUALIFICATIONS
  • Public sector employment or internship experience.
  • Experience developing or implementing a computer system either as part of a work assignment for academic or professional requirements.
  • Possession and maintenance of Certified Business Analyst Professional (CBAP)
  • Possession and maintenance of Information Technology Information Library (ITIL) certification.
  • Certifications in current programming or scripting languages.

Application and Selection Process

APPLICATION PROCESS 
 The application period closes on Monday, July 22, 2024 at 5:00 pm or after receiving 75 qualified applications, whichever is first. (postmarks or faxes are not accepted).  Candidates are asked to fully describe any training, education, experience, or skills relevant to this position. Electronic applications may be submitted online through the City's employment page at, and click on 'City jobs'. Late or incomplete applications will not be accepted.
 
 EXAM PROCESS
 Applications will be competitively screened based on the minimum qualifications of this position. 
Based upon a review of the application materials, the most qualified candidates will be invited to participate in the 
oral examination process scheduled for August 5, 2024, or August 6, 2024. (Note: The examination process may be changed as deemed necessary by the Director of Human Resources).
 
 SELECTION PROCESS
 Those candidates that receive a passing score on the examination will be placed on an eligibility list for up to one year, in accordance with the City's Civil Service Rules and Administrative Policies. 
Top candidates on the eligibility list will be invited to participate in an in-person 
selection interview with the department tentatively scheduled for August 15 and August 16, 2024. Any candidate that is selected by the hiring department will be required to successfully complete a pre-employment process, which may consist of a background history check, as well as a medical exam(s) administered by a City selected physician(s) before hire. Prior to starting work, all newly-hired employees will be fingerprinted to check conviction history. A conviction history will not necessarily disqualify an applicant from appointment; however, failure to disclose conviction history will result in refusal of employment or termination. Positions which are covered by the Department of Transportation regulations are required to submit to a pre-employment drug test and to random drug and alcohol testing.
 
 INFORMATION ABOUT PROOF OF EDUCATION
 Please note: Any successful candidate, selected by the hiring department will be required to submit proof of education (i.e. original copy of the diploma or college/university transcripts).

 

 
 The information contained within this announcement may be modified or revoked without notice and does not constitute either an expressed or implied contract.
 
 The City of Sunnyvale is an Equal Opportunity Employer. It is the policy of the City of Sunnyvale not to discriminate against all qualified applicants or employees on the basis of actual or perceived race, religion (including religious dress or grooming practice), color, sex (includes gender, pregnancy, childbirth, medical conditions related to pregnancy or childbirth, breastfeeding or medical conditions related to breastfeeding), gender identity and/or gender expression, sexual orientation (including heterosexuality, homosexuality and bisexuality), ethnic or national origin, ancestry, citizenship status, uniformed service member status, marital status, family relationship, age, cancer or HIV/AIDS related medical condition, genetic characteristics and/or genetic information, and physical or mental disability. Applicants needing special accommodations for testing should submit a request to the Department of Human Resources at time of application.     

Advertisement