Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop data solutions to optimise business insights and reporting.
- Company: Join a forward-thinking tech team in the insurance industry.
- Benefits: Full-time role with competitive salary and opportunities for growth.
- Why this job: Be at the forefront of data innovation and make a real impact.
- Qualifications: Experience in data engineering, T-SQL, Python, and cloud technologies.
- Other info: Collaborative environment with a focus on professional development.
The predicted salary is between 28800 - 48000 £ per year.
Our client is seeking a Data Engineer to join their growing Technology, Data and Innovation team. This is an exciting opportunity to play a key role in developing and optimising the organisation’s use of data and technology, particularly in building a modern data analytics and reporting architecture capable of supporting a wide range of business needs.
As a Data Engineer, you’ll be responsible for designing, developing, and maintaining data solutions that enable accurate insight and reporting. You’ll work with modern data tools and cloud technologies, helping to drive innovation and efficiency across the business.
What you’ll be doing:
- Designing and developing the data architecture, tools, and processes to meet evolving business and technical requirements.
- Assisting in the design and build of the data warehouse, integrating data from multiple internal and external sources.
- Managing complex data workflows including source-to-target mappings, data transformations, reconciliation, and error handling.
- Creating and optimising data models (physical and logical) to support analytics and business intelligence.
- Delivering high-quality data solutions for data quality, mapping, metadata management, migration, and reporting.
- Supporting and maintaining existing data platforms and applications.
- Contributing to the development of data standards, procedures, and best practices.
- Participating in the evaluation and selection of new data solutions and technologies.
- Collaborating with senior team members and providing support or cover for other developers when required.
What we’re looking for:
- Proven experience in data engineering within a complex enterprise environment.
- Strong proficiency in Advanced T‑SQL and data warehouse modelling.
- Skilled in Python scripting.
- Hands‑on experience with Azure Data Factory and Airflow.
- Familiarity with Snowflake is highly desirable.
- Strong problem‑solving and analytical skills, with the ability to manage and interpret complex data sets.
- Excellent communication skills and the ability to work effectively with technical and business stakeholders.
Seniority level: Mid‑Senior level
Employment type: Full‑time
Job function: Information Technology
Industries: Insurance
Data Engineer in City of London employer: Pavilion Recruitment Solutions
Contact Detail:
Pavilion Recruitment Solutions Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in City of London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with fellow data enthusiasts. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data projects, whether it's a GitHub repo or a personal website. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical skills and common data engineering questions. Practice explaining your past projects and how you've tackled challenges—this will help you shine during those crucial conversations.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find roles that match your skills and interests. Plus, it shows you're genuinely interested in joining our team!
We think you need these skills to ace Data Engineer in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with data architecture, T-SQL, and any relevant tools like Azure Data Factory. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our Technology, Data and Innovation team. Keep it engaging and relevant to the job description.
Showcase Your Projects: If you've worked on any cool data projects, make sure to mention them! Whether it's building data models or optimising workflows, we love to see real examples of your work that demonstrate your skills and problem-solving abilities.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows you're keen on joining our team!
How to prepare for a job interview at Pavilion Recruitment Solutions
✨Know Your Data Tools
Make sure you brush up on your knowledge of Advanced T-SQL, Python, and any relevant tools like Azure Data Factory and Airflow. Be ready to discuss how you've used these technologies in past projects, as this will show your practical experience and understanding of the role.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled complex data challenges in previous roles. Think about situations where you had to manage data transformations or reconcile data discrepancies, and be ready to explain your thought process and the outcomes.
✨Understand the Business Needs
Familiarise yourself with the company’s industry and how they use data to drive decisions. This will help you align your answers with their business objectives and demonstrate that you can contribute to their data strategy effectively.
✨Communicate Clearly
Since you'll be working with both technical and business stakeholders, practice explaining complex data concepts in simple terms. Good communication is key, so think about how you can convey your ideas clearly and concisely during the interview.
