Data Validation Support Engineer (PED #10101736)
Apply NowCompany: State of New Mexico
Location: Santa Fe, NM 87507
Description:
$29.66 - $47.46 Hourly
$61,700 - $98,720 Annually
This position is a Pay Band ID
Posting Details
THIS POSTING WILL BE USED FOR ONGOING RECRUITMENT. APPLICANT LISTS MAY BE SCREENED MORE THAN ONCE.
All positions at the NM Public Education Department are based in Santa Fe, however some may operate through our Albuquerque office based on home address and space availability.
MISSION: EQUITY, EXCELLENCE AND RELEVANCE - The New Mexico Public Education Department partners with educators, communities, and families to ensure that ALL students are healthy, secure in their identity, and holistically prepared for college, career, and life.
VISION: ROOTED IN OUR STRENGTHS - Students in New Mexico are engaged in a culturally and linguistically responsive educational system that meets the social, emotional, and academic needs of ALL students.
Information Technology:
Vision
Connecting New Mexico with accurate and actionable education data.
Mission
Create and improve systems, rules, and processes that provide broader access to better information necessary to support PED achieve its mission and goals.
Why does the job exist?
This position for the Public Education Department (PED), is necessary for analyzing business rule requirements, designing efficient business logic, developing data validation rules and associated SQL code, testing and deploying data validation scripts to ensure high-quality data ingestion into the agency Common Education Data Standards (CEDS) longitudinal data warehouse system.
How does it get done?
This position requires effective planning, interpersonal skills and coordination with PED IT staff and Local Education Agency (LEA) Student Information System (SIS) Administrators to communicate findings, results, data exceptions and corrections, and data validation support.
1) Requirements Gathering (20%) work with PED Business Analyst to identify, document and categorize data needs and business rules for student and teacher accountability data submissions from school districts and charter schools. Wok with PED Business Analyst to map data elements to the Ed-Fi data standard.
2) Analysis and Design (20%) design logic to validate accuracy of data based on documented business rules.
3) Implementation (40%) - Create SQL scripts, stored procedures, or other programming code to validate data, ensure proper Ed- Fi data model compliance and data accuracy. Provide useful and appropriate error handing and exception reports to facilitate data corrections and resubmissions. Work with LEA's to assist with error correction via the Help Desk and ticket handling process.
4) Technical Writing (10%) - Develop Standard Operating Procedure documentation for onboarding new staff
5) Training (10%) - Train and mentor school district and charter school SIS administrators in the procedures for preparing data
submissions, interpreting error reports and correcting rejected data.
Who are the customers?
PED programs, LEA's, School Districts, Charter Schools, Partner State Agencies, State Legislators, parents, teachers and the general public.
Ideal Candidate
The ideal candidate would have the following experience: Experience developing scripts using SQL and Transact-SQL, developing and deploying SQL Server stored procedures, Application Programming Interface (API) and/or application development experience with .NET, PHP or Python. Experience using SQL server.
Minimum Qualification
Associate degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering, or similar technical degree and two (2) years of experience in software programming. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling four (4) years may substitute for the required education and experience.
Substitution Table
These combinations of education and experience qualify you for the position:
Education Experience Education Experience 1 High School Diploma or Equivalent AND 4 years of experience OR High School Diploma or Equivalent AND 4 years of experience 2 Associate's degree in the field(s) specified in the minimum qualification AND 2 years of experience Associate's degree or higher in any field AND 4 years of experience 3 Bachelor's degree or higher in the field(s) specified in the minimum qualification AND 0 years of experience
Education and years of experience must be related to the purpose of the position.
If Minimum Qualification requires a specific number of "semester hours" in a field (e.g. 6 semester hours in Accounting), applicants MUST have those semester hours in order to meet the minimum qualifications. No substitutions apply for semester hours.
Employment Requirements
Must possess and maintain a valid New Mexico's Driver's License.
Working Conditions
Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending and reaching may be required.
Supplemental Information
Do you know what Total Compensation is? Click here
Agency Contact Information: Conrad Cordova (505)- 695-5954. Email
For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.
Bargaining Unit Position
This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.
$61,700 - $98,720 Annually
This position is a Pay Band ID
Posting Details
THIS POSTING WILL BE USED FOR ONGOING RECRUITMENT. APPLICANT LISTS MAY BE SCREENED MORE THAN ONCE.
All positions at the NM Public Education Department are based in Santa Fe, however some may operate through our Albuquerque office based on home address and space availability.
MISSION: EQUITY, EXCELLENCE AND RELEVANCE - The New Mexico Public Education Department partners with educators, communities, and families to ensure that ALL students are healthy, secure in their identity, and holistically prepared for college, career, and life.
VISION: ROOTED IN OUR STRENGTHS - Students in New Mexico are engaged in a culturally and linguistically responsive educational system that meets the social, emotional, and academic needs of ALL students.
Information Technology:
Vision
Connecting New Mexico with accurate and actionable education data.
Mission
Create and improve systems, rules, and processes that provide broader access to better information necessary to support PED achieve its mission and goals.
Why does the job exist?
This position for the Public Education Department (PED), is necessary for analyzing business rule requirements, designing efficient business logic, developing data validation rules and associated SQL code, testing and deploying data validation scripts to ensure high-quality data ingestion into the agency Common Education Data Standards (CEDS) longitudinal data warehouse system.
How does it get done?
This position requires effective planning, interpersonal skills and coordination with PED IT staff and Local Education Agency (LEA) Student Information System (SIS) Administrators to communicate findings, results, data exceptions and corrections, and data validation support.
1) Requirements Gathering (20%) work with PED Business Analyst to identify, document and categorize data needs and business rules for student and teacher accountability data submissions from school districts and charter schools. Wok with PED Business Analyst to map data elements to the Ed-Fi data standard.
2) Analysis and Design (20%) design logic to validate accuracy of data based on documented business rules.
3) Implementation (40%) - Create SQL scripts, stored procedures, or other programming code to validate data, ensure proper Ed- Fi data model compliance and data accuracy. Provide useful and appropriate error handing and exception reports to facilitate data corrections and resubmissions. Work with LEA's to assist with error correction via the Help Desk and ticket handling process.
4) Technical Writing (10%) - Develop Standard Operating Procedure documentation for onboarding new staff
5) Training (10%) - Train and mentor school district and charter school SIS administrators in the procedures for preparing data
submissions, interpreting error reports and correcting rejected data.
Who are the customers?
PED programs, LEA's, School Districts, Charter Schools, Partner State Agencies, State Legislators, parents, teachers and the general public.
Ideal Candidate
The ideal candidate would have the following experience: Experience developing scripts using SQL and Transact-SQL, developing and deploying SQL Server stored procedures, Application Programming Interface (API) and/or application development experience with .NET, PHP or Python. Experience using SQL server.
Minimum Qualification
Associate degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering, or similar technical degree and two (2) years of experience in software programming. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling four (4) years may substitute for the required education and experience.
Substitution Table
These combinations of education and experience qualify you for the position:
Education Experience Education Experience 1 High School Diploma or Equivalent AND 4 years of experience OR High School Diploma or Equivalent AND 4 years of experience 2 Associate's degree in the field(s) specified in the minimum qualification AND 2 years of experience Associate's degree or higher in any field AND 4 years of experience 3 Bachelor's degree or higher in the field(s) specified in the minimum qualification AND 0 years of experience
Education and years of experience must be related to the purpose of the position.
If Minimum Qualification requires a specific number of "semester hours" in a field (e.g. 6 semester hours in Accounting), applicants MUST have those semester hours in order to meet the minimum qualifications. No substitutions apply for semester hours.
Employment Requirements
Must possess and maintain a valid New Mexico's Driver's License.
Working Conditions
Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending and reaching may be required.
Supplemental Information
Do you know what Total Compensation is? Click here
Agency Contact Information: Conrad Cordova (505)- 695-5954. Email
For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.
Bargaining Unit Position
This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.