Sr Technical Systems Analyst

Full Job Description

This job posting will remain open until a sufficient number applications has been received.

Career Opportunity

The city of Las Vegas is accepting applications for Sr. Technical Systems Analyst.

This position plans, administers, coordinates and oversees specialized information systems within the assigned department, division or work unit; analyzes existing business processes and systems to identify process and reporting issues and improvements; and performs a variety of technical tasks relative to the assigned area of responsibility.

This position is fully on-site. Remote or hybrid work is not available.

Ideal Candidate:

The most competitive candidates will have strong experience analyzing, supporting, and enhancing complex technical systems, including enterprise database environments and cloud-based technologies.

Candidates should possess demonstrated proficiency in scripting and automation using tools such as PowerShell, or Python to support system integration, reporting, and process improvement initiatives.

Experience developing and maintaining SQL Server Reporting Services reports and Power BI dashboards is highly desirable to support operational and data-driven decision-making.

#PowerShell #Python #SQL #PowerBI

The most competitive candidates will also bring (1) strong problem-solving skills, (2) the ability to translate business requirements into effective technical solutions, and (3) the communication skills necessary to collaborate with technical teams and stakeholders. Experience working in enterprise or public-sector environments and contributing to system design, implementation, and optimization efforts is preferred.

Tips for Completing the Application

You should FULLY describe, for EACH applicable employer, your qualifications and experience, with SPECIFIC reference to each of the minimum qualifications and essential functions found in this job posting.

Examination Process (Supplemental Questionnaire)

A civil service examination will be conducted in accordance with the Civil Service Rules of the city of Las Vegas. The supplemental questions are the examination.

Falsification of information may result in disqualification from a recruitment or removal from a City position. Additional information will not be accepted after the closing date.

The supplemental questions are weighted 100% for placement on an eligible list, and must be worked on individually by the applicant only.

Eligible List

You must score 70% or higher on the examination to be placed on the eligible list.

Selection Process

Final candidate selection will include list placement and may include hiring interview (if applicable).

Any individual offered employment will be required to pass a pre-employment drug test, complete background check, education and experience verification, and may be required to demonstrate the ability to perform the physical requirements of the job.

Some positions may require preliminary background checks. Final interviews will be conducted locally and in-person.

Requirements

Distinguishing Characteristics

This is the advanced journey level in the Technical Systems Analyst series.

Positions at this level are distinguished from other classes in this series by the level of responsibility assumed, the complexity of duties assigned, and the level of independence expected.

Employees perform the most difficult and responsible types of duties assigned to classes in this series.

Employees at this level are required to be fully trained in all procedures related to assigned area of responsibility.

Supervision Received and Exercised

Receives direction from higher level management staff. May act as a lead worker, exercising functional or technical supervision, including scheduling and assigning tasks, providing guidance, ensuring work is completed according to proper procedure, monitoring work progress and reviewing results.

Essential Functions:

1. Reviews and identifies the work unit's information system needs and makes recommendations for program design, development, purchase, implementation and modification.
2. Plans, leads, oversees and participates in defining requirements, the configuration, design, modification, upgrade, testing, troubleshooting, implementation and maintenance of department specific and enterprise-wide applications.
3. Plans, oversees and leads the configuration, design, modification, upgrade, testing, troubleshooting, modification, implementation, maintenance, and upgrade of all software, interfaces, triggers, procedures or other customized efforts used in conjunction with departmental software such as mobile solutions, electronic document management systems, records management systems, financial systems, GIS systems, web applications, IVR/IWR, grants management solutions, and all other software used by the department.
4. Administers and supports current and future specialized systems such as hosted databases, performance plus, electronic plan review and other software as identified by the department and the city.
5. Performs initial assessment of application problems with all systems used by the department and resolves them in cooperation with the vendor, project teams and outside agencies as needed; resolves functional problems that users are experiencing; researches and corrects data entry errors made by users.

Develops, prepares and runs reports, views and table joins using a variety of tools including online reporting tools, Crystal X or higher, Oracle Developer and Oracle Discoverer to provide useful data at the request of department and city management and as required by governing agencies and other authorities.

Recommends additional reports based on knowledge of system capabilities and department needs; reviews and analyzes reports and reports issues to management.

6. Collaborates with staff from Information Technologies, Project Management, department management and various teams to maintain and monitor system environments and provide application and terminal support to users; provides in-depth analysis and recommendations for operational enhancements to systems; configures application parameters; coordinates change control management activities in conformance with accepted practices; ensures data is protected in accordance with security guidelines.
7. Performs database analysis to determine the most effective file structure; develops and implements new and improved database structures; monitors database performance.
8. Assesses and recommends system modifications and enhancements to accommodate changes in business practices and newly identified needs; interprets business requirements and translates functional design into technical specifications; coordinates implementation with appropriate staff.
9. Designs, develops and implements the integration of computer-based solutions with existing internal and external systems; provides recommendations on various integration and interfacing systems to optimize efficiency; leads and coordinates integration initiatives.
10. Documents system requirements and testing results. Prepares related technical documentation.

