Senior Data Engineer

This is a pivotal role sitting at the intersection of financial data integrity and cloud transformation. You will own the ETL pipeline that underpins monthly, quarterly and year-end close cycles, while simultaneously driving a strategic migration from legacy on-premise infrastructure to a modern, cloud-native data platform., * Managing and monitoring the ETL pipeline to ensure timely and accurate financial reporting.

• Acting as the technical point of contact during the Monthly, Quarterly and Year-end Close process.
• Design and build scalable ETL workflows using Azure Data Factory and Databricks, replacing legacy SSIS pipelines.
• Identifying opportunities to harden and automate manual steps within the Finance Close workflow
• Conduct T-SQL performance tuning across on-prem and cloud environments.Conduct T-SQL performance tuning across on-prem and cloud environments.
• Collaborate with IT and business stakeholders to fix data issues, gather requirements and produce technical documentation.
• Establish CI/CD best practices using Azure DevOps.

• Experience of supporting the Phinsys System is highly desirable.
• Hands-on experience of Cloud based platforms and technologies such as Synapse Analytics, Fabric, Databricks, Snowflake.
• Azure DBA experience is advantageous.
• Solid knowledge of ETL technologies, specifically SSIS and Azure Data Factory and pipelines.
• Solid knowledge of core SQL Server elements including T-Sql, queries, stored procedures, functions and SSAS.
• Comfortable working with Visual Studio IDE (VS2022 and later).
• Comfortable working with Azure DevOps for source code control.

You will have genuine ownership of a business-critical pipeline that the finance function depends on every single month, while simultaneously shaping the cloud architecture that will underpin the organisation for years to come.

If you are an experienced Data Engineer with knowledge working in a similar London Insurer, please get in touch for more information.