Epicareer Might not Working Properly
Learn More

100% Remote: T- SQL SME

Salary undisclosed

Apply on

Availability Status

This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.


Original
Simplified

Role: T- SQL SME

Location: Jackson, MS (100% Remote, Need Locals)

Duration: 12+ Months

Webex Interview

Description:

  • T-SQL Developer - SME
  • Additional documents required when resume is submitted, pay close attention to requirements
  • The client is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID).
  • The current Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10.
  • 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 (ED Facts files) using the data model.

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: Bachelors

Required Certification(s)

Skill Matrix:

Skills

Years of Experience Needed

Y/N

Stored procedures ETL Using T- SQL

7

Thorough Understanding of Data Warehouse Design hierarchies such as Star & Snowflake schemas

7

Use of ALM Tools for work item management, Version control, code analysis, testing

7

Extensive knowledge of Software development & its technologies

7

Familiarity with CI (Continous Integration)

7

Experience creating & Scheduling elastic Jobs

5

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job