T-SQL Developer - SME with K12 -Education Experience (100% Remote)
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Education department experience for State is needed.
THIS IS NOT A .NET DEVELOPER POSITION
Client: State of Mississippi -
Position: Developer - T-SQL Developer - SME - MS - MDEK12 – 135479 (Remote)
Start Date: Immediately
Work Option: Remote
Contract: Until 02/08/2026
Shift Hours: 8 AM to 5 PM (40 Hours per Week). OT: Rarely
On Call Required: Yes – Possible during module releases
Background Check : Standard HireRight Package B
Closing on 10/3/2024 @ 3PM CST.
Position Description
Project Name: OTSS
Agency: MDEK12 – Mississippi Department of Education
Project Overview:
The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID).
The current Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10.
This project includes updating the Generate data model to utilize version 10 of the CEDS data warehouse and the update ETL processes that generate federal reports (EDFacts files) using the data model.
Major Responsibilities
- This position will require qualified T-SQL Developers to take the lead in the following tasks:
- Rationalizing and mapping data between transactional and dimensional database models/systems
- Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system
- Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application
- Translate application storyboards and use cases into functional applications
- Ability to work independently and cooperatively as part of a team.
- Ability to work under severe time constraints.
- Must possess analytical and complex problem-solving skills.
Required Degree/Education Level
Bachelor’s Degree
Preferred Skill
- Experience with student information management systems and K-12 data and reporting
- Experience with Common Education Data Standards (CEDS)
- Experience with EDFacts Federal Reporting
- Experience with designing and modeling database structures based on business use cases
- .Net/Angular experience
- Azure Synapse pipeline experience