Azure Data Warehouse Developer

Job ID: MS-115833 3pm Remote Azure Data Warehouse Developer with T-SQL, ETL, snowflake, ALM, CI/CD, elastic jobs, modeling, and data engineer experience Location: Jackson, MS, MDEK12 Duration: 12 months Must submit three references along with the resume. Skills: EXPERIENCE: 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 - Familiarity with continuous integration 7 - Experience creating and scheduling elastic jobs 5 - Experience with designing and modeling database structures based on business use cases 5 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 Synapse pipelines. - 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. PROJECT DETAILS: The Mississippi Department of Education (MDE) is developing a new, Azure could native, student information system to replace the legacy system. The legacy system is an on-premises Oracle database solution. The new application is based on the CEDS data warehouse, version 10. https://github.com/CEDStandards/CEDS-Data-Warehouse This project includes creating ETL processes to migrate from the existing system into the new data warehouse format. Additionally building Synapse pipelines to move the data from on-premises into a data lake in Azure.