T-SQL Developer - SMEThe Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID).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.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/systemsWorking closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse systemWorking in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate applicationTranslate application storyboards and use cases into functional applicationsAbility to work independently and cooperatively as part of a teamAbility to work under severe time constraintsMust possess analytical and complex problem-solving skillsExtensive experience with development of stored procedures and ETL processes using T-SQLThorough understanding of data warehouse design hierarchies such as star and snowflake schemasUse of ALM tools for work item management, version control, code analysis, and testingBroad and extensive knowledge of the software development process and its technologiesFamiliarity with continuous integrationExperience creating and scheduling elastic jobsPreference given to candidates with the below skills/experience. Must also meet minimum requirements:Experience with student information management systems and K-12 data and reportingExperience with Common Education Data Standards (CEDS)Experience with EDFacts Federal ReportingExperience with designing and modeling database structures based on business use cases.Net/Angular experienceAzure Synapse pipeline experience