Senior Data Engineer in London

Senior Data Engineer in London

London Full-Time 72000 - 88000 £ / year (est.) Hybrid
Pacific Life Re

At a Glance

  • Tasks: Join our team to build and manage an enterprise data platform with innovative engineering practices.
  • Company: Pacific Life Re, a global leader in reinsurance with a focus on collaboration and innovation.
  • Benefits: Enjoy 25 days annual leave, comprehensive healthcare, and a supportive work-life balance.
  • Other info: Be part of a diverse team that values your unique contributions and supports your growth.
  • Why this job: Make a real impact in data transformation while working with cutting-edge technologies.
  • Qualifications: Experience in SQL development and cloud databases; strong problem-solving skills required.

The predicted salary is between 72000 - 88000 £ per year.

Following extensive global expansion over several years and a drive to standardise common systems and platforms globally, PL Re is undertaking a major back-office transformation programme and has established a Divisional Data Team to develop and manage an enterprise-wide data solution, reporting services and to embed best practice data governance. This team will support the business throughout its back-office transformation and will deliver significant improvement in efficiencies and the value derived from our data assets globally.

We are looking to appoint a Senior data engineer; to support the definition and delivery of an enterprise data platform with engineering best practices. Specifically, this role will help the divisional data team (DDT) to understand, manage, and prioritise data engineering and transformation activities. The role is reporting to the Data engineering manager, who is responsible for prioritising, planning, and development of the data engineering and transformation tasks required.

This role holder will build close working relationships with the DDT team and business units across our operating geographies and will be responsible for ensuring that technical requirements are clearly understood throughout the project lifecycle, and develop a data warehouse that empowers delivering reporting outputs that meet the needs of our internal customers. This is an exciting opportunity to join this new team. The Data transformation analyst would fill a critical role within the organisation tasked with analysis, design, implementation, testing, maintenance, and support for data-intensive pipelines. Also, would play an integral role in enhancing system quality, identifying issues, and transforming applications through innovation.

If you're a tech-savvy individual with a strong drive for creativity, excellence, and ambition, we want to hear from you!

Duties

  • Assist the data engineer manager with the delivery of data engineering activities.
  • Prepare technical design specifications based on functional requirements and analysis documents.
  • Implement, test, maintain, and support software, as outlined in technical design specifications.
  • Enhance system quality through identification of issues, common patterns, and formulation of standard operating procedures.
  • Identify and implement opportunities for system enhancements.
  • Working to support Business Control compliance through technology and responsible for ensuring IT Controls are incorporated into Systems.
  • Maintain and improve existing codebases and conduct peer code review changes.
  • Liaise with team members to implement technical designs.
  • Investigate and utilize new technologies as relevant.
  • Review functional requirements, analysis, and design documents to provide pertinent feedback.
  • Provide technical support to customers, solving problems and answering queries.
  • Mentor other development staff members and provide technical assistance as needed.
  • Participate in architecture and code reviews.
  • Support testing and validation activities within data related projects and initiatives.

Qualifications & Experience

  • Proven experience in the market as a SQL and PLSQL developer.
  • Extensive experience with any SQL cloud databases like Snowflake/Redshift/ BigQuery/Azure SQL database. Experience with any on-premise SQL database like MS SQL Server, Teradata etc.
  • Clear understanding of one ETL tool (For eg: Matillion, SNP Glue, Fivetran, Informatica).
  • Azure DevOps experience is a plus.
  • Clear understanding of data modeling, data curation, and orchestration.
  • Experience with Business Intelligence tools like PowerBI is a plus.
  • Sound understanding of unit testing, test-driven development, functional testing, and performance aspects.
  • Knowledge of at least one shell scripting language.
  • Ability to network with key contacts outside of own expertise.
  • Excellent interpersonal, organizational, presentation and facilitation skills.
  • Must demonstrate result-orientation and customer-focused mindset.
  • Strong organizational skills are required.
  • Excellent verbal and written communication skills enabling efficient interaction and collaboration with all stakeholders.
  • Knowledge of reinsurance or insurance industry concepts is a plus.

