Azure Data Engineer

Job Description:

• 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