Inside IR35 - 4 days onsite
We are currently recruiting for an experienced Snowflake 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.