Trains staff on automation projects and proper application of equipment and software.

Provides first-line support to all users of the systems, including setup and administration of user accounts; conducts regular site visits to assist users; schedules and facilitates periodic user group meetings to discuss issues and solutions.

Coordinates and facilitates meetings with users concerning proposed and current business processes. Recommends modifications as appropriate.

11. Coordinates maintenance and repair of equipment with the Information Technologies Department.
12. Participates in the procurement process, including researching materials, equipment and vendors, assisting with specifications and requisitioning materials as needed.
13. Serves as technology liaison between the work unit, outside agencies and service and product vendors; works with the Information Technologies Department and outside agencies to provide for the technology needs of the work unit; keeps work unit staff and management apprised of the status of all technology systems projects; reviews cost estimates and makes recommendations on appropriate software and hardware purchases.
14. May lead, assign and review the work of staff, consultants or contractors responsible for providing specialized programming, systems analysis and technical support within the assigned work unit.
15. Ensures employees adhere to established work methods, techniques and schedules, and comply with applicable city and department policies, procedures, standards and specifications; reviews needs with appropriate management staff; allocates resources accordingly.
16. Assists with developing and implementing policies and procedures; prepares performance statistics and reports.
17. Responds to inquiries in a courteous manner; provides information within the area of assignment; resolves complaints in an efficient and timely manner.

Marginal Functions:

1. Assists in the development and coordination of the division or function budget.
2. Perform related duties and responsibilities as required.

Qualifications

Experience:

Three years of increasingly responsible experience in supporting, managing or implementing information systems, especially in an end-user environment.

Training:

Bachelor's degree from an accredited college or university with major in computer science, information systems, public administration, business administration or a field related to the area of assignment.

May substitute a combination of equivalent education and related experience. The city assesses 1.5 years of fulltime experience as equivalent to one year of education.

Licenses and Certifications:

Possession of a certification in databases, an operating system or software application applicable to the area of assignment is desirable.

Designation as an Oracle Certified Developer may be desirable depending on area of assignment.

Special Requirements

The Fire and Rescue Department operates on a 24-hour, seven days per week schedule. When assigned to Fire and Rescue, must participate in rotating call-outs for service after normal scheduled work hours.

Additional Information

Knowledge of:

Advanced principles and techniques of computer programming, on-line programming and programming documentation.
Advanced concepts, principles and practices of modern computer science or information systems.
Advanced computer testing techniques and methodologies.
Intermediate knowledge of programming languages, such as VisualBasic, HTML, ASP, or SQL.
One or more on-line report writing applications, such as Crystal Reports X or higher, Oracle Reports, Discoverer or Microsoft Access.
Principles and practices of database design and administration.
Oracle or SQL Database structure sufficient to allow the creation of database tables and the design of relational databases.
Interfaces between Oracle Applications and third party applications such as Hansen, Telestaff, CLASS, and IRS software.
Research techniques and data analysis.
Basic principles of budgeting and accounting.
Principles and techniques of lead supervision.

Skills in:

Reading and comprehending complex technical materials and manuals.
Planning, organizing and prioritizing assignments.
Managing multiple assignments.
Learning the unique needs and computer hardware and applications of the assigned work unit.
Explaining complex technical systems in clear and simple terms understandable to non-technical staff.
Using initiative and independent judgment within established guidelines.
Interpreting, applying, explaining and enforcing applicable city, department and division policies and procedures.
Analyzing problems, identifying alternative solutions, projecting consequences of proposed actions, recommending best options and implementing approved solution in support of goals.
Establishing and maintaining close and positive working relationships and open lines of communication with applicable city staff in other departments, external agencies and vendors to ensure the smooth functioning of the systems.
Learning business and operations of assigned work unit to the extent necessary to perform essential functions, enhance system value and achieve established goals.
Communicating effectively with assigned work unit staff and management and outside agencies.
Communicating clearly and concisely, both orally and in writing.
Establishing and maintaining effective working relationships with those contacted in the course of work.

Competencies:

Core Workforce Competencies

Professionalism – Demonstrates core values by being honest, respectful and positive.

Effective Communication – Expresses verbal and written thought in a clear and understandable manner.

Customer Focus – Demonstrates genuine concern and satisfies external and/or internal customers based on the CLV core purpose and values.

Adaptability – Able to effectively modify behavior to suit changing workforce demands.

Problem Solving – Solves problems by considering all causes, solutions and outcomes.

Productive Partnerships – Develops, maintains and strengthens partnerships with others.

Technical and Safety Expertise – Possesses a depth of knowledge, skill and ability in a technical (job) area.