Data Engineer - Protect (South)

Tesco Insurance; Reigate and Banstead; Hybrid; GBP 30,000 - 36,000; Full time

Benefits offered by this job

Pension up to 7.5%

Private Medical Insurance

Annual bonus

23.1 days holiday (7.2 weeks)

Discounts and perks

Learning opportunities

Job summary

Tesco Insurance is hiring a Data Engineer to join the Data & BI team. You will build and maintain data flows, data acquisition processes and well-structured data marts to drive business analysis.

You will report to Data Engineering Leads, manage end-to-end data requests, and ensure a single version of truth across the organisation while working in a hybrid model with two onsite days per week.

Qualifications

• Analyse and interpret data; advise on improvements.
• Strong communication with non-technical colleagues.
• Advanced Excel and data handling.
• Organise work to tight deadlines.
• Ensure data output is accurate for the business.

Responsibilities

• Produce accurate reports by collecting data from standard sources and formatting outputs.
• Contribute to SAS-based application development and data warehouse maintenance.
• Develop data pipelines and data models to support business analysis.
• Collaborate with Data & BI team to maintain a SAS/SQL data warehouse.
• Create and maintain data dictionaries and governance practices.
• Troubleshoot data issues and provide timely resolutions.
• Process BI requests from stakeholders with attention to data quality.

Skills

Data analysis

Communication

Excel

Organization

Attention to detail

Stakeholder management

Can-do attitude

Education

STEM degree preferred

Tools

SAS

SQL

Jira

Fabric

GitHub

Job description

Serving our customers, communities, and planet a little better every day.

Salary - Salary is from £33,040 + annual bonus & benefits

Work Level - 1

Location – Reigate or Edinburgh, Permanent

Office Attendance – Our hybrid working model gives you the best of both worlds - flexibility to work from home and valuable face-to-face time with colleagues. This role typically requires 2 days per week onsite.

Closing Date - Applications close on 30th September at 5pm

Why this role?

We’re looking for a Data Engineer to join our Insurance Money and Services team.

As a Data Engineer, you’ll build and maintain data flows and data acquisition processes to deliver well-structured, efficient, and performant data marts to drive business analysis and processes. Reporting to the Data Engineering Lead(s) for direction (in terms of priorities or technical support), you’ll support them through the delivery of projects and work within deadlines, prompt escalation of risks or issues and ensuring that day to day activities are delivered within SLAs. You’ll liaise with stakeholders at all levels of the organisation, delivering end to end data requests and ensuring single version of the truth across the organisation.

What you’ll be doing

• Data Collection and Analysis: Produce accurate reports for stakeholders by collecting data from a variety of standard sources and inputting it into standard formats. Identify and monitor associated Data & BI risks and report any business impact with recommended solutions to the Data Engineering Lead(s).
• Application Development: Contribute to development of existing and new SAS based applications by analysing and identifying areas for modification and improvement to meet customer requirements.
• Product/Service Development: Solve known problems and/or deliver defined outcomes by performing designated development/engineering activities using existing systems.
• Technical Developments Recommendation: Working with the Data & BI team to develop and maintain a comprehensive data warehouse using SAS/SQL language to ensure all data clearly defined and consistently maintained throughout the organisation.
• Data Governance: Develop and maintain data dictionaries covering factors and measures within data warehouses. Responsible for supporting all aspects of data such as Quality, Security, Management, Architecture, Availability and Performance.
• Troubleshooting and Debugging: Provide fault isolation and resolution to limit and address issues promptly.
• Project Management: Responsible for processing Data & BI requests for internal and external stakeholders in a timely manner whilst ensuring data accuracy and audits are not compromised. Liaising with internal stakeholders regularly to ensure assistance is given in understanding Data & BI for improving business performance or operations.

What we’re looking for (minimum criteria)

• Ability to analyse and interpret data with good investigative and analytical skills and make recommendations.
• Strong communication skills (both verbal and written) with non-technical internal colleagues.
• In-depth knowledge of Microsoft Office (particularly Excel).
• Proven organisation skills with the ability to work with tight deadlines.
• Able to demonstrate sound attention to detail, ensuring any output is accurate before being passed onto the wider business.
• Experience developing and maintaining strong working relationships.
• Demonstrate a ‘Can Do’ attitude with a desire to thrive in a dynamic and fast paced environment.

And if you have any of these, even better

• Some knowledge of SQL / SAS is preferred but not essential.
• Sound experience and understanding of established procedures or systems.
• Evidence of problem solving, investigative and analytical skills.
• Evidence of learning technical skills.
• Insurance or other financial services experience would be beneficial.
• Experience on SAS VIYA, Jira, Fabric, GitHub is good to have.
• STEM degree is preferred but not essential.

We welcome applications from everyone. If you’re excited about this role but your experience doesn’t align perfectly with every requirement, we’d still love to hear from you.

What’s in it for you

• A generous pension, with up to 7.5% employer contribution, depending on what you put in.
• Private Medical Insurance (WL2+) and virtual GP Service for you and your family
• Performance related annual bonus.
• 7.2 weeks holiday, with the opportunity to buy more.
• Colleague Clubcard discount (10-15% + second card to share with someone else).
• Enhanced parental leave.
• Opportunities to Save and Buy as you earn.
• A place to get on - take advantage of our ongoing learning opportunities to help you achieve the job and career you want.

Interviews

As a Disability Confident Employer (Level 2), we’re committed to creating an accessible and supportive environment for all. We offer reasonable adjustments throughout the recruitment process, including interviews, to ensure every candidate has a fair opportunity to succeed.

We also know the importance of balancing work with life’s other commitments. Please talk to us at interview about the flexibility you need, as we’re committed to exploring part time and flexible working opportunities, at every level of the organisation.

Interviews are expected to be held from w/c 5th October.

Don't miss out. We’re assessing applications throughout the recruitment process and may close this opportunity ahead of the closing date if we receive a high volume of applications.

Why Tesco Insurance and Money Services?

Seeing your impact all around you: there's no better feeling.

Lucky for us, we get to feel it all the time. Because whatever our role, we're helping our colleagues and serving our customers, communities and planet a little better every day.

We deal in the personal – from pet insurance for your best friend, and home insurance for peace of mind, to motor insurance for your dream car or travel money for that trip you’ve worked hard for.

Everything we do is about making things better. Not just for others, but for you too. It's why you'll get bags of choice and plenty of development. It's why you'll always be heard and find balance that works for you. It's why you'll feel totally at home in a place where everyone's welcome.

So, if you want a career where you can do good and feel good, you've found it.

Let's make everyday a little better.

Our story

Making Insurance and Money Services more rewarding and offering great value and choice - because we know little wins can make a big difference.

We began life in 1997 and now help more than 2 million customers protect what matters to them.

We want to deliver a helpful service in everything we do and to make life easier for our customers. Our policies are really easy to manage online for our customers, but we know that being able to speak to our customer service staff when you need to is really important. This is why our customer service centers are open seven days a week.

Delivering great customer service means having great people behind the scenes – people who understand our customers and are driven by doing the right thing for them. We offer colleagues a place where they can feel totally at home in a place where everyone's welcome, where they can be part of a great team focused on making a real difference for our customers.