At a Glance
- Tasks: Build and maintain dashboards, analyse data, and support strategic decision-making.
- Company: Join Houst, the world's largest host management service, revolutionising property management.
- Benefits: Enjoy 25 days holiday, flexible work, and comprehensive benefits including wellness resources.
- Why this job: Dive into data analysis and make a real impact in a fast-paced environment.
- Qualifications: Solid SQL skills, experience with Looker, and a proactive mindset.
- Other info: Hybrid work model with a culture of innovation and continuous improvement.
The predicted salary is between 34000 - 48000 £ per year.
Salary: £40,000- £45,000
Employment type: Full-time, Monday- Friday 09:00- 18:00
Location: London (hybrid: 3 days office, 2 days WFH)
Please note: This role is open to applicants who already have the unrestricted right to work in the UK (40 hours per week) and are based within commuting distance of London. Unfortunately, we are unable to sponsor visas now or in the future.
About us: Houst is the world's largest host management service, helping homeowners unlock more value from their properties on Airbnb, Booking.com and beyond. We manage everything from marketing to guest communication, cleaning, and pricing optimisation, powered by technology and data.
The role: We're looking for a Data Analyst to join our team. You'll help build and maintain the reporting, dashboards and models that guide our global operations. This role is perfect for someone who enjoys working with SQL and BI tools, is eager to learn, and wants to grow their analytics career in a fast-moving environment.
Key responsibilities:
- Business Intelligence & Reporting
- Build and maintain Looker dashboards that support Finance, Operations, and Commercial teams
- Ensure the core data model is accurate, accessible, and easy to consume
- Create and maintain production assets that support long‐term BI strategy
- Train and support business users on Looker and data interpretation
- Monitor and support our modern data stack (Fivetran, BigQuery, Looker)
- Data Analysis
- Write and optimise SQL queries in BigQuery to turn raw data into clear, accurate models
- Analyse large datasets (e.g. property performance, occupancy, revenue, RevPAR)
- Support ad‐hoc analysis and business questions (A/B testing, churn, etc.)
- Provide insights that support cross‐functional teams, from operations to growth
- Partner with leadership to provide reports that drive strategic decision making
- Pricing & Revenue Support (secondary focus)
- Collaborate with the Pricing Analyst to monitor property performance and market trends
- Help identify opportunities to maximise revenue through data‐driven insights
- Provide competitor and market analysis to support pricing decisions
- Data Quality & Documentation
- Improve our data documentation and metric definitions
- Ensure consistent cleaning of datasets and improvements to the BI setup
- Spot opportunities to make reporting faster, easier, and more reliable
Solid SQL skills with proven experience writing and optimising queries
Experience with Looker (intermediate to advanced)
Experience with cloud‐based data pipelines (Fivetran, dbt or similar)
Experience with Python for ad‐hoc analysis or data wrangling
Strong attention to detail and accuracy when working with datasets
Clear communication skills, with the ability to explain data to non‐technical teams
Proactive and curious mindset, eager to learn and grow in a high‐impact role
Culture: Join a team that values innovation, autonomy, and continuous improvement, with regular team events and recognition for outstanding work.
Flexibility: Hybrid work model (3 days in office, 2 days remote) for work‐life balance.
Growth & Development: Access to career development resources, mentorship, and training to support your professional growth.
Comprehensive Benefits: 25 days of paid holiday (plus public holidays), an extra day off for your birthday, and a pension plan. Enjoy employee discounts, wellness resources, and "pawternity" leave for new pet parents.
Data Analyst in London employer: Houst
Contact Detail:
Houst Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst in London
✨Tip Number 1
Network like a pro! Reach out to current employees at Houst on LinkedIn or other platforms. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL skills and BI tools. Be ready to showcase how you've used data to drive decisions in past roles – real examples will make you stand out!
✨Tip Number 3
Show your enthusiasm for learning! Houst values a proactive mindset, so share your passion for data analysis and any new skills you're picking up. It’ll show you’re a great fit for their culture.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team.
We think you need these skills to ace Data Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst role. Highlight your SQL skills, experience with BI tools like Looker, and any relevant projects you've worked on. We want to see how your background aligns with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're excited about the role and how you can contribute to our team. Be sure to mention your proactive mindset and eagerness to learn – we love that!
Showcase Your Data Skills: In your application, don’t forget to showcase your data analysis skills. Mention specific examples of how you've used SQL or Looker to solve problems or provide insights. We’re all about data-driven decisions here at StudySmarter!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Houst
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with writing and optimising queries, as this is crucial for the Data Analyst role. Practise explaining your thought process when solving data problems, as they might ask you to walk through a query you've written.
✨Familiarise Yourself with Looker
Since Looker is a key tool for this position, take some time to explore its features and functionalities. If you can, create a sample dashboard or two to showcase your understanding. Being able to discuss how you've used Looker in past projects will definitely impress the interviewers.
✨Prepare for Data Analysis Scenarios
Think about real-world scenarios where you've analysed large datasets. Be ready to share specific examples of how your insights led to actionable outcomes. This could involve discussing A/B testing or revenue analysis, so have those stories at the forefront of your mind.
✨Show Your Curiosity and Proactivity
The company values a proactive and curious mindset, so be sure to convey your eagerness to learn and grow. Prepare questions that show your interest in their data processes and how you can contribute to improving them. This will demonstrate that you're not just looking for a job, but are genuinely interested in being part of their team.