Senior Snowflake Developer – 11889JS

Proactive Appointments Ltd.; West of England; On-site; GBP 129,000 - 142,000; Full time

Job summary

Proactive Appointments Limited is seeking an experienced Senior Snowflake Developer to join a major data platform modernisation programme for a banking client. The role focuses on migrating legacy SQL Server workloads to Snowflake and delivering scalable cloud-based data solutions.

You will work hands-on with Snowflake, dbt, Python and SQL Server, building ETL/ELT pipelines, optimising performance and ensuring governance within a regulated financial services environment.

Qualifications

• Extensive hands-on Snowflake development experience, minimum three years.
• Strong dbt data modelling, transformation, testing and deployment.
• Advanced Python development for data engineering and automation.
• Solid SQL Server knowledge including design, queries and performance tuning.
• Extensive experience designing enterprise ETL/ELT solutions.
• Good understanding of data warehousing, star schemas and dimensional modelling.
• Experience with data governance and data quality in enterprise environments.
• Familiarity with Git-based source control and CI/CD pipelines.
• Proven experience delivering data solutions in Banking or Financial Services.
• Strong stakeholder engagement and communication skills.

Responsibilities

• Develop, enhance and optimise Snowflake data solutions as part of a legacy SQL Server migration programme.
• Build and maintain data transformation pipelines and models using dbt.
• Develop Python scripts and automation solutions to support data migration, processing and operational efficiency.
• Analyse and migrate existing SQL Server databases, queries, stored procedures and data transformation logic to Snowflake.
• Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration.
• Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting.
• Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency.
• Implement automated testing, source control and CI/CD processes to support controlled and reliable deployments.
• Ensure data solutions adhere to enterprise data architecture, governance and control standards.
• Engage with business stakeholders and product owners to gather requirements and translate them into effective technical solutions.
• Troubleshoot complex data issues and support the successful delivery of migration milestones.
• Contribute to technical design decisions, lead development activities and mentor junior developers where required.

Skills

Snowflake

dbt

Python

SQL Server

ETL/ELT

Data warehousing

Data governance

Git

CI/CD

Banking/Financial Services

Tools

Snowflake Cortex

Snowflake Streamlit

Job description

11889JS
£700 – 770 per day

Senior Snowflake Developer

Inside IR35 – 4 days onsite

We are currently recruiting for an experiencedSnowflake Developer to join our banking client on a major data platform modernisation programme.

The successful candidate will play a key role in migrating legacy Microsoft SQL Server workloads to Snowflake, developing and optimising cloud-based data solutions to support critical banking functions.

This is a hands-on development role requiring strong expertise in Snowflake, dbt, Python and SQL Server, alongside a solid understanding of data warehousing, ETL/ELT processes and enterprise data architecture.

You will work closely with business stakeholders, data engineers, architects and wider technology teams to deliver robust, scalable and high-quality data solutions within a regulated financial services environment. Experience in Credit Risk, Market Risk or other banking data domains would be highly advantageous.

Key Responsibilities

• Develop, enhance and optimise Snowflake data solutions as part of a legacy SQL Server migration programme.

• Build and maintain data transformation pipelines and models using dbt.

• Develop Python scripts and automation solutions to support data migration, processing and operational efficiency.

• Analyse and migrate existing SQL Server databases, queries, stored procedures and data transformation logic to Snowflake.

• Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration.

• Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting.

• Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency.

• Implement automated testing, source control and CI/CD processes to support controlled and reliable deployments.

• Ensure data solutions adhere to enterprise data architecture, governance and control standards.

• Engage with business stakeholders and product owners to gather requirements and translate them into effective technical solutions.

• Troubleshoot complex data issues and support the successful delivery of migration milestones.

• Contribute to technical design decisions, lead development activities and mentor junior developers where required.

Essential Skills & Experience

• Extensive hands-on experience developing solutions in Snowflake, ideally with at least three years of dedicated experience.

• Strong experience with dbt, including data modelling, transformation, testing and deployment.

• Advanced Python development skills for data engineering and automation.

• Strong SQL Server experience, including database design, query optimisation, performance tuning and troubleshooting.

• Significant experience designing and delivering enterprise-scale ETL/ELT solutions.

• Strong understanding of data warehousing principles, star schema design, dimensional modelling and data architecture.

• Experience with data governance, data quality and reconciliation within enterprise environments.

• Familiarity with Git-based source control, CI/CD pipelines and structured development and release practices.

• Proven experience delivering data solutions within Banking or Financial Services.

• Strong stakeholder engagement, requirements gathering and communication skills.

• Experience with Snowflake Cortex and Snowflake Streamlit would be highly beneficial

Desirable Skills & Experience

The following experience would be beneficial but is not essential:

• Financial Services: Credit Risk, Market Risk, Counterparty Risk, Treasury, Regulatory Reporting, Capital or Liquidity Reporting.

• Scheduling & Automation: Control-M.

• Microsoft BI Stack: SSIS, SSRS and SSAS.

• Reporting & Analytics: Power BI, semantic models and paginated reports.

• Cloud Technologies: Azure Data Services and cloud migration initiatives.

• Snowflake Ecosystem: Snowflake Streamlit and CoCo.

• Advanced Technologies: AI, Generative AI and Machine Learning applied to data engineering, analytics or reporting.

• Modern Data Processing: Real-time or near-real-time data architectures.

Senior Snowflake Developer

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation