Job ID :
39563
Company :
Internal Postings
Location :
Remote,
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
06 Apr 2023
Job Seekers, Please send resumes to resumes@hireitpeople.com
Detailed 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 Synapse pipelines.
  • 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.

Prefence 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 designing and modeling database structures based on business use cases.
  • Azure Data Engineer Associate certification.
  • Experience working with Azure Synapse PipelinesPref.

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.
  • Experience with designing and modeling database structures based on business use cases

Experience required: 7-10 Years