T-SQL Developer

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 of federally required reports using the Generate application
• Translate application storyboards and use cases into functional applications
• 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.

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

Familiarity with continuous integration 7
Experience creating and scheduling elastic jobs

Preference given to candidates with the below skills/experience. Must also meet minimum requirements.

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