Bonhill Partners are currently supporting a Global Investment Bank in their search for a Snowflake Engineer.
This role will form part of the Risk Team and will be working on a risk reporting migration. This is a senior role within the team.
Key Responsibilities
- Design, develop and optimise Snowflake data pipelines and ETL/ELT processes.
- Develop complex SQL queries, stored procedures and data transformation logic.
- Support the migration of legacy data warehouses and reporting platforms into Snowflake.
- Build and maintain data models, tables, views and curated reporting datasets.
- Develop source-to-target mappings, transformation rules and reconciliation processes.
- Implement automated data quality checks, validation and exception handling.
- Support Risk Reporting across Credit Risk, Market Risk and Counterparty Risk.
- Work with trade, position, counterparty, reference and market data.
- Investigate data discrepancies and perform root cause analysis.
- Support SIT, UAT, parallel runs, production releases and ongoing platform support.
- Ensure data lineage, governance, auditability and reporting accuracy.
- Collaborate with technical and business stakeholders to deliver key programme objectives.
- Strong hands-on Data Engineering experience within financial services or banking.
- Proven commercial experience developing and maintaining Snowflake solutions.
- Advanced SQL skills, including complex queries, joins, CTEs, aggregations and analytical functions.
- Strong experience with ETL/ELT pipeline development and data integration.
- Experience migrating legacy databases, data warehouses or reporting platforms into Snowflake.
- Good understanding of data modelling, warehouse architecture and cloud data platforms.
- Experience with source-to-target mapping, data validation and reconciliation.
- Strong knowledge of data quality, data lineage and governance.
- Experience supporting SIT, UAT, migration testing and production deployments.
- Excellent problem-solving skills and the ability to work with complex datasets and multiple upstream systems.
Data Engineer (Snowflake) in London employer: Bonhill Partners
As a leading global investment bank, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to excel. Our Regulatory Reporting team offers unparalleled opportunities for professional growth, with access to cutting-edge training and development resources, all while working in a fast-paced environment that values collaboration and innovation. Join us in London, where you will be at the forefront of regulatory change initiatives, making a meaningful impact in the world of equities.
