Data Engineer (Snowflake)

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.