Senior Staff Software Engineer Transformations

Fivetran; Toronto; Hybrid; CAD 202,000 - 254,000; Full time

Job summary

A leading data integration company in Toronto is seeking a Senior Staff Software Engineer for a hybrid position. The role involves enhancing data pipeline services, optimizing SQL compilers, and maintaining reliable operations. Ideal candidates have extensive experience in Python and troubleshooting production systems. The position offers competitive compensation based on skills and experience, alongside comprehensive benefits including medical insurance and generous paid time off.

Benefits

100% employer-paid medical insurance

Generous paid time-off policy

RSU stock grants

Professional development opportunities

Company virtual happy hours

Monthly cell phone stipend

Access to mental health support platform

Qualifications

• 5 years of programming experience in Python, writing performant code.
• 2+ years of experience in supporting customers with production systems.
• Understanding of high performance system design.

Responsibilities

• Develop open source technologies like SQLGlot and DuckDB.
• Implement new SQL optimization techniques.
• Create high performance C++ data processing systems.

Skills

Python programming

Troubleshooting in live production systems

System design for high performance

Cloud environment experience (AWS, GCP)

Project management

Collaboration and mentorship skills

Tools

Docker

Kubernetes

C++

SQL

Java

Job description

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.

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

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.

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