Database Analyst 2

Job Description Code : 6G.015

Division / Department : Technology and Information Services

Pay Grade : T-6

Pay Type : Salaried; Exempt

Retirement : TRS

Contract Work Year : 233 Days

Reports To : Executive Director of Business Information Services

Evaluation Instrument : PEI

MINIMUM QUALIFICATIONS

Bachelor's Degree from an accredited college or university. Minimum three years' experience with Microsoft SQL Server Platform. Proficiency in Data Warehousing concepts : star schema, fact and dimensional tables, slowly changing dimensions and data marts. Knowledge of software development and user interface web applications.

GOAL

Design, develop, manage and maintain the district's database resources.

REPRESENTATIVE DUTIES & RESPONSIBILITIES

Responsible for the design, development, test, release, maintenance, and technical support of custom data applications such as data pipelines / ETLs / data processing / APIs.

Responsible for the design, development, test, release, maintenance, and technical support of data analysis reports and dashboards using Power BI and reports using SSRS.

Performs data modelling and database design for data and reporting applications as well as other applications as needed.

Develop and maintain dashboards, business reports and data analytics using Microsoft systems and tools.

Sustain backup and recovery strategy planning and implementation.

Develop and maintain data security best practices including data encryption, data access prevention and data access logging / monitoring.

Optimize database systems to ensure data quality and integrity while ensuring performance efficiency.

Create complex functions, scripts, stored procedures and triggers to support application development.

Performs analysis, design and implementation of data migration as needed.

Provide training and develop technical and instructional manuals.

Provide data management support to users.

Research and suggest new database products, services and protocols.

Initiate and execute discovery meetings to understand end user requirements to design efficient solutions.

Maintain strong communication channels with district-level departments and schools.

Serve on district committees as assigned.

Perform and promote all activities in compliance with equal employment and nondiscrimination policies of Cherokee County School System.

Professionally represent the Cherokee County School District at meetings, conferences and conventions.

Interact effectively with the general public, staff members, students, teachers, parents and administrators, using tact and good judgment.

Possess and maintain valid and appropriate license, certificate and / or credential as may be required for this position.

Follow work scheduling and attendance requirements in a regular, predictable and punctual manner.

Participate in training programs to increase skills and proficiency related to assignments.

Review current developments, literature and technical sources of information related to job responsibility.

Ensure adherence to good safety procedures.

Follow federal and state laws, as well as School Board policies.

Perform other duties as assigned.

IMPORTANT NOTES

ESSENTIAL DUTIES

Job descriptions are designed and intended only to summarize the essential duties, responsibilities, qualifications, and requirements for the purpose of clarifying the general nature and scope of a position's role as part of the overall organization. Job descriptions do not list all tasks an employee might be expected to perform, and they do not limit the right of the employer / supervisor to assign additional tasks or otherwise to modify duties to be performed – even if seemingly unrelated to the basic job. Every employee has a duty to perform all assigned tasks. (An employee who is assigned a duty or task believed to be unlawful should report the assignment to the Chief Human Resources Officer.) It should also be noted the order of duties / responsibilities as listed in the job description is not designed or intended to rank the duties in any order of importance relative to each other.

MINIMUM REQUIREMENTS

In filling a vacant position, preferred or required credentials regarding education, training, experience, and other bona fide occupational qualifications may be established. The credentials shown in this job description may be interpreted only as the minimum criteria existing at the time the description was developed. Other bona fide occupational qualifications and criteria may be utilized as needed in the selection process.

Fringe Benefits

FICA is paid by the employee and matched by the School District. Temporary workers do not qualify for employee benefits.

Adopted : July 2023

Revised : July 2024, July 2025

J-18808-Ljbffr