Snowflake Developer (Inside IR35)

This role offers hybrid working - 2 days office based weekly.

The initial contract will be for 6-12 months - Inside IR35.

Job Responsibilities

• You will be responsible for maintaining the enterprise data platform, ensuring data flows seamlessly from source systems into the Snowflake environments.
• Your focus will be on building robust data pipelines, managing transformations in Snowflake in order to deliver high-performance data models that directly support our Power BI reporting layer.
• Design and implement a dimensional model within Snowflake, to serve as the foundation for enterprise reporting & analytics.
• Build and maintain production-grade data transformation workflows, ensuring code is version-controlled, tested, and documented.
• Optimize Snowflake warehouses to ensure cost-efficiency and query performance.
• Develop and manage data pipelines using Azure Data Factory (ADF) to ingest data from various data sources.
• Manage Role-Based Access Control (RBAC) and data masking policies within Snowflake to protect sensitive legal and client data.

Skills Required

• Strong hands-on experience with Snowflake architecture, administration, and performance optimization.
• Experience with Azure Data Factory (ADF) for orchestration and ingestion.
• Deep understanding of dimensional modelling and data warehousing concepts.
• Ability to translate technical data concepts for non-technical legal and business stakeholders.