Senior Snowflake Developer – 11889JS

« Back to Jobs

Senior Snowflake Developer – 11889JS

Proactive Appointments Ltd. | West of England, ENG, GB

Posted a month ago

Apply Now

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


#J-18808-Ljbffr