Job Seekers, Please send resumes to resumes@hireitpeople.comDetailed 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