Senior Applications Analyst

Carlsbad - The Community

The City of Carlsbad is ideally situated in north San Diego County where a great climate, beautiful beaches and lagoons, and abundant natural open space combine with world-class resorts, family attractions, well planned neighborhoods, excellent schools, and a charming village atmosphere to create the ideal California experience. Covering nearly 40 square miles, the City of Carlsbad is currently home to about 115,000 residents. The city sets the standard for high-quality local government services and is home to corporate headquarters in technology, life sciences and action sports, supported by a thriving tourism market and nearly 40 percent preserved open space. Thanks to an award-winning growth management plan, the city's infrastructure and services keep pace with development and promote an excellent quality of life.

The Department & Position: The city's IT department connects Carlsbad by delivering innovative technologies to internal and external customers. The department needs a leading-edge Senior Applications Analyst to help the city leverage technology to improve business processes, increase productivity and support civic engagement. This position partners with business units within the city to recommend, install/integrate, test, maintain and monitor the performance of software products and provide technical support to end-users and/or Business Systems Specialists in a multi-client, multi-vendor software environment. Responsibilities include conferring with end-users to determine types of hardware and software required and providing or assisting with training in the use of equipment and software. The city is currently implementing new enterprise solutions, including Workday, SpryPoint Utility Billing and Can/Am Teller Cashiering. The ideal candidate will have experience in implementing and supporting these applications.

The Senior Applications Analyst performs as a lead and/or at the supervisory level and provides support to end-users on sensitive or complex applications that have a significant impact on the organization. The Senior Applications Analyst is responsible to independently create and deploy unique solutions to end users with or without assistance from vendors.

This position requires the following:

• Flexibility to work evenings and weekends as necessary
• Participation in on-call rotations
• Willingness to work overtime as needed

Class Specification:

Application Analyst Job Series
Salary Range 109

*This position is eligible for a hybrid work schedule.

The following duties are typical for this job series and include the following. Incumbents may not perform all of the listed duties and/or may be required to perform additional duties from those listed below to meet the city's business needs and changing operating practices. Other duties may be required and assigned.

Senior Applications Analyst:

• Researches and analyzes problems with applications and resolves or formulates solutions
• Develops, documents and maintains reports and interface programs using programming languages and/or applications such as Crystal Reports, and/or MS SQL Reporting Services
• Provides technical assistance on connectivity to peripheral equipment
• Assists end-users with the implementation of new software releases and upgrades
• Determines translates, and programs business needs and issues into appropriate programming code to resolve the end-user request
• Maintains and implements system security for software application(s) in conjunction with Business Systems Specialists
• Develops and maintains application documentation
• Conducts database analysis and subsequent troubleshooting activities
• Researches system enhancements and executes implementation
• Develops databases in conjunction with the database administrator for application software needs
• Assists citywide teams by providing expertise on software functionality issues and questions and provides deliverables to achieve team objectives
• Designs and develops a workflow to support assigned departments to enhance information flow and/or utilization of software and/or systems
• Conducts software application testing and other preparation for software upgrades or new software implementation
• Schedules regular project status meetings with end-users and/or vendors
• Ensures change control forms and processes are aligned with standards established by the Information Technology Department and approved by Senior Application Analysts and/or Network Engineers
• Develops front and back-end interfaces to integrate multiple software applications.
• Establishes appropriate relationships and ongoing dialogue with software vendors
• Ensures software applications are up-to-date; obtains and applies necessary software patches
• Obtains assistance from vendors to correct software flaws and/or inefficiencies
• May perform the role of lead or supervisor; assigns work; distributes workload; authorizes timesheets; assists in recruitment processes and participates in performance reviews
• Assists in the Information Technology Department strategic planning process
• Carries out and develops assigned roadmap(s)
• Provides support to staff and ensures the necessary tools and resources required to support their assigned applications
• Provides resources or resolves scheduling conflicts to projects in the Applications Group
• Provides vital resources to significant projects of others
• Assists the department on long-range strategic planning
• Provides input on developing department policies
• Develops request for proposals, bids, and information, and performs contract management in accordance with city policies and purchasing ordinances
• Provides custom or unique creation of scripts, tools, and interfaces at a high level

Knowledge of:

• Dynamic programming languages
• Enterprise network infrastructure environment
• Database concepts including design, tables, queries, functions, modules, reports and ODBC
• Relational databases
• Application development such as system analysis and software development lifecycle

• Prioritize and lead projects
• Program and analyze software application problems and issues
• Initiate work
• Support large scale complex software application(s)
• Develop reports
• Create and meet deadlines
• Deal with multiple high priority issues simultaneously
• Perform basic commands and develop scripts in Unix
• Analyze and research solutions
• Develop database application utilizing MS Access, MS SQL, ASP.NET based on end-user requirements
• Develop complex reports using reporting tools
• Understand MS SQL and create/maintain databases; create/maintain SSIS packages; assign security roles
• Develop and manage projects of significant scope with considerable impact on the organization
• Deal with controversial or sensitive issues
• Perform analysis at a high level
• Excellent written and oral communication skills

Minimum Qualifications:

• Bachelor's degree in Information Technology or Computer Science or equivalent experience in an Information Technology environment.
• Five years of professional experience in an Information Technology environment or a related function performing
  • User support
  • Training
  • Supporting installation, development, and maintenance of the business intelligence application software and servers, including the development of associated metadata and user interfaces

• Master's degree in Information Technology, Computer Science, or a related field
• ITIL certification
• PMP certification