Submit your application

• Which location are you applying for?
  Select...LondonEdinburgh, United KingdomEngland, United Kingdom
• LinkedIn profile
  Loading

  Apply with Linkedin

  Profile added

  We'll share your profile. The job
  poster may use it for jobs with
  other companies. Learn more

• Resume/CV ✱
  ATTACH RESUME/CV

  Couldn't auto-read resume.

  Analyzing resume...

  Success!

  File exceeds the maximum upload size of 100MB. Please try a smaller size.

• Full name✱
• Email✱
• Phone ✱
• Current location
  No location found. Try entering a different location

  Loading
• Current company

Links

• LinkedIn URL
• Twitter URL
• GitHub URL
• Portfolio URL
• Other website
• behance URL

SQL experience

• What best describes your SQL level?✱
  Please selectNone (but eager to learn)Beginner (some experience from courses)Intermediate (confident running reports in a professional setting)Advanced (confident running reports, creating new tables and ingesting data etc.)Master (confident using advanced SQL to generate insights beyond reporting)
• What could be the output of this query: Select hotel_name, SUM(number_of_nights_reserved)/ COUNT(reservation_id) FROM 'hotel_bookings_table' WHERE country = 'ID' GROUP BY 1 ORDER BY 2 DESC LIMIT 10✱
  Please selectList of Hotels in Indonesia ordered by booking volumeTop 10 Hotels in Indonesia ordered by average lengths of stayNumber of Nights Booked at Hotels with "id" in their nameList of 10 Hotels in Indonesia ordered by sum of nights booked
• Bonus: What are two assumptions that you made to answer the question above?

SQL Experience (mandatory for the role)

• Do you have experience using SQL?✱
  • Yes
  • No
• What type of work experience have you had with SQL?✱

Immigration/Visa Status

• Are you legally eligible to work in the location listed within the job description? Select 'Yes' if you do NOT need visa sponsorship of any kind.✱
  • Yes
  • No

Hopper Questions

• What about your current and past work experience make you a great fit for our role?✱
• How will working here help you achieve your goals?✱

Sr Data analyst - Lodging - Timezones

• Despite our remote-work first nature, most of this team is located in EDT & EU timezones which means we will only consider candidates living in either: EDT/EST/CEST/GMT/BST/CEST/EEST. Can you please confirm?✱
  • Yes, I am physically located in one of these timezones
  • I unfortunately don't plan to be physically located in any of these timezones

• By applying for this position, your data will be processed as per Hopper Privacy Policy.