At a Glance
- Tasks: Own and manage the ETL pipeline for financial reporting and cloud transformation.
- Company: Respected Lloyd’s Market Insurer with a focus on innovation.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Join a dynamic team and take ownership of critical data processes.
- Why this job: Shape the future of data architecture while making a real impact in finance.
- Qualifications: Experience with ETL technologies, cloud platforms, and SQL Server.
The predicted salary is between 60000 - 80000 £ per year.
We are recruiting for a Senior Data Engineer on behalf of a well-respected Lloyd’s Market Insurer. 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.
Key Responsibilities
- 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.
- Collaborate with IT and business stakeholders to fix data issues, gather requirements and produce technical documentation.
- Establish CI/CD best practices using Azure DevOps.
Key Requirements
- 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.
Senior Data Engineer employer: Claims Recruitment Services
Claims Recruitment Services is an excellent employer, offering a vibrant work culture in Reigate that fosters collaboration and innovation. Employees benefit from continuous growth opportunities, competitive compensation, and the chance to work on cutting-edge data products within a supportive team environment, making it a rewarding place for those passionate about data and AI.
Contact Details:
Claims Recruitment Services Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at Lloyd’s Market Insurers. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a GitHub repository showcasing your ETL workflows and cloud projects. This gives potential employers a tangible look at what you can do, especially with Azure Data Factory and Databricks.
✨Tip Number 3
Ace the interview by preparing for technical questions! Brush up on T-SQL performance tuning and CI/CD best practices using Azure DevOps. We want you to feel confident and ready to impress!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace Senior Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Senior Data Engineer. Highlight your experience with ETL pipelines, cloud technologies, and any relevant projects that showcase your skills in financial data integrity.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're the perfect fit for this position. Share specific examples of how you've managed ETL workflows or contributed to cloud transformations in previous roles.
Showcase Your Technical Skills:Don’t forget to mention your hands-on experience with Azure Data Factory, Databricks, and T-SQL. We want to see how you’ve used these tools to solve real-world problems, so be specific!
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates!
How to prepare for a job interview at Claims Recruitment Services
✨Know Your ETL Inside Out
Make sure you can discuss your experience with ETL pipelines in detail. Be ready to explain how you've managed and monitored these processes, especially in relation to financial reporting. Highlight any specific tools you've used, like Azure Data Factory or Databricks, and be prepared to share examples of how you've improved workflows.
✨Showcase Your Cloud Knowledge
Since this role involves a significant cloud transformation, brush up on your knowledge of cloud platforms like Synapse Analytics and Snowflake. Be ready to discuss how you've leveraged these technologies in past projects, and think about how you would approach migrating legacy systems to a cloud-native environment.
✨T-SQL Performance Tuning is Key
Prepare to dive deep into T-SQL performance tuning. Have examples ready that demonstrate your ability to optimise queries and improve performance in both on-prem and cloud environments. This will show your technical prowess and your understanding of the importance of data integrity in financial reporting.
✨Collaboration is Crucial
This role requires working closely with IT and business stakeholders, so be ready to discuss your collaboration skills. Think of examples where you've gathered requirements, fixed data issues, or produced technical documentation. Emphasising your ability to communicate effectively with different teams will set you apart.
