135469 -T-SQL Developer- MS - MDEK12

E-Solutions Group - Jackson, MS

Full-time

Jackson, MS

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The T-SQL Developer position is a contract role focused on developing and managing data processes for a data warehouse system. The developer will work closely with database administrators and other stakeholders to create stored procedures, ETL processes, and federally required reports. The role requires strong analytical skills and the ability to work under tight deadlines, both independently and as part of a team.

Responsibilities

• Rationalizing and mapping data between transactional and dimensional database models/systems
• Developing stored procedures and ETL processes related to the data warehouse system
• Collaborating with vendors and agency staff to design, develop, and manage federally required reports
• Translating application storyboards and use cases into functional applications
• Working independently and cooperatively as part of a team
• Working under severe time constraints
• Utilizing analytical and complex problem-solving skills

Requirements

• Extensive experience with the development of stored procedures and ETL processes using T-SQL
• Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
• Use of ALM tools for work item management, version control, code analysis, and testing
• Broad and extensive knowledge of the software development process and its technologies
• Familiarity with continuous integration
• Experience creating and scheduling elastic jobs

Nice-to-haves

• 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