Snowflake Software Engineer

• This is an opportunity for a technically minded individual to join us as a Snowflake Software Engineer
• You'll be designing, producing, testing and implementing working software across the lifecycle of the system
• Hone your existing software engineering skills and advance your career in this critical role
• You'll be required to attend our London office at least twice a month

What you'll do

Working in a permanent feature team, you'll be developing knowledge of aspects of the associated platform across the disciplines of business, applications, data and infrastructure. You'll also be liaising with principal engineers, architects in the domain and other key stakeholders to understand how the platform works and how it supports business objectives.

You'll also be:

• Applying Agile methods to the development of software on the backlog
• Producing resilient and long-lived software and acting flexibly to cope with future needs
• Delivering intentional architecture and formulating emergent design through innovative ideas, experimentation and prototyping
• Designing and developing software with a focus on the automation of build, test and deployment activities, using executable patterns
• Supporting the design and development of reusable libraries and application programming interfaces for use across the bank
• Supporting the design and development of software that is amenable for a greater automation of build, release testing and deployment process on all environments

We're looking for someone with strong full stack experience in software design and implementation, including being able to exploit programming languages to solve complex problems. You'll also need to be capable of complex requirements analysis capture and validation against and with business and systems requirements. Expertise in writing complex SQL queries, stored procedures, and user-defined functions within Snowflake is essential, along with the ability to implement efficient data pipelines and transformations.

You'll also demonstrate proficiency in designing, developing, and optimising Snowflake data warehouses, with a deep understanding of Snowflake architecture, best practices for data modelling, performance tuning, and secure data sharing, along with previous experience working within Asset Management with exposure to Trading, Risk and Strategy Management.

Additionally, you'll demonstrate:

• Experience using Python for automation and data processing tasks, alongside practical knowledge of Apache Airflow for orchestrating complex data workflows and scheduling within the Snowflake ecosystem
• Proven ability to mentor junior developers, conduct code reviews, and foster a collaborative team environment, with strong communication skills to guide best practices and ensure high-quality deliverables
• Capability to design scalable, maintainable data solutions aligned with business needs, skilled in translating requirements into technical designs, ensuring robustness, security, and future scalability
• Sound collaboration skills with the ability to work with business teams to produce pragmatic solutions that work for the business
• Experience of information security policies and practices within the financial sector
• Strong stakeholder management skills and communication skills with the ability to communicate complex technical concepts in a simple way