Sr. Application Analyst

$41.30 - $53.55/hr

These positions will work on-site in Sunnyvale 5 days a week, remote work is not an option.

Performs complex programming assignments according to the Software Development Lifecycle (SDLC), established guidelines, and technology standards; designs, develops and implements commercial systems and system interfaces; revises, improves, updates, and maintains existing systems; participates in or manages business process reengineering, upgrades, new technology, and system implementation projects; provides training and technical support to technical staff and end-users; executes established standards and priorities; manages small to medium sized projects; closely coordinates with system owners, end-users, vendors, the public, and project teams; executes the Information Technology Strategic Plan; and performs related duties as assigned.

Required Skills:

• Plans, designs, recommends, 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.
• Designs, documents, develops, codes, tests, and debugs applications and interfaces.
• Analyzes, validates, and documents business processes and system requirements using standard
• Business Analysis tools and methodologies for the development or procurement of software systems.
• Designs, 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.
• Conducts design sessions and develops design documents.

Knowledge Skills & Abilities:

• Principles and practices of excellent customer service.
• Extensive knowledge and experience of Report writing with Crystal Report and Microsoft SQL
• Server Reporting Services
• Principles and practices of ITSM (IT Service Management) systems to include Incident; Request
• Fulfilment; Knowledgebase; Asset Management and IT Service Catalogs.
• Developments and trends of application and reporting solutions.
• Fundamentals of Business Analysis Core Concept Model (BACCM) framework defined in Business
• Analysis Body of Knowledge (BABOK).
• Database design and basic administration of database platforms like Microsoft SQL Server and Oracle.
• RDBMS programming including stored procedures and user functions
• Basic knowledge of Local Area Network (LAN), wireless, and Wide Area Network (WAN) technology.
• Microsoft Office, Microsoft Project and Microsoft Visio.
• Team formation and execution; how to motivate teams.
• Cost-benefit analyses to recommend the most effective solution.
• Provide excellent customer service.
• Communicate effectively, orally and in writing.
• Gather and document requirements for function changes and new requirements, translating user defined requirements into technical specifications.
• Plan, design, document, install and support application systems, scripting, business intelligence reports for both enterprise and departmental needs.
• Effectively organize, prioritize, and follow-up on work assignments to meet established deadlines.
• Prepare clear and concise written reports and technical documentation.

Required: Possession and continued maintenance of a valid class C California driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.