Senior Snowflake Data Engineer

The Travel Chapter Ltd; Northam; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A growing holiday property company in the UK is seeking a data developer to create and maintain data pipelines, design database models, and mentor junior staff. This role offers remote working flexibility with occasional office visits. The ideal candidate should have strong skills in data warehousing, experience with Snowflake, Python, SQL, and a passion for data quality.

Benefits

25 days paid holidays plus bank holidays

£500 towards a holiday

Paid day to volunteer

Friends and family discount scheme

Life assurance

Social clubs for various interests

Exciting social events including Christmas parties

Qualifications

• Experience or a passion for mentoring and offering technical guidance.
• Excellent written and oral communication skills.
• Understanding of testing strategies.
• Being self-assured enough to challenge a technique or decision.
• Understanding difficult conversations in a diplomatic way.
• Being a good judge of priorities and understanding the bigger picture.
• Being persistent advocating for quality deliverables.

Responsibilities

• Develop and maintain data pipelines and ETL processes.
• Design and implement data models and database schemas.
• Collaborate with product managers and developers on data requirements.
• Optimize data solutions using techniques like indexing and caching.
• Mentor junior data developers and engineers.
• Maintain data quality assurance processes.
• Troubleshoot production issues and prevent recurrence.
• Provide out-of-hours support per SLAs.
• Stay updated with industry trends and best practices.

Skills

Data warehousing

Recent Snowflake

Python

SQL

JSON

XML

MySQL

MSSQL Server

AWS Glue

Job description

Responsibilities

Employment type: Permanent

Work hours: Monday-Friday, 9 am-5.30 pm

Location: Remote working – on occasion, visiting our head office in Bideford

• Developing and maintaining data pipelines and ETL processes to integrate and transform diverse data sources into a unified data model.
• Designing and implementing data models and database schemas to store and manage large volumes of structured and unstructured data.
• Collaborating with people across the business, including product managers and developers, to define data requirements and understand data usage patterns.
• Optimising data solutions by leveraging techniques such as partitioning, indexing, and caching.
• Mentoring and providing technical guidance to junior data developers and engineers.
• Developing and maintaining data quality assurance processes to verify the accuracy, completeness, and consistency of the data.
• Assisting in troubleshooting production issues to resolution, ensuring measures are implemented to prevent recurrence.
• Providing out-of-hours support as required in line with organisational SLAs.
• Staying updated with the latest industry trends and best practices.

What we are looking for (Qualifications)

What are we looking for?

We know that the perfect candidate who ticks every box doesn’t exist, so if you’re excited by the role and can do most of the below, please get in touch - you could be exactly what we need!

• Data warehousing
• Recent Snowflake
• Python, SQL
• JSON, XML
• MySQL
• MSSQL Server
• AWS Glue

• Experience or a passion for mentoring and offering technical guidance

• Excellent written and oral communication skills.
• Understanding of testing strategies
• Being self-assured enough to challenge a technique or decision.
• Understanding and approaching difficult conversations in a diplomatic way.
• Being a good judge of priorities and understanding the bigger picture.
• Being persistent when advocating for quality deliverables, while accepting when compromises must be made.

What’s in it for you?

We believe in taking care of our team. As well as joining a rapidly growing company with a good culture and opportunities for employee development, we provide competitive salaries and a range of benefits, including:

• 25 days' paid holidays plus bank holidays
• A special day off for you or a loved one\'s birthday
• £500 paid towards a holiday of your choice
• A paid day to volunteer with a charity close to your heart
• A friends and family discount scheme
• Life assurance for your peace of mind
• Social clubs for pet lovers, fitness enthusiasts, gardeners, sustainability champions, nutrition enthusiasts and more
• Exciting social events, including our famous Christmas parties!

Who are we?

We’re Travel Chapter – the holiday home people – and we’re on a mission to showcase great places to stay in the UK. While we’ve grown over the years from a small South West holiday letting agency to one of the market leaders in the industry, we’ve never lost sight of our strong family ethos, and we keep the same values at the heart of everything we do. Along the way, we’ve nurtured a caring and collaborative culture that drives us forward and keeps our team inspired and motivated every day.

The people behind our company are at the heart of everything we do, and it’s a place where everyone is welcome; a place that’s friendly and fair; a place that encourages people to be bold, explore new ideas and push the boundaries of what they do every single day. We are passionate about what we do and we take a common-sense approach to getting things done. Inevitably, things go wrong from time to time and we do everything we can to make it right. We learn from it and adapt, remembering to stay curious and never stop evolving.

Diversity is key to our success, and we work hard to make sure we’re inclusive. Please let us know if you need any adjustments made to the application or selection process so you can do your best - we’ll be happy to help.