Analytics Engineer

ABOUT US
Hostelworld Group, the global hostel-focussed online booking platform, inspires adventurous minds to meet the world and come back with life-changing stories to tell. Our customers are not your average tourists, they crave cultural connection and unique experiences that we make possible by providing an unbeatable selection of hostels in unmissable locations – all in the palm of their hand.

It is the social nature and community feel of hostels and their environment, that enable travellers to embrace journeys of discovery, adventure and meaning. We have more than 13 million reviews across 17,800 hostels in more than 179 countries, making the brand the leading online hub for social travel. The website operates in 19 different languages and our mobile app in 13 languages.

Founded in 1999 and headquartered in Dublin, Hostelworld has a growing, high-calibre team of 230 people within Technology, Product, Global Markets, HR, Finance & Legal and Marketing Teams across our Dublin, London, Porto, Shanghai and Sydney offices. Hostelworld is listed on the London Stock Exchange and Dublin Euronext. You can read more about our story here.

LOCATION
This role is based in Portugal. We have an office hub in Porto available for those who prefer a hybrid model where you can spend time with colleagues in-person. You will need to be able to commute to our office hub as required from time to time.

WHO YOU'LL WORK WITH
The Analytics and Insights team in Hostelworld comprises of 20+ people who provide insights across a number of growth units including paid marketing, customer analytics and app analytics to support decision making at C and senior management level.

As an Analytics Engineer within the Process and Tooling function of the A&I team, you will be in a position to lead the way for how data and analytics is used at HostelWorld. We are seeking a highly skilled and motivated Analytics Engineer with expertise in dbt, Python, and API integrations to join our data team. As an Analytics Engineer, you will play a crucial role in transforming raw data into a well-organized, scalable, and insightful data model that empowers our analytics and business intelligence efforts. You will work closely with data analysts, data scientists, and other stakeholders to ensure the delivery of high-quality, reliable data that drives decision-making across the organization.

WHAT YOU'LL DO

Data Tooling Team Contribution: Collaborate with the Data Tooling/Data Platform team to design and implement scalable and efficient data models, pipelines, and tools that empower our analytics and data science teams.

Data Modeling: Design, develop, and maintain robust and scalable data models using dbt to support analytical and reporting needs.

SQL & Python Development: Write and optimize SQL queries, and develop Python scripts to transform raw data into refined datasets and automate data processing tasks.

ETL/ELT Pipelines: Build and manage ETL/ELT processes using a combination of dbt and Python to ensure efficient data flow from various sources into our data warehouse.

API Integrations: Develop and maintain API connections to ingest data from various external sources, ensuring seamless integration into the data pipeline.

Data Science Support: Collaborate with data scientists to develop, deploy, and maintain data pipelines that support machine learning models and other advanced analytics initiatives.

Collaboration: Work closely with data analysts, data scientists, and business stakeholders to understand their data needs and deliver solutions that meet those needs.

Data Quality: Implement and monitor data quality checks within dbt and Python scripts to ensure the accuracy, consistency, and reliability of our data.

Documentation: Create and maintain comprehensive documentation of data models, transformation logic, Python scripts, and data lineage.

Performance Optimization: Continuously optimize the performance of data transformations and queries to improve the efficiency of our data processing workflows.

Best Practices: Advocate and implement best practices in data modeling, version control, and dbt usage to maintain a clean and efficient analytics environment.

Training & Support: Provide guidance and support to team members in the use of dbt, Python, SQL, and best practices for data science integrations.

WHAT WE'RE LOOKING FOR
Experience & Qualifications:

Strong proficiency in SQL, with a deep understanding of database design and data warehousing concepts.

Hands-on experience with Python for data processing, automation, and API integrations.

Bachelor's degree in Computer Science, Data Science, Engineering, Mathematics, or a related field. Relevant work experience will also be considered.

Knowledge & Skills:

Experience with cloud data warehouses such as Snowflake, BigQuery, or Redshift.

Familiarity with ETL/ELT tools and processes.

Experience with version control systems (e.g., Git)

Experience with Python or another scripting language.

Familiarity with Google Cloud.

Knowledge of data governance and data security best practices.

Strong problem-solving skills and attention to detail.

Excellent communication skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.

Ability to work independently and as part of a team in a fast-paced environment.

WHAT WE OFFER

Competitive salary & benefits

Enhanced annual leave plus 3 Wellbeing Days per year

Paid family leave (maternity, paternity, surrogacy & adoption)

Agile working (plus a Working from Abroad Policy!)

Support for your ongoing growth & development

Inclusive people policies (sickness, menopause, compassionate and fertility leave)

A chance to give back to your local community with 5 paid volunteering days

OUR BEHAVIOURS

Grow others - We fundamentally believe that investing in growing others benefits everyone, whether it's helping them develop hard or soft skills. We want learning and growing to be part of our DNA to help makes us a better team, together.

Master it - We are obsessed with our area of expertise and enjoy developing our skills. We rarely take things at face value; we investigate, interrogate, and always look for 'the why,' and wherever possible, we use data to find the best solution.

Collaborate - We are in it together, for the tough stuff and the celebrations too. To achieve the best results, we need expertise from all areas of the organisation, and we wholeheartedly welcome diverse thinking.

Adapt - We work fluidly, adapting to new information and the evolving environment while staying committed to our goals. Innovation and experimentation fuel our projects and we're never afraid to pivot.

Deliver - Our focus is always on the end result; we value outcomes over activity. We collaborate to deliver work at speed without dropping any of our other behaviours.

We believe in talented and diverse teams that reflect the diversity of our customers and the communities in which we operate. Everyone brings different perspectives and experiences. We lay out the above requirements to guide applicants to the experiences that we believe will allow you to be successful in the role. If you don't meet them all, please consider applying if you think you can still perform the role as described.

#J-18808-Ljbffr