Technologies

  • DWH (On-premise or cloud – Snowflake preferable)
  • ETL
  • DBT

Nice to haves

  • Azure Devops
  • PowerBI/Tableau
  • SNP Glue/Matillion/FiveTran
  • SAP

Key Skills & Behaviours

  • Demonstrates an appropriate level of technical skills for the role and an appreciation of current issues affecting their profession and the life reinsurance industry.
  • Takes responsibility for the quality, completeness, and accuracy of own work and reporting issues in a timely manner to the manager.
  • Able to prioritise competing requests and deadlines.
  • Provides accurate and timely updates on status of work and escalates issues appropriately.
  • Committed to being an open and fair team member who shares information, knowledge, and experience openly.
  • Communicates in a clear and practical manner both verbally and in writing, without over-reliance on technical language.
  • Challenges status quo and is not limited by historical thinking or embedded practices, critically evaluates and challenges current work practices.
  • Embraces change and can work in a fluid environment with challenging deadlines: able to be flexible and resourceful.
  • Team player: ability to work with people with a diverse range of skills and experiences and get the best out of every individual.
  • Agile approach to projects; able to demonstrate the ability to think ahead and always focus on the end goal.

Working For Pacific Life Re

Every person in our global team is valued for the unique qualities they bring to our business and we seek to build their expertise and support their individual ambitions at every step. Of course, we take our work seriously and we know our team can operate under great pressure. We work hard and thrive on achievement, but we also know how to have fun and relax too. We regularly host a range of team building days to strengthen our team's connection with each other and reflect on their successes. Providing employees with a healthy work-life balance is very important to our culture. We have a wide range of employee benefits and we host regular social activities and well-being initiatives. We are also committed to supporting our employee's involvement in their communities, by actively fundraising, hosting charity events and overseeing volunteering opportunities.

Benefits (Only for Permanent and Fixed Term Employees)

  • 25 days of annual leave with option to buy/sell more days
  • Adoption and fertility leave
  • Generous enhanced parental leave
  • Comprehensive private insurance coverage for employee and dependents
  • Group Life Insurance coverage of 9x basic annual salary and Group Income Protection up to 75% of basic annual salary
  • Optical benefits
  • 15% combined employee/employer contributions
  • Subsidized gym membership
  • Access to Employee Assistance Program
  • Cycle to Work and Electric Car Salary Sacrifice Scheme
  • Time off for volunteering
  • Charitable matching of employee donations

You Can Be Who You Are

We are committed to a culture of diversity and inclusion that embraces the authenticity of all employees, partners and communities. We support all employees to thrive and achieve their fullest potential. As part of our commitment to diversity and inclusion, we will provide reasonable adjustments during the recruitment process to ensure equal access to applicants with disabilities. Please contact us about your needs so that we can discuss these with you to make sure that suitable adjustments are made, where possible.

Pacific Life Re Values

Please click here to view our company values.

Senior Data Engineer in London employer: Pacific Life Re

At Pacific Life Re, we pride ourselves on being an exceptional employer that values the unique contributions of each team member. Our vibrant work culture promotes a healthy work-life balance, with generous benefits including 25 days of annual leave, comprehensive healthcare coverage, and opportunities for community involvement through volunteering and charity events. As part of our commitment to employee growth, we offer mentorship and support for individual ambitions, making this an ideal environment for those looking to thrive in their careers while enjoying a collaborative and inclusive atmosphere.

Pacific Life Re

Contact Details:

Pacific Life Re Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Engineer in London

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Pacific Life Re!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Data Engineer at Pacific Life Re.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Pacific Life Re.

✨Apply Directly through Our Website

When you find a suitable opening like Senior Data Engineer at Pacific Life Re, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Senior Data Engineer in London

SQL
Problem-Solving Skills
Communication Skills
Python
Automation
Attention to Detail
Data Engineering

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Pacific Life Re, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Pacific Life Re. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Pacific Life Re

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Pacific Life Re!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.