How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Engineer - Exposure Management
Location: London / Hybrid
Engagement Type: Permanent
Company: Albany Beck
Client Industry: London Market Insurance
About Albany Beck
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.
Role Overview
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.
Key Responsibilities
- 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Required Experience
- 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 DevOps or Git for source control and release management.
- Understanding of Agile, DevOps, 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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable Experience
- Exposure Management or catastrophe-modelling experience.
- Experience supporting underwriting or insurance technology platforms.
- Understanding of portfolio modelling, pricing tools or risk aggregation.
- Experience within the London Market insurance sector.
- Knowledge of platforms such as Moody’s RiskLink, Risk Modeler, Verisk Sequel Impact or similar insurance applications.
- Experience improving operational resilience and recoverability.
- Exposure to Python, PowerShell, Azure Data Factory or Azure SQL.
Professional Competencies
- 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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location