Description

You will lead data rationalization and mapping between transactional and dimensional database models.

Responsibilities

• Map and rationalize data between transactional and dimensional database systems.
• Develop stored procedures and ETL processes in coordination with database and system administrators.
• Design, develop, and manage federally required reports using the Generate application.
• Translate application storyboards and use cases into functional applications.
• Collaborate with vendors and agency staff to meet project requirements under tight deadlines.

Required Skills

• 7 years of experience developing stored procedures and ETL processes using T-SQL.
• 7 years of experience with data warehouse design hierarchies, including star and snowflake schemas.
• 7 years of experience using ALM tools for work item management, version control, code analysis, and testing.
• 7 years of experience with the software development process and its associated technologies.
• 7 years of experience with continuous integration.
• 5 years of experience creating and scheduling elastic jobs.
• Proficiency with T-SQL, AWS, and React.
• Bachelor's degree in Computer Science.

Key Skills

Education

Bachelor's degree in Computer Science