Senior Data Engineer

About Tripadvisor

The Tripadvisor Group connects people to experiences worth sharing, and aims to be the world's most trusted source for travel and experiences. We leverage our brands, technology, and capabilities to connect our global audience with partners through rich content, travel guidance, and two-sided marketplaces for experiences, accommodations, restaurants, and other travel categories. The subsidiaries of Tripadvisor, Inc. (Nasdaq: TRIP), include a portfolio of travel brands and businesses, including Tripadvisor, Viator, and TheFork.

Tripadvisor, the world's largest travel site, operates at scale with over 500 million reviews, opinions, photos, and videos reaching over 390 million unique visitors each month. We are a data driven company that leverages our data to empower our decisions. Tripadvisor is extremely excited to play a pivotal role in supporting our travellers. With travel plans dashed in early 2020, many people have been dreaming about their next big holiday for more than a year, so it's no surprise that travellers are extra conscious of getting it just right when they do travel. Helping to play an important role in enabling travellers is an amazing opportunity over the next year and beyond.

Our data engineering team is lookig to hire aSenior Data Engineer in the UK. The new Senior Data Engineer will be focused on delivering Tripadvisor's first-in-class data products that serve all data users across the organization. As a member of the Data Platform Enterprise Services Team, you will collaborate with engineering and business stakeholders to build, optimize, maintain, and secure the full data vertical including tracking instrumentation, information architecture, ETL pipelines, and tooling that provide key analytics insights for business-critical decisions at the highest levels of Product, Finance, Sales, CRM, Marketing, Data Science, and more. All in a dynamic environment of continuously modernizing tech stack including highly scalable architecture, cloud-based infrastructure, and real-time responsiveness.

Tripadvisor provides a unique, global work environment that captures the speed, innovation and excitement of a startup, at a thriving, growing and well-established industry brand. We take pride in our data engineering and are looking for a talented and highly-motivated engineer with a passion for solving interesting problems to add to our high-performing team.

What You'll Do

• Providing the organization's data consumers high quality data sets by data curation, consolidation, and manipulation from a wide variety of large scale (terabyte and growing) sources.
• Building high quality data pipelines and ETL processes that interact with terabytes of data on leading platforms such as Snowflake and BigQuery.
• Developing and improving our enterprise data marts by creating efficient and scalable data models to be used across the organization.
• Partnering with our analytics, data science, crm, and machine learning teams for data solutions.
• Responsible for an enterprise data mart integrity, validation, and documentation.
• Responsible for the data pipelines' SLA and dependency management.
• Writing technical documentation for data solutions, and presenting at design reviews
• Solving data pipeline failure events and implementing sound anomaly detection
• Working with various teams from analytics to product owners and front end developers on tracking solutions and solving technical challenges
• Leading medium to large size projects in terms of writing technical specs and project planning
• Mentoring junior members of the team.

Skills & Experience

• BS or MS degree in Computer Science or a related technical discipline
• 6+ years of data engineering or general software development experience
• Experience working with large datasets (terabyte scale and growing) and familiarity with various technologies and tooling associated with databases and big data:
• Big Data (i.e. Hadoop, Hive, BigQuery, Snowflake)
• Relational DB (MS SQL, PostgreSQL/MySQL)
• Comprehensive data design and data modeling experience
• Solid experience developing complex ETL processes from concept to implementation; these should include defining SLA, performance measurements and monitoring.
• Advanced query language and data exploration skills, proven record of writing complex SQL queries across large datasets.
• Systems performance and optimization experience, with an eye for how systems architecture and design impacts performance and scalability
• Experience in functional programming in Python or in an equivalent language
• Strong software engineering principles
• Self-paced, organized, and detail-oriented person with a strong sense of ownership
• Strong communication skills to effectively communicate with both business and technical teams.
• Ability to work in a fast-paced and dynamic environment
• Proven record of technical leadership on planning and driving medium to large size projects and handling challenging deadlines.
• Strong interpersonal skills, intense curiosity, and an enthusiasm for solving difficult problems.
• Ability to break down complex problems into simple solutions.
• Ability to work with end users to solve technical challenges
• Comfortable owning the full data vertical and work autonomously
• Ability to mentor and support more junior members of the Team

Nice to have

• Exposure to and/or interest in machine learning and data science specifically to help solve day-to-day problems and reach objectives in an innovative way
• Experience working with task orchestration tools, Airflow or similar systems
• Comfortable working in a Linux CLI environment
• Experience in designing high-scale, fault-tolerant and performant distributed applications
• Experience in developing and managing real-time data pipelines
• Experience in programming languages such as Java or equivalent
• Experience with data governance.

What We Offer

• Competitive compensation packages, including base salary, annual bonus, and more.
• "Work your way" with flexibility to suit your lifestyle. We take a remote-friendly approach to collaboration, with the option to join on-site as often as you'd like in select locations.
• Flexible schedule. Work-life balance is ingrained in our culture by design. Trust and accountability make it work.
• Donation matching. Give back? Give more! We match qualifying charitable donations annually.
• Tuition assistance. Want to level up your career? We love to hear it! Receive annual support for qualified programs.
• Lifestyle benefit. An annual benefit to spend on yourself. Use it on travel, wellness, or whatever suits you.
• Travel perks. We believe that travel is employee development, so we provide discounts and more.
• Employee assistance program. We're here for you with resources and programs to help you through life's challenges.
• Health benefits. We offer great coverage and competitive premiums.
• Generous referral scheme. Help us grow and be rewarded with generous awards for referring successful candidates.

Our Cultural Pillars:

• Traveller first: We exist to create value for our customer, the traveler. We enable our suppliers and partners to unlock this value. Their collective behaviors and insights are what drives us.
• Execution is our edge: We act fast, experiment, learn from failure, iterate, and improve the solutions of tomorrow across every aspect of our business. Our execution is agile, data-driven, prioritised, and built to scale. We assume no problem is someone else's problem and finish what can be done today, knowing tomorrow will bring fresh challenges.
• We succeed together: The best outcomes are driven by empathic, humble, and diverse subject matter experts working toward shared goals. We collaborate relentlessly, challenge assumptions, give actionable feedback, and set each other up for success through empowered teams with a clear charter. We transparently take ownership of our growth, individually and as a team. We celebrate the quality of our effort, our learnings, and our collective achievements.

Discover more in our Tech Blog, for an inside look into some of our exciting and ground-breaking technical projects here at Tripadvisor Group.

Tripadvisor Group champions the unique identities, abilities, and experiences of all our people - employees, customers, and partners. This stems from our belief in the transformative power of travel, dining, and experiences to connect us and open doors to worlds very different from our own. Our ED&I strategy shapes how we approach our people, culture, business, and reputation. Tripadvisor Group strives to embed inclusion and belonging across all our brands.

We strive to create an accessible and inclusive experience for all candidates. If you need a reasonable accommodation during the application or the recruiting process, please make sure to reach out to your individual recruiter or our team at [email protected].

If you have any additional questions about careers at Tripadvisor you can email us at [email protected]. We have all the answers!