T-SQL Developer

Position: T-SQL Developer

Location: Remote - Jackson, MS

Contract Term: 15 Months

Hours / Week: 40

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 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.

Required Degree Bachelor’s degree

Required Skills/Experience

• Extensive experience with 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

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 modelling database structures based on business use cases

• .Net/Angular experience

• Azure Synapse pipeline experience