Sql data analyst Jobs in Gainesville, FL

Job Description

:

SUMMARY

This is advanced professional and technical work analyzing, designing, implementing and maintaining departmental automated/computerized systems.

Positions allocated to this classification report to a designated supervisor and work under limited supervision. Work in this class is distinguished from other classes by its advanced technical and operational skills.

EXAMPLES OF WORK**

** This section of the job description is not intended to be a comprehensive list of duties and responsibilities of the position. The omission of a specific job function does not absolve an employee from being required to perform additional tasks incidental to or inherent in the job. Performance of lower-level duties may be required.

ESSENTIAL JOB FUNCTIONS

Depending on the area of assignment:

Analyzes, designs, identifies, prioritizes, and resolves reported problems, including data, account administration, email, desktop, and application issues.

Evaluates hardware/software needs and training/documentation.

Designs, implements, and administers automated/computerized systems, such as SCADA, Outage Management, EMS, Geographic Information Systems, computer-aided dispatch systems, and work management and tracking systems.

Performs needs assessments at the departmental level.

Produces data, information, and reports.

Corrects program errors or makes modifications to departmental automated/computerized systems by revising coded instructions or altering the sequence of operations.

Communicates with vendors to evaluate new hardware and software solutions, and to discuss existing problems and issues.

Performs in-house technical training for users.

Develops and writes computer programs for the input and retrieval of specific documents, data, and information.

Installs and maintains hardware systems specific to the assigned department.

Configures departmental software applications and servers to ensure high availability.

Design user interfaces, applying graphic and creative artistic skills

Attends work on a continuous and regular basis.

NON-ESSENTIAL JOB FUNCTIONS

May require on-call responsibilities.

May require after-hours and weekend responsibilities.

Performs other related duties as assigned.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential job function satisfactorily. Below are the required education, experience, knowledge, skills and abilities to perform the essential functions.

EDUCATION AND EXPERIENCE

Graduation from an accredited four-year college or university with major course work in data communications, computer sciences, computer programming, information science, networks, or system engineering, and three years of related experience, or an equivalent combination of training and experience that provides the required knowledge, skills, and abilities.

CERTIFICATIONS OR LICENSES

Licenses

None.

Certifications

Obtains training and certifications based on the needs of the assigned department.

KNOWLEDGE, SKILLS, AND ABILITIES

Depending on the area of assignment:

Thorough knowledge of advanced problem-solving techniques.

Thorough knowledge of systems administration and performance management.

Knowledge of computer networks.

Knowledge of web-based design and programming

Knowledge of database design.

Ability to communicate effectively, both orally and in writing.

Ability to work effectively in a team-oriented environment

Ability to interface systems accurately and independently.

Ability to work effectively with coworkers and the general public.

Ability to work under limited supervision

PHYSICAL AND ENVIRONMENTAL REQUIREMENTS

To perform this job successfully, an individual must possess certain physical abilities and be able to withstand work-related environmental conditions.

PHYSICAL REQUIREMENTS

Work is sedentary and requires prolonged hours of sitting.

WORK ENVIRONMENT

Applicants assigned to Police or Fire must have no conviction of a felony or a misdemeanor involving moral character, perjury, or making false statements; nor after July 1, 1981, have pled guilty or nolo contendre to, or have been found guilty of any such crimes. Applicant’s current lifestyle and recent history must be free of illicit or illegal drug use.

Note:

May Require Assessment(s).

May fill multiple positions.

May establish an eligibility list.

Come join our team! The City of Gainesville offers a competitive benefits package and opportunities to grow both professionally and personally.

All ‘regular’ employees are eligible for traditional benefits such as health insurance, life insurance, paid leave, 11 paid a holidays a year, a pension plan and a deferred compensation plan, but we also offer great things like on-site fitness centers, tuition reimbursement, on-site medical staff and a wellness program to keep you healthy and happy.Please note; benefits are not available for temporary employees.

Equal Opportunity

The City of Gainesville is an equal opportunity/affirmative action employer and does not discriminate in hiring. Minorities, women and individuals with disabilities are encouraged to apply. Individuals with a disability, who require special accommodations during the selection process, should notify the Human Resources Department at 352-334-5077 or TDD/TTY at 352-334-2292.

Veterans' Preference

Veterans are encouraged to apply. Veterans’ Preference ensures that veterans and eligible persons are given consideration at each step of the selection process. However, preference does not guarantee that a veteran or other eligible person will be the candidate selected to fill the position. Section 295.07, Florida Statutes (F.S.) specifies who is eligible for Veterans’ Preference. State of Florida residency is not required for Veterans’ Preference.

If you are unable to apply online due to a disability, contact recruiting at or by calling 352-334-5077.