Data Engineer

Client Industry: London Market Insurance

Albany Beck is a specialist financial services consultancy delivering technology, transformation, data, risk and operational change programmes across leading banks, insurers and investment firms. As an Albany Beck consultant, you will join our team and work directly with a leading London Market insurance client, supporting the continued development and operation of its Exposure Management technology estate.

We are looking for a hands‑on Data Engineer to support business‑critical Exposure Management platforms and processes. The role will combine advanced SQL development, data engineering, production support, automation and technical troubleshooting. You will work closely with Exposure Management, Product Management, Engineering, Architecture, QA and database teams to maintain existing services while delivering system enhancements and reducing manual operational activity. You will take technical ownership of daily and month‑end processes, investigate production incidents and data‑quality issues, and help improve the resilience, efficiency and automation of the wider Exposure Management environment.

• Provide technical and production support for Exposure Management applications and processes.
• Monitor and investigate failed jobs, failed data runs, production incidents and data‑quality issues.
• Develop and maintain advanced SQL processes, stored procedures, views, functions and database jobs.
• Build and support ETL processes, data integrations and automated file‑transfer solutions.
• Support business‑critical daily and month‑end reporting, aggregation and data‑processing activities.
• Troubleshoot backend application issues and resolve technical problems affecting system availability.
• Deliver automation initiatives that reduce manual intervention and operational risk.
• Support deployment, testing, release management and code promotion across development, UAT and production environments.
• Contribute technical input to solution design, product backlog refinement and continuous‑improvement initiatives.
• Develop reporting and analytics solutions using tools such as SSRS and Power BI.
• Maintain technical documentation, operational procedures, knowledge articles and support runbooks.
• Work directly with Exposure Management stakeholders to understand requirements and deliver practical system enhancements.
• Collaborate with Product Managers, Analysts, Architects, QA Engineers and DBAs.

• Strong commercial experience working as a Data Engineer, SQL Developer, Application Support Engineer or similar technical role.
• Advanced T‑SQL development experience, including - Stored procedures, Views, functions and triggers, Query optimisation and performance tuning, SQL Agent jobs, Database troubleshooting, Data modelling and schema design
• Experience developing and supporting ETL and data‑integration processes.
• Experience with SSIS or an equivalent integration tool.
• Strong understanding of batch processing, data validation, reconciliation and large‑scale data transformation.
• Experience supporting business‑critical production applications and investigating failed processes.
• Experience working with file‑based integrations, SFTP and automated file transfers.
• Knowledge of reporting and analytics tools such as SSRS or Power BI.
• Experience using Azure Dev Ops or Git for source control and release management.
• Understanding of Agile, Dev Ops, CI/CD and automated testing principles.
• Strong technical troubleshooting and problem‑solving skills.
• Ability to communicate technical concepts clearly to business stakeholders.
• Experience working across development, UAT and production environments.
• Exposure Management or catastrophe‑modelling experience.
• Experience supporting underwriting or insurance technology platforms.
• Understanding of portfolio modelling, pricing tools or risk aggregation.
• Experience with in the London Market insurance sector.
• Knowledge of platforms such as Moody’s Risk Link, Risk Modeler, Verisk Sequel Impact or similar insurance applications.
• Experience improving operational resilience and recoverability.
• Exposure to Python, Power Shell, Azure Data Factory or Azure SQL.
• Strong analytical and problem‑solving ability.
• High attention to detail and commitment to data quality.
• Proactive and comfortable taking ownership of technical issues.
• Able to manage competing priorities and deadlines.
• Strong stakeholder‑management and communication skills.
• Collaborative approach when working across technical and business teams.
• Automation and continuous‑improvement mindset.
• Resilient and adaptable within a changing technology environment