Snowflake Engineer/Developer - London - Azure - Asset Management

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-native 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 (preferred) 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