Senior Applications Analyst

City of Carlsbad; Carlsbad (CA); Hybrid; USD 90,000 - 140,000; Full time

Job summary

The City of Carlsbad IT department seeks a Senior Applications Analyst to lead and support core business software across multiple clients and vendors. You will implement, test, and maintain enterprise solutions including Workday, SpryPoint Utility Billing, and Can/Am Teller Cashiering, while guiding end-users and staff with strong analytical and communication skills.

The ideal candidate demonstrates experience with BI tools, database design, and complex reporting, and can participate in on-call

Qualifications

• Bachelor's degree in IT/CS or equivalent experience.
• Five years of professional IT experience in related function.
• Experience with business intelligence apps and reporting tools.
• Ability to support installation, development, and maintenance of BI software and servers.
• Strong communication and documentation skills.

Responsibilities

• Lead and support enterprise software applications for city operations.
• Develop, document and maintain reports and interfaces.
• Provide technical assistance on connectivity to peripheral equipment.
• Assist in implementing new software releases and upgrades.
• Translate business needs into programming solutions.
• Develop and manage project plans and vendor coordination.

Skills

Prioritize and lead projects

Program and analyze software issues

Initiate work

Develop reports

Meet deadlines

Communicate effectively

Education

Bachelor's degree in IT or CS

Master's degree (preferred)

Tools

Crystal Reports

MS SQL Reporting Services

MS SQL

ASP.NET

MS Access

SSIS

Job description

The Position

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.

You belong in Carlsbad: The City of Carlsbad embraces and recognizes the vital relationship of an inclusive, engaged work environment and innovative excellence. An equitable and inclusive work climate comprises personal experiences, values, and views shaped from differences of culture and circumstance. Our organization appreciates belonging, creativity, recognition and retention of its employees and is committed to hiring and developing motivated, productive and talented employees who provide services and enhance our quality of life. We work to embrace open and equitable access to opportunities for learning and development as our responsibility and goal.

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.

Key Responsibilities

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

Qualifications

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

Ability to:

• 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

Experience & Education

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

Additional Preferred Qualifications:

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