Snowflake Data Engineer (Azure)

This is a remote position.

This is a 100% remote job.

Must have 3 verifiable references.

Job Responsibilities:

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.

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

PREFERENCE TO BE GIVEN TO THE CANDIDATES WITH:

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 Pipelines