Data Engineer (Snowflake)

Bonhill Partners; Greater London; On-site; GBP 90,000 - 140,000; Full time

Job summary

Bonhill Partners Ltd is supporting a Global Investment Bank in its search for a Snowflake Engineer within the Risk Team. This senior role will drive a risk reporting migration and data platform enhancements.

You will design, develop and optimise Snowflake data pipelines, write complex SQL, and collaborate with stakeholders to ensure governance and reporting accuracy across risk domains.

Qualifications

• Senior Data Engineer with Snowflake experience in financial services.
• Proven SQL expertise including complex queries and analytical functions.
• Experience building data models and data governance for reporting platforms.

Responsibilities

• Design, develop and optimise Snowflake data pipelines and ETL/ELT processes.
• Develop complex SQL queries, stored procedures and data transformation logic.
• Support 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.
• Collaborate with stakeholders to deliver programme objectives.

Skills

Advanced SQL

ETL/ELT development

Data modeling

Data governance

Risk data domain

Tools

Snowflake

Job description

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.