Required Experience and Skills
- Experienced in Data Vault 2.0 modelling and implementation
- Experienced in Snowflake
- Experienced working in agile scrum methodology
- Desirable: Experience with db2 zOS mainframe
System Goals and Objectives
- Provide a scalable, reliable, and highly secure data warehouse solution for group data.
- Replace GMD Db2 LUW with Snowflake
- Transfer reports from Db2 to Snowflake
- Scalable - handle more users, larger volumes of data - without the complexity and cost of additional hardware and clustering
- Managed Solution - simplifies database administration effort - automated backups
- Increased Resiliency - Multi Availability Zone (AZ) data replication
- Increased Security - Data encryption at rest, and Bring Your Own Key
- Sanitised RBAC security model
- Single Sign On - Azure AD integration with Snowflake, including SSO and Account Lifecycle Management
- Potential for streamed data loading as well as batch
- Provide users with the ability to create business intelligence and analytics reports in a secure, reliable, ANSI-SQL compatible environment.