Snowflake Data Architect

ZipRecruiter; England; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A prominent company is seeking a Snowflake Data Architect to define and implement the architecture of a data warehouse using Snowflake. The successful candidate will possess extensive experience in data platform design and work closely with various teams to ensure data governance, quality, and security compliance. This hybrid permanent position is based in Hove, UK.

Qualifications

• 10+ years experience in designing enterprise data platforms.
• 5+ years experience specifically in Snowflake.
• Hands-on experience in the insurance sector.

Responsibilities

• Define and implement data warehouse architecture on Snowflake.
• Create and maintain data models in Snowflake.
• Design data pipelines and ingestion frameworks.

Skills

SQL

Data Warehousing

DBT

Agile

Power BI

Job description

Job Description

Role: Snowflake Data Architect

Location: Hove, UK

Type: Permanent

Work Mode: Hybrid

Role & Responsibilities

• Define and implement the end-to-end architecture of Data warehouse on Snowflake.
• Create and maintain conceptual, logical, and physical data models in Snowflake.
• Design data pipelines and ingestion frameworks using Snowflake tools.
• Collaborate with Data Governance teams to establish data lineage, data quality, and access control mechanisms.
• Engage with data stewards and stakeholders to build a comprehensive and scalable data warehouse.
• Implement RBAC, data masking, and encryption practices to ensure compliance with data security policies.

You Must Possess

• 10+ years of experience in designing enterprise data platforms, with at least 5+ years in Snowflake.
• Strong expertise in SQL and data warehousing.
• Hands-on experience working in the insurance sector (prior experience with L&G is an advantage)
• 3+ years of experience with DBT for data transformation.
• Deep understanding of Agile methodologies in a data environment.
• Familiarity with Power BI.