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.