Job Details

AGENCY

MDEK12-Mississippi Department of Education

JOB TITLE

T-SQL Developer

BACKGROUND CHECK

Standard HireRight Package B

HOURS

8-5pm 40hrs/week

ON-SITE OR OFF-SITE

Off-Site

ON-CALL REQUIRED

Yes- Possible during module

OVERTIME (40+ HOURS)

Rarely

TRAVELED REQUIRED

No

EXPENSES REIMBURSED

No

PROJECT NAME

OTSS

THIS IS A REPOST

100% remote. Must submit three references with resume. Most likely to last longer than Sept. 2024, that's just the end date Education uses for all contractors. This is a long-term assignment. This is a duplicate of previous JP# 119468. If you feel your previously submitted candidate should get another look, feel free to submit.

PROJECT DETAILS

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.

JOB DESCRIPTION

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.

• Experience with student information management systems and K-12 data and reporting
• Experience with Common Education Data Standards (CEDS)
• Experience with ED Facts Federal Reporting
• Experience with designing and modeling database structures based on business use cases
• .Net/Angular experience
• Azure Synapse pipeline experience