Senior Data Engineer

Tripadvisor•Ottawa, ON

1d•Hybrid

About The Position

Tripadvisor is seeking a Senior Data Engineer to join their Data Platform Enterprise Services Team in the UK. This role focuses on delivering high-quality data products that serve all data users across the organization. The engineer will collaborate with stakeholders to build, optimize, maintain, and secure the data vertical, including tracking instrumentation, information architecture, ETL pipelines, and tooling. The position involves working with a modern, cloud-based tech stack and a highly scalable architecture, contributing to critical business decisions across Product, Finance, Sales, CRM, Marketing, and Data Science. Tripadvisor offers a dynamic work environment that combines the excitement of a startup with the stability of an established brand, emphasizing data engineering and problem-solving.

Requirements

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 Haves

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.

Responsibilities

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.

Benefits

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.