Senior Data Engineer

Tripadvisor

$100K — $130K *
US-AnywhereRemote in Ottawa, ON
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • BS or MS in Computer Science or related field
  • 6+ years of data engineering or software development experience
  • Experience with large datasets (terabyte scale) and relevant technologies
  • Proficient in data modeling and ETL process development
  • Strong SQL skills for data exploration across large datasets
  • Experience in functional programming, preferably Python
  • Ability to manage projects, mentoring junior team members, and leading technical specifications.

Responsibilities

  • Provide high-quality data sets through data curation, consolidation, and manipulation
  • Build robust data pipelines and ETL processes interacting with terabyte-scale data
  • Develop and enhance enterprise data marts using efficient data models
  • Collaborate with analytics, data science, and CRM teams to deliver data solutions
  • Maintain integrity and documentation of enterprise data marts
  • Ensure SLAs and manage dependencies for data pipelines
  • Write technical documentation and present at design reviews

Benefits

  • Remote-friendly work culture with flexibility
  • Flexible scheduling to support work-life balance
  • Annual charity donation matching
  • Tuition assistance for career development
  • Lifestyle benefit for wellness or travel expenses
  • Travel discounts as part of employee development
  • Employee assistance programs for personal support
  • Comprehensive health coverage and competitive premiums
  • Generous referral rewards for successful candidate recommendations
Full Job Description


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, 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.

Similar Jobs

More Jobs at Tripadvisor

More Information Technology Jobs

Find similar Senior Data Engineer jobs: