Developer (TSQL)

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.

REQUIRED DEGREE Bachelor's degree
REQUIRED CERTIFICATION(S)

REQUIRED SKILLS/EXPERIENCE # YEARS
Extensive experience with development of stored procedures and ETL processes using T-SQL 7
Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas 7
Use of ALM tools for work item management, version control, code analysis, and testing 7
Broad and extensive knowledge of the software development process and its technologies 7
STATE OF MISSISSIPPI MSP JOB DESCRIPTION
7
Familiarity with continuous integration
Experience creating and scheduling elastic jobs
5
REQUIRED SKILLS/EXPERIENCE
Three (3) references of submitted candidates required. Please provide the following information. Must submit with
resume.
First/last name of reference
Title
Company Name
Job title of contractor while reporting to this supervisor/manager
Telephone number
# YEARS
No min.
Email Address (if available)
Preference given to candidates with the below skills/experience. Must also meet minimum requirements.
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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.