Database Analyst

About the role

The role is responsible for designing, developing, managing, and maintaining the district's database resources. This includes assisting in building and maintaining database structures, ETL processes, stored procedures, audit reports, data extracts, and other related tasks.

Responsibilities

• Aid in building and maintaining database structures, ETL processes, stored procedures, audit reports, data extracts, etc. to meet project objectives.
• Develop and maintain dashboards, business reports, and data analytics using Microsoft systems and tools.
• Participate in backup and recovery strategy planning and implementation.
• Participate and recommend 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.
• Participate in database design and architecture to support application development projects.
• Troubleshoot database-related issues in a timely fashion.
• 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.

Requirements

Minimum Qualifications:

• Bachelor’s Degree from an accredited college or university.
• Experience with Microsoft SQL Server Platform.
• Experience with Data Warehousing concepts: star schema, fact and dimensional tables, slowly changing dimensions, and data marts.
• Knowledge of software development and user interface web applications.

Qualifications

Essential Duties:

• Aid in building and maintaining database structures, ETL processes, stored procedures, audit reports, data extracts, etc. to meet project objectives.
• Develop and maintain dashboards, business reports, and data analytics using Microsoft systems and tools.
• Participate in backup and recovery strategy planning and implementation.
• Participate and recommend 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.
• Participate in database design and architecture to support application development projects.
• Troubleshoot database-related issues in a timely fashion.
• 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.

Skills

Skills Required:

• Experience with Microsoft SQL Server Platform.
• Experience with Data Warehousing concepts: star schema, fact and dimensional tables, slowly changing dimensions, and data marts.
• Knowledge of software development and user interface web applications.

Benefits

Fringe Benefits:

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

Pay

Salaried; Exempt

Schedule

Not specified