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 a Senior 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 , inc