Description

You will build and maintain data warehouse structures to support analytics, reporting, and dashboarding requirements.

Responsibilities

• Develop and maintain the Data Warehouse using industry standard best practices and business requirements.
• Create, execute, and monitor ETL processes, including documenting all findings.
• Design stable, optimized databases in collaboration with DBAs, system architects, and application developers.
• Plan and coordinate data migrations between systems.
• Write SQL test scripts to validate data points against transactional systems and the warehouse.
• Coordinate unit, system, and performance testing, and assist with User Acceptance testing.

Required Skills

• 5+ years of experience in ETL methodologies and development.
• Extensive experience with SSIS.
• Strong SQL Server scripting and data modeling skills.
• Experience working with Azure SQL Instance.
• Deep understanding of Data Warehousing principles, concepts, and architecture.
• Solid grasp of programming concepts and the Software Development Lifecycle (SDLC).
• Ability to analyze requirements and visualize complex issues.
• Bachelor's degree in Computer Science, IT, Engineering, or a related field, or equivalent software development experience.

Key Skills

Education

Bachelor's degree