Data Analyst

Houst; City Of London; Hybrid; GBP 40,000 - 45,000; Full time

Job summary

A leading host management service is seeking a Data Analyst to enhance reporting and dashboards. You'll work with SQL and BI tools in a hybrid model (3 days in office, 2 days remote). Ideal candidates will have strong SQL skills, experience with BI tools like Looker, and a proactive mindset. Comprehensively benefits include competitive salary, holiday entitlement, and wellness resources.

Benefits

25 days of paid holiday

Extra day off for your birthday

Pension plan

Employee discounts

Wellness resources

‘Pawternity’ leave for new pet parents

Qualifications

• Proven experience writing and optimising SQL queries.
• Experience with BI tools, ideally Looker.
• Experience with Python for ad-hoc analysis or data wrangling.

Responsibilities

• Build and maintain Looker dashboards for Finance and Operations.
• Write and optimise SQL queries in BigQuery.
• Collaborate with Pricing Analyst on property performance.

Skills

Solid SQL skills

Experience with BI tools

Experience with cloud-based data pipelines

Experience with Python

Strong attention to detail and accuracy

Clear communication skills

Proactive and curious mindset

Job description

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 BI tools, ideally Looker
• 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: Competitive salary, 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.