What are the responsibilities and job description for the Data Quality Analyst position at Oklahoma City Public Schools?
Position Type :
ProTech (Non-Certified)
Date Posted : 2 / 11 / 2025
Location : OKCPS Central Office
Data Quality Analyst
Position Summary :
This is a Microsoft SQL programming position with a primary responsibility for data quality assurance between district, state and federal information systems. This position also is responsible for the extraction, transformation and loading (ETL) of student data used to support statistical analysis and reporting. This role maintains accuracy and congruity of data cross reporting systems, helps ensure compliance with state and federal regulations, and shares the responsibility of protecting the security of student and staff information.
This is not a data visualization position.
Essential Duties :
- Develop, implement and maintain MS SQL processes for data management and warehousing
- Design, test and maintain MS SQL queries and reports in response to scheduled and ad-hoc requests
- Compile, review and validate complex student data for accuracy, consistency and completeness
- Extract data from various sources, transform / clean, and load to OKCPS student information systems
- Create, test, and verify SPSS programming syntax that generates data files for evaluation and research
- Identify root causes of data discrepancies or errors and collaborate with stakeholders to resolve issues
- Prepare district data files to fulfill reporting requirements for various state and federal education agencies and load district data to the appropriate reporting platforms
- Consult project staff and district administrators to maintain timelines and meet required deadlines
- Work with all departments, divisions, schools, and outside agencies to establish, maintain, and archive computerized data sources
- Provide technical assistance to other departments to identify and address data issues
- Ensure that data generated and shared with outside parties protects the rights of students, teachers and staff members
- Other duties as assigned
Job Specifications :
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills, and / or abilities required.
Education Requirements :
Minimum Qualifications (Knowledge, Skills and / or Abilities) :
Preferred Qualifications (Knowledge, Skills and / or Abilities)
Physical / Mental Requirements :
Work Environment :
Reports To : Director of Data Strategy and Reporting
FSLA Status : Exempt
Compensation : 804
Work Days : 242
FTE : 100
This job description is not intended to be all inclusive. The employee will also perform other reasonably related business duties as assigned by the supervisor or appropriate administrator. Oklahoma City Public Schools reserves the right to, update, revise or change job duties as the need prevails. This document is for communication only and not intended to imply a written or implied contract of employment. The Board of Education and Superintendent may approve alternatives to the listed qualifications.