Senior Staff Software Engineer- Transformations

AI overview

Contribute to building new features and improving the software architecture of Fivetran's data pipeline service while utilizing technologies like Python, SQL, and Kubernetes.

From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.

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

The compensation range displayed on this job posting reflects the minimum and maximum target for new hire compensation for the target position and level, and may include sales incentives or target bonuses depending on the role. Our compensation ranges are determined by role, level, and location. Our job titles may span more than one career level. Within the range, individual compensation is determined by additional factors, including job-related skills, experience, relevant education or training, business need, market demands. The compensation range is subject to change and may be modified in the future. Your recruiter can share more about the specific compensation range for your location during the hiring process.

Ontario Pay Range
$202,646.40$253,308 CAD

 

Perks and Benefits

  • 100% employer-paid medical insurance*
  • Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off
  • RSU stock grants*
  • Professional development and training opportunities
  • Company virtual happy hours, free food, and fun team-building activities
  • Monthly cell phone stipend
  • Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

*May vary by country and worker type - please reach out to your recruiter for more information

Click here to learn more about Fivetran's Benefits by Region.


We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.     

Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.

To learn more about Fivetran’s culture and what it’s like to be part of the team, click here and enjoy our video.

To learn more about our candidate privacy policy, you can read our statement here.


We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.

Perks & Benefits Extracted with AI

  • Equity Compensation: RSU stock grants
  • Health Insurance: 100% employer-paid medical insurance
  • Home Office Stipend: Monthly cell phone stipend
  • Learning Budget: Professional development and training opportunities
  • Social events and meals: Company virtual happy hours, free food, and fun team-building activities
  • Paid Time Off: Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off
  • Mental health support platform: Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

Fivetran is an Oakland, California-based technology company that develops a SaaS data integration service for companies to extract, load and transform data from different sources into data warehouses.

View all jobs
Salary
CAD $202,646 – CAD $253,308 per year
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Staff Software Engineer Q&A's
Report this job
Apply for this job