Employer Active
- USA
Not Disclosed
Salary Not Disclosed
1 Vacancy
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.
This position will require a qualified SQL DBA to take the lead in the following tasks:
Must possess analytical and complex problemsolving skills.
REQUIRED SKILLS/EXPERIENCE
# YEARS
Extensive experience with development of stored procedures and ETL processes using TSQL
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
Familiarity with continuous integration
7
Experience creating and scheduling elastic jobs
5
Preference given to candidates with the below skills/experience. Must also meet minimum requirements.
Experience with student information management systems and K12 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
Full Time