Description

Design and implement the architecture for the EASE solution and the end-to-end cloud data warehouse.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical data models for the cloud data warehouse.
• Build and maintain data models, including Data Vault 2 modeling and information marts.
• Create database scripts, DDL, schemas, and roles across all warehouse layers.
• Implement Validatar tests to ensure data integrity and quality.
• Develop views and role-based security to meet business user requirements.

Required Skills

• 7+ years of data warehouse architecture and modeling experience.
• 3+ years of experience in a cloud environment, preferably Snowflake.
• Expertise in Data Vault 2 modeling and methodology.
• Experience developing conceptual and physical data models.
• Proficiency in writing and deploying code to data warehouse environments.
• Ability to design extract, load, and transform (ELT) logic.
• BS in Business Information Systems, IT, Computer Science, or 10+ years of relevant experience.

Preferred Skills

• Experience developing in Wherescape RED and 3D.
• Experience in the public healthcare industry.

Key Skills

Education

Any Graduate