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 en
#J-18808-Ljbffr
Senior Snowflake Developer in London employer: Proactive Appointments
Join a dynamic team as an IT Support Analyst in the vibrant area near Stamford, where you will benefit from a supportive work culture that prioritises employee growth and development. With a competitive salary and an impressive benefits package including hybrid working options, private medical and dental care, and a subsidised gym membership, this role offers a fulfilling and rewarding career path in a company that values its employees.
