Senior Staff Software Engineer- Transformations

About the Senior Staff Software Engineer Role

As a part of the Destinations Team, you will be responsible to help build new features of our data pipeline service, help improve our software architecture, and maintain reliable operation of the service. We're looking for someone who wants to learn and apply the key values that make our product great, dive deep into complex investigations into SQL compilers and execution engines. Fivetran is the epitome of data-driven-development — our engineering team is focused on building a world class product that:

• 
  

  Facilitates Data Analytics — join our mission to reliably deliver best-in class schemas, and clean data, designed to be intuitively useful to analysts.

  
  


• 
  

  Contributes to our Community — help develop tools like Data Lakes, SQL-based Transformations, and schema explorers to empower analysts to choose the best tools, and to make those tools more powerful.

  
  


• 
  

  Is Absolutely Dependable — work to make Fivetran the most reliable and secure component of our customers’ data infrastructure.

  
  

We emphasize using no-nonsense tools, and take great pride in the simplicity and effectiveness of the systems we build. Our back-end is built on Java, C, Postgres, and Kubernetes, and our front-end is built on React and Typescript.

This is a full-time, hybrid position based out of our Toronto office. Our hybrid work model offers a blend of remote flexibility and in-person collaboration, including two days in the office each week to connect and build as a team. Our hybrid work model offers a blend of remote flexibility and in-person collaboration, including two days in the office each week to connect and build as a team.

Technologies You’ll Use

• 
  

  Python, SQL, Java, Docker, AWS, GCP, BuildKite, C++, Grafana

  
  

What You’ll Do

• 
  

  Develop open source technologies like SQLGlot and Duckdb.

  
  


• 
  

  Research and implement new SQL optimization techniques.

  
  


• 
  

  Develop high performance C++ to process data.

  
  


• 
  

  Develop software designs and technical roadmap for the team.

  
  


• 
  

  Contribute to hiring by participating in the interview process.

  
  

Skills We’re Looking For

• 
  

  Code: 5 years programming in Python. Writes well-structured and performant code Be able to dive into code that has been previously written and suggest improvements

  
  


• 
  

  Troubleshoot: 2+ years of experience on-call or supporting customer with live production system Demonstrated ability to solve complex problems

  
  


• 
  

  Design: Understand and can explain how to build high performance systems and processes Have an analytical mindset that helps you identify design flaws in existing systems and come up with improvements

  
  


• 
  

  System:  2+ years of of working in a cloud environment utilizing AWS, GCP, Docker/Kubernetes, or similar technologies

  
  


• 
  

  Project management:  Experience working on requirements with product personnel refine requirements for technical projects. Experience breaking down requirements into engineering tasks

  
  


• 
  

  Collaboration: Experience working in large distributed teams Experience mentoring and growing junior engineers

  
  

Bonus Skills

• 
  

  Working experience with database internals such as storage format, compression techniques, encryption, disaster recovery, transaction management, or high availability.

  
  


• 
  

  Working experience in designing and developing file, event, application, or database connectors.

  
  


• 
  

  Working experience with advanced Java development such as multi-threads, multi-tasking, different asynchronous programming mechanisms, garbage collector tuning, etc.

  
  

#LI-Hybrid #LI-LW1