Snowflake Data Architect

N Consulting Limited; Hove; Hybrid; GBP 70,000 - 100,000; Full time

Job summary

A leading consulting firm is seeking a Snowflake Data Architect for a permanent hybrid role based in Hove. This role involves designing and implementing comprehensive data architectures on the Snowflake platform, ensuring data quality and compliance, whilst collaborating with governance teams and stakeholders. Ideal candidates will have extensive experience in data platforms and a strong background in SQL and Snowflake.

Qualifications

• 10+ years in designing enterprise data platforms, 5+ years in Snowflake.
• Strong expertise in SQL and data warehousing.
• Experience in the insurance industry preferred.

Responsibilities

• Define and implement the end-to-end architecture of Data warehouse on Snowflake.
• Create and maintain data models in Snowflake.
• Design data pipelines and frameworks.

Skills

SQL

Data Warehousing

Snowflake

DBT

Agile Methodologies

Power BI

Job description

Role: Snowflake Data Architect

Location: Hove, UK

Type: Permanent Role

Work Mode: Hybrid

Role & Responsibilities

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

Qualifications & Skills

1. 10+ years of experience in designing enterprise data platforms, with at least 5+ years in Snowflake.
2. Strong expertise in SQL and data warehousing.
3. Hands-on experience working in the insurance industry; prior experience with L&G is an advantage.
4. 3+ years of experience with DBT for data transformation.
5. Deep understanding of agile methodologies in data environments.
6. Familiarity with Power BI.