Programmer Analyst II or Senior

Toho Water Authority; Kissimmee (FL); Remote; USD 50,000 - 70,000; Full time

Job summary

Toho Water Authority seeks a Programmer Analyst II to design, program, and implement application-based systems. You will receive tasks from the IT Manager and support multiple departments, ensuring data integrity and system reliability.

Qualifications include a IT-related bachelor's degree and at least two years of experience. Proficiency in SQL, ETL, and programming with .NET/C# or VB.NET is expected. Remote work consideration is possible.

Qualifications

• Bachelor's degree in Information Technology or related field.
• Minimum of two years relevant work experience.
• Valid State of Florida Class E Driver's License.

Responsibilities

• Maintains database integrity, tests programs, plans patches, trains users, and monitors database performance.
• Creates reports from aggregated data using parameters and tables; sets filters and retrieves data.
• Uses Crystal Reports and SSRS with SQL Server; writes SQL queries; knowledge of ETL; creates stored procedures.
• Maintains SharePoint by creating applications and documenting requirements.
• Writes, analyzes, and reviews programs using workflow diagrams.
• Additional duties as required.
• Knowledge of .NET, C#, and Visual Basic.

Skills

SQL

ETL

C#

VB.NET

PowerShell

Education

Bachelor's degree in Information Technology or related field

Tools

Crystal Reports

SSRS

SharePoint

SQL Server

Job description

Posting number: 00790

Department: Information Technology

Job classification: Programmer Analyst II

Posting type: Open

Categories: IT and Computers, Water Agency, Utilities

Summary

Programmer Analyst II: $36-51.42

Senior Programmer Analyst: $40.31-$57.59

The purpose of this position is to provide technical and analytical work in the design, programming, and implementation of application based systems and projects. This is accomplished by receiving tasks from the IT Manager; and completing assigned duties; obtaining advice. Other duties include assisting and supporting various departments, supervisors, and co-workers.

Examples of duties

1. Administrates various applications by maintaining database integrity; testing programs or databases; approving and planning the installation of new patches and modules; training users; and inputting codes to monitor database performance.
2. Creates reports by obtaining aggregated data and parameters; working with data regions and tables; reporting parameters; filtering and retrieving data; creating advanced; and comparing tables.
3. Works with Report tools such as Crystal Reports, SQL Server Reporting Services (SSRS) utilizing Microsoft SQL Server; creating spreadsheet applications; removing incorrect data from spreadsheets; and retracting data from database. Strong understanding, writing, maintaining SQL query skills required. Experience with ETL (Extract, Transform, Load), and Database backup/restore knowledge is a plus. Create stored procedures for data tuning with SQL.
4. Maintaining SharePoint by creating applications; documenting systems scopes, current view, proposed view, application, and general requirements. PowerShell knowledge is a plus.
5. Write, analyze and review program, using workflow charts diagrams.
6. Additional duties as required.
7. Working knowledge of .Net,C#, and Visual Basic.
   

Qualifications

1. Bachelor's degree in Information Technology or related field.
2. Minimum of two years relevant work experience.
3. Must possess and maintain a valid State of Florida Class E Driver's License.

Supplemental information

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to sit; use hands to handle or feel and talk or hear. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand; walk and bend, kneel, squat, or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
WORKING CONDITIONS:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate. Environmental factors include indoor, flat surface, noise, sitting with occasionally walking and standing.

Emergency Response

This job title is classified, for Emergency Preparation and Response Policy, as Essential

Time and Attendance Classification

Time and Attendance Classification: Flexible Work Schedule

Remote Work Classification

This position is eligible for remote work consideration