Data Validation Specialist

okgov; United States; On-site; USD 48,000 - 58,000; Full time

Benefits offered by this job

Health Insurance

Flexible Spending Accounts

TRS participation

Vacation and sick leave

Job summary

The Oklahoma State Department of Education seeks a Data Validation Specialist to ensure data accuracy and integrity across OSDE systems using SQL for data manipulation and validation. You will develop QC procedures, support SLDS migration validation, and collaborate with SMEs to troubleshoot issues.

In-person presence is required at the Oklahoma City workplace. Requires a bachelor’s degree in CS/Math/Stats/Informatics or related field and one year of SQL experience.

Qualifications

• Bachelor’s degree in Computer Science, Mathematics, Statistics, Informatics, MIS or related field.
• One year of programming experience in SQL or other programming languages.

Responsibilities

• Manipulate and analyze data using SQL to ensure accuracy and consistency.
• Develop and maintain quality control procedures for data migration and validation.
• Collaborate with SMEs to identify, troubleshoot, and resolve data validation issues.
• Assist with validation and testing related to the SLDS migration and reporting needs.

Skills

SQL

Data analysis

Education

Bachelor's degree in Computer Science or related field

Job description

Job Posting

Data Validation Specialist

Agency

265 DEPARTMENT OF EDUCATION

Supervisory Organization

Department of Education-Oliver Hodge Education Building

Job Posting End Date

Refer to the date listed at the top of this posting, if available. Continuous if date is blank.
Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.

Estimated Appointment End Date

Continuous if Blank

Full/Part-Time

Full time

Job Type

Regular

Compensation

$53,000

Job Description

POSITION OVERVIEW
The Data Validation Specialist plays a critical role in ensuring the accuracy, integrity, and reliability of data within the Oklahoma State Department of Education's systems by leveraging structured programming languages such as SQL to perform data manipulation and analysis, developing and maintaining comprehensive quality control procedures throughout data migration and validation processes, and collaborating closely with agency subject matter experts to identify, troubleshoot, and resolve issues. In addition, this position supports the State Longitudinal Data System (SLDS) migration by assisting with validation and testing activities and providing guidance to district users as they navigate reporting validation needs during both testing and implementation phases.
Please note: this role does not allow for any form of remote work, including telecommuting or hybrid arrangements. The nature of this position necessitates a consistent in-person presence. Prospective candidates should be aware that the responsibilities associated with this role require physical presence at the designated workplace in Oklahoma City, Oklahoma.

ESSENTIAL FUNCTIONS

• Data Manipulation and Analysis: Efficiently use structured programming languages, such as SQL, to manipulate and analyze data for accuracy and consistency.


• Quality Control Procedures: Develop and maintain comprehensive quality control procedures to ensure data integrity at various stages of data migration and validation.


• Team Collaboration: Collaborate effectively with agency subject matter experts (SMEs) to identify, troubleshoot, and resolve data validation issues.


• Reporting Validation and Testing: Assist the Oklahoma State Department of Education (OSDE) with validation and testing related to the SLDS migration. Support district users with reporting validation or issues during the testing and implementation phases.

MINIMUM QUALIFICATIONS

• Bachelor's degree in Computer Science, Mathematics, Statistics, Informatics, Management Information Systems, or a related field;


• One (1) year of programming experience in SQL, and/or other programming languages.


• Or an equivalent combination of education and experience, substituting one year of relevant experience for each year of the required education.

SPECIAL REQUIREMENTS

• Applicants must be currently authorized to work in the United States on a full-time basis without sponsorship now or in the future;


• Successful completion of a pre-employment background check;


• Must possess a valid driver's license from a U.S. state or territory to perform necessary job-related travel.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

Location : Oliver Hodge Building, Oklahoma City, Oklahoma

Physical Demands include :

• Ability to stand, reach, and bend 50% of the time;


• Operates a computer and other office productivity machinery, such as a calculator, copy machine/printer, and office telephone 75% of the time;


• Ascends/descends stairs 25% of the time;


• Ability to lift to 25 lbs.

Cognitive Requirements :

• This role requires clear and accurate communication, strong analytical skills, and the ability to evaluate information and make timely decisions.


• Sustained focus and attention to detail are essential, along with memory retention of policies, procedures, and facts over various time frames.


• Adaptability and mental flexibility are also necessary to handle changing information, work conditions, and unexpected challenges.

Discover the Benefits of Joining Our Team!

• Generous Benefits Allowance : Up to $21,934.08 annually, tailored to family size, for purchasing benefits.


• Comprehensive Insurance Plans : Choose from a variety of insurance plans with no pre-existing conditions, exclusions, or limitations.


• Flexible Spending Accounts : Manage healthcare expenses and/or dependent care with ease.


• Full Participation in TRS : Enjoy employer-covered contributions (7.5% of annual salary) for Teacher's Retirement System participation.


• Generous Leave Policy : Full-time employees receive 15 days of vacation and 15 days of sick leave in their first year.


• Paid Holidays : Benefit from 11 paid holidays per yea