MBR: *** Remote. This is a two-day urgent posting, note the expiration date.
Project Details
The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID). This project involves updating the Generate data model to utilize version 10 of the CEDS data warehouse and updating ETL processes that generate federal reports (EDFacts files) using the data model.
Responsibilities
- Rationalizing and mapping data between transactional and dimensional database models/systems
- Developing stored procedures and ETL processes related to the data warehouse system in collaboration with database and system administrators
- Working with vendors and other agency staff to design, develop, and manage the creation of federally required reports using the Generate application
- Translating application storyboards and use cases into functional applications
- Working independently and cooperatively as part of a team
- Working under severe time constraints
- Possessing analytical and complex problem-solving skills
Required Qualifications
- Bachelor’s degree
- Extensive experience with development of stored procedures and ETL processes using T-SQL (7 years)
- Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas (7 years)
- Experience with ALM tools for work item management, version control, code analysis, and testing (7 years)
- Broad and extensive knowledge of the software development process and its technologies (7 years)
- Familiarity with continuous integration (7 years)
- Experience creating and scheduling elastic jobs (5 years)
References
Three (3) references of submitted candidates required. Please provide the following information when submitting your resume:
- First/last name of reference
- Title
- Company Name
- Job title of contractor while reporting to this supervisor/manager
- Telephone number
- Email Address (if available)
Preferred Qualifications
- 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