Snowflake Engineer/Developer - London - Azure - Asset Management - Strike IT

ZipRecruiter; London; On-site; GBP 60,000 - 85,000; Full time

Job summary

A leading asset management firm is looking for a Snowflake/Azure Data Engineer to support a transformative data initiative. In this role, you will design and optimise data pipelines, work with technical leads, and ensure data governance while collaborating closely with various stakeholders. Ideal candidates will have significant experience with Snowflake and Azure tools, as well as a background in investment operations.

Qualifications

• Expert in developing data models, procedures, pipelines, and secure data sharing in Snowflake.
• Experience with Azure SQL and Azure Data Lake.
• Familiarity with data security measures and governance.

Responsibilities

• Lead the design and optimisation of data pipelines in Snowflake.
• Build and orchestrate ETL/ELT pipelines using Azure tools.
• Implement best practices in data security and governance.

Skills

Snowflake Ownership

Azure Data Engineering

SQL Proficiency

Optimisation Techniques

Data Governance

Tools

Azure Data Factory

Git

Terraform

DBT

Job description

Job Description

A leading asset manager is embarking on a cloud-based data transformation and is seeking a skilled Snowflake/Azure Data Engineer to support the delivery of a scalable, secure, and insight-ready data platform. This greenfield initiative will enhance capabilities across investment operations, risk, compliance, ESG reporting, and portfolio analytics.

This role offers the opportunity to work closely with technical leads and senior business stakeholders, owning core aspects of Azure- data pipeline development, with Snowflake playing a key role in the modernisation roadmap.

INSIDE IR35

3 DAYS ONSITE AT THE OFFICE IN LONDON

Responsibilities

• Snowflake Ownership: Take the lead in designing, developing, and optimising data pipelines, models, and workflows in Snowflake, with responsibility for performance, cost-efficiency, and governance.
• Optimise query performance and storage efficiency using Snowflake features such as clustering, partitioning, and resource monitoring.
• Azure Data Engineering: Build and orchestrate ETL/ELT pipelines using Azure Data Factory, with staging and transformation pipelines integrating into Snowflake and Azure SQL.
• Technical Collaboration: Work alongside architects and engineering leads to implement secure, well-governed, and performant data infrastructure - leveraging tools like Git, Terraform, DBT, and CI/CD pipelines.
• Data Engineering: Design and implement ETL/ELT pipelines, transformation logic, and robust ingestion processes from various internal and third-party sources.
• Support integration with investment systems, including Aladdin, where applicable, and help facilitate consistent and reliable data across platforms.
• Governance & Optimisation: Implement best practices in data security, access controls, lineage tracking, and cost-efficient compute/storage optimisation in Azure and Snowflake.

Experience

• Expert in developing data models, procedures, pipelines, Streams, Tasks, and secure data sharing in Snowflake
• Experience with optimising Snowflake performance, including virtual warehouses, clustering, partitioning, and cost controls
• Strong understanding of Snowflake architecture, security (RBAC), and governance
• Strong practical experience with Azure Data Factory, Azure SQL, Azure Data Lake, and Azure DevOps
• Proficiency in SQL, performance tuning, and ETL/ELT techniques for large datasets
• Familiarity with DBT OR other transformation frameworks
• Proficient with Git-based workflows, Terraform, and CI/CD pipelines
• Aladdin Exposure, Knowledge of Aladdin Data Cloud (ADC) or similar investment data platforms is a bonus.
• Proven experience in a buy-side or investment management environment
• Understanding of front-to-back investment data flow is a strong plus