Data Warehouse Engineer, Secret Escapes
Luxury travel platform
Job no longer available
Luxury travel platform
501-1000 employees
Job no longer available
501-1000 employees
Company mission
Secret Escapes' mission is to enable every member to experience inspiring escapes.
Role
Who you are
- A passion for data, data modelling and data architecture
- Experience or at least familiarity some of these common modelling use-cases; sessionisation, identity stitching, financial modelling, regulatory compliance, attribution, cohorts, inventory etc
- Proficiency in writing performant, high quality, maintainable SQL code on large data sets
- Strong data exploratory skills to interrogate and interpret raw data to determine its structure
- Good understanding of the practical complexities of implementing deeply custom business logic rules, what can go wrong and preventative measures
- Meticulous attention to detail, careful validation of every join and intermediate table you create
- Experience working with modern BI/Visualisation tools (eg. Tableau, Looker, PowerBI)
- Pro-active with a self-starter mindset; able to identify elegant solutions to difficult problems and able to suggest new and creative approaches
- Analytical, problem-solving and an effective communicator; leveraging technology and subject matter expertise in the business to accelerate our roadmap
- Able to document business logic clearly, in plain English, in the code itself, making knowledge easily transferable to the wider team
- Patient and diligent when handling occasionally ambiguous requests
- Highly collaborative
- Curious and inquisitive
- Willing to step outside your comfort zone to broaden your skills and learn new technologies
- Able to clearly condense technical information and explain it to a less technical audience
What the job involves
- Unify disparate raw data sources into analytically-friendly tables to support deep dive analysis (trading performance drivers, customer behaviour, room availability etc.)
- Build and maintain complex business logic in SQL
- Help to design, implement, optimise, evolve, support and deploy new and existing data models to support use-cases across BI, analysis and data science
- Working with analysts to understand the business problems we are currently facing, the structures and relationships in our raw data, to translate the business logic into data models
- Ensuring best practices are used throughout development - particularly with regard to self-explanatory code, efficiency, maintainability and scalability
- Cross team functionally to integrate BI platforms onto our data warehouse, developing the schemas, aggregations and any data models sitting between the warehouse and business users
- Support and coach analysts on using SQL for data modelling and analysis
- Work with fellow data engineers to help productionise data processes
Salary benchmarks
Our take
Secret Escapes operates a “members-only” site with hand-picked hotel and holiday time-limited offers. Each week it runs short ‘flash sales’ with as many as 140 sales going on at any one time, providing access to boutique experiences even to those who couldn't normally afford them.
The difference with online travel agents like Booking.com, is that Secret Escapes inspires travel by communicating great travel deals, rather than existing as a place where people visit to book trips they already have in mind. In fact, the majority of people who book through Secret Escapes say that they weren’t even planning trips to those destinations before doing so.
Like many of its travel market companions, Secret Escapes was affected by the pandemic, but survived due to an injection of investment from previously secured backers. The company smartly used the onset of mass customer service requests to better its customer service channels, and it now seems set to pursue the success it was on-course to achieve before this major upset.
Kirsty
Company Specialist at Welcome to the Jungle
Insights
Company
Funding (last 2 of 6 rounds)
May 2020
$72.6m
SERIES E
Jul 2018
$68.7m
GROWTH EQUITY VC
Total funding: $290.5m
Company benefits
- 20% staff discount of all Secret Escape bookings
- Holiday parties and quarterly results celebrations
- 25 days holiday (excl. bank holidays)
- Work from home opportunities
Company HQ
Farringdon, London, UK
Leadership
Alex Saint
(CEO)Started his career in marketing at Unilever before founding a travel deals company in 2005 and then Secret Escapes in 2010.
Tom Valentine
(Marketplaces CEO)Studied Psychology at Oxford before starting his career at eBay in Strategy & Business Development.
Share this job