What will I be doing?
We are looking for an experienced senior data engineer to join our growing Data Team. You’ll be working on exciting projects to take the business to the next level with building out the data held within our data warehouse. You will be involved designing, building, testing and operating data transformations, working closely with colleagues within the product engineering team and other departments.
The Travel Chapter is a data led business and the work that you carry out will enable Travel Chapter to provide staff, clients and owners a great experience when using our systems.
Your next chapter
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!
Ideally, we’re looking for
1. Develop and maintain data pipelines and ETL processes to integrate and transform diverse data sources into a unified data model.
2. Design and implement data models and database schemas to store and manage large volumes of structured and unstructured data.
3. Collaborate with people across the business, including product managers developers, to define data requirements and understand data usage patterns.
4. Optimize data solutions by leveraging techniques such as partitioning, indexing, and caching.
5. Assist in troubleshooting production issues to resolution ensuring that measures are put in place where possible to stop reoccurrence.
6. Provide out of hours support as required in line with the organisation SLAs
7. Mentor and provide technical guidance to junior data developers and engineers.
8. Develop and maintain data quality assurance processes to verify the accuracy, completeness, and consistency of the data.
9. Stay updated with the latest industry
Knowledge, skills and experience required:
10. Minimum 5 years of working experience in data engineering.
11. An excellent understanding of databases and SQL.
12. Possess excellent written and oral communications skills.
Essential
Commercial experience of:
13. Data warehousing
14. Snowflake
15. Python, SQL
16. JSON, XML
17. MySQL
18. MSSQL Server
19. AWS Glue
20. Understanding of testing strategies
21. Understanding of Agile methodologies.
Desirable
22. Experience of ELT tools like Fivetran / Kleene / DBT
23. Experience using source code management tools (ideally git)
24. PHP
25. Experience with Salesforce Data Models
26. Experience in the travel industry
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:
These include:
27. 25 days’ paid holidays plus bank holidays
28. A special day off for your or a loved one’s birthday
29. £500 paid towards a holiday of your choice
30. A paid day to volunteer with a charity close to your heart
31. A friends and family discount scheme
32. Life assurance for your peace of mind
33. Social clubs for pet lovers, fitness enthusiasts, gardeners, sustainability champions, nutrition enthusiasts and more
34. Exciting social events, including our famous Christmas parties!