T-SQL Developer

T-SQL Developer

Remote

About the Job
• Duration: 12-Month Contract w. possible extension
• Location: Jackson, MS
• Pay rate: Hourly
• Job ID: 135469

Overview:

DataSoft Technologies Inc. is seeking a T-SQL Developer to join our client in Jackson, MS (remote). This project includes updating the Generate data model to utilize version 10 of the CEDS

data warehouse and the update ETL processes that generate federal reports (EDFacts

files) using the data model.

Responsibilities:
• 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.

Qualifications:
• Bachelor’s degree

7 Years of 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

5 Years of experience:
• Experience creating and scheduling elastic jobs

Preferred:
• 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

About our Company

DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:
• Paid Holidays/Paid Time Off (PTO)
• Medical/Dental Insurance Group
• Accident/Critical Illness Insurance
• Life Insurance
• 401 (K)

Location: Jackson, MS, US

Offer Expires: 2024-10-31 00:00:00

Job Posting Language: en

Benefits:

  • Dental Coverage
  • Paid Time Off
  • Health Insurance
  • Retirement Savings

Qualifications:

  • Must possess analytical and complex problem-solving skills
  • Bachelor's degree
  • 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

Responsibilities:

  • data warehouse and the update ETL processes that generate federal reports (EDFacts
  • 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

Benefits:

  • Duration: 12-Month Contract w. possible extension
  • Pay rate: Hourly
  • Paid Holidays/Paid Time Off (PTO)
  • Medical/Dental Insurance Group
  • Accident/Critical Illness Insurance
  • Life Insurance
  • 401 (K)

ZipRecruiter: Apply Here

Indeed: Apply Here

JobScore: Apply Here

BeBee: Apply Here