Senior Snowflake Developer

Deerfoot IT Resources Limited; Greater London; Hybrid; GBP 83,000 - 129,000; Full time

Job summary

Deerfoot Recruitment Solutions Ltd seeks a Senior Snowflake Developer for a hybrid London contract (4 days on-site per week). You will help move legacy data platforms to Snowflake, dbt and Python, shaping the future-state architecture for risk and regulatory reporting.

You will design, build and optimise ELT/ETL pipelines, tune queries for cost and performance, and collaborate with senior stakeholders on high-profile programmes.

Qualifications

• Extensive Snowflake experience with dbt for transformation and deployment.
• Advanced Python development for data engineering and automation.
• Strong SQL Server skills including design, optimization and troubleshooting.

Responsibilities

• Design, build and maintain scalable Snowflake data solutions for risk, finance and regulatory reporting.
• Build and optimize ELT/ETL pipelines and reusable dbt transformation frameworks.
• Develop Python-based processing, automation and integration, and design dimensional data models.
• Tune Snowflake queries and workloads for performance and cost, and resolve production issues.
• Support migration of legacy platforms to the cloud and contribute to standards.
• Lead requirements workshops with business stakeholders and provide technical leadership.

Skills

Snowflake

dbt

Python

SQL Server

Data warehousing

Dimensional modelling

CI/CD

Regulatory reporting

Tools

Control-M

Power BI

SSIS

SSRS

SSAS

Azure data services

Job description

Senior Snowflake Developer

Hybrid - 4 days on-site p/w in London
6 Month Contract, Inside IR35

Are you a Senior Snowflake Developer who wants to build the data platform behind risk reporting at a leading financial services organisation?

We're recruiting for two contract Senior Snowflake Developer positions in a risk reporting function that is moving legacy Microsoft data platforms onto Snowflake, dbt and Python. You'll help shape the future-state architecture and work directly with business stakeholders on high-profile regulatory and risk reporting programmes.

The hiring manager joined via us, so we have a close relationship with them and a detailed understanding of the team and what they need. Most agencies won't have that.

What You'll Be Doing

• Designing, building and maintaining scalable Snowflake data solutions for risk, finance and regulatory reporting
• Building and optimising ELT/ETL pipelines and reusable dbt transformation frameworks
• Developing Python-based processing, automation and integration, and designing dimensional and analytical data models
• Tuning Snowflake queries and workloads for performance and cost, and resolving complex production issues
• Supporting the migration of legacy platforms to the cloud and contributing to architecture and technical standards
• Running requirements workshops with business stakeholders and providing technical leadership through delivery

What You'll Bring

• Extensive hands-on Snowflake experience, with strong dbt for transformation, modelling and deployment
• Advanced Python development for data engineering and automation
• Strong SQL Server experience, including database design, optimisation and troubleshooting
• Solid grounding in data warehousing, star schema and dimensional modelling, plus source control and CI/CD
• Banking or financial services background, ideally credit or market risk, with the confidence to engage senior stakeholders

Desirable: Control-M, Power BI, SSIS, SSRS, SSAS, Azure data services, Snowflake Streamlit, cloud migration, near-real-time processing, AI or generative AI tools, market, credit or counterparty risk, regulatory reporting, capital and liquidity reporting

Please note: this role needs four days a week on site in London on an ongoing basis.

This role may suit candidates who have held roles including: Snowflake Developer, Snowflake Data Engineer, Senior Data Engineer, Data Warehouse Developer, dbt Developer, Analytics Engineer, Senior ETL Developer, Data Platform Engineer

Deerfoot Recruitment Solutions Ltd is a leading independent tech recruitment consultancy in the UK. For every CV sent to clients, we donate 1 to The Born Free Foundation. We are a Climate Action Workforce in partnership with Ecologi. If this role isn't right for you, explore our referral reward program with payouts at interview and placement milestones. Visit our website for details. Deerfoot Recruitment Solutions Ltd acts as an Employment Business in relation to this vacancy.