Description

Design and manage cloud data warehouse architecture, focusing on data integrity, security, and automated quality assurance.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical data models for cloud data warehouses using Data Vault 2 methodologies.
• Develop and automate testing scripts using Validatar to ensure data integrity and quality across all warehouse layers.
• Create database scripts, including DDL, schemas, and roles, and implement role-based security.
• Build and deploy ETL logic and views to support business stakeholder reporting requirements.

Required Skills

• 7+ years of experience in data warehouse architecture and modeling.
• 5+ years of experience with Wherescape data warehouse automation, specifically Wherescape RED and 3D.
• 4+ years of experience with Data Vault 2 methodology.
• 4+ years of experience working in Snowflake or similar cloud environments.
• 5+ years of experience developing ETL logic.
• 5+ years of experience in QA testing and automated testing script development.
• High proficiency in SQL, R, and Python.

Preferred Skills

• Experience in the public healthcare industry.

Key Skills

Education

Any Graduate