Data Engineer, Professional Services

About the Company

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.

The Professional Services team at Fivetran is growing and you have the opportunity to join a function that is building from the ground up. The approaches, methodologies, working practices and team culture that we put in place now will be the template for what is to come, so if you are excited about having a hand in steering the approach of a critical function within the organization then this may be the role for you!

About the Role

Fivetran’s goal is to make access to data as simple and reliable as electricity; to this end, our Engineering team builds Connectors that can be used out-of-the-box for over 190 applications, removing the burden from our customers of having to write and maintain code. However, there will always be sources of data for which Fivetran does not provide a native Connector.

As a Data Engineer in the Professional Services team at Fivetran you will be responsible for developing custom functions that integrate with those sources, both from scratch and also using Fivetran’s code interpretation application. Along with that you will be responsible for implementing DBT transformation and replication setup using Fivetran stack.

Working directly with customer stakeholders, you will  define questions that our customers want answers to and use data to provide those answers. All sources of data are different, so your role will include analyzing source API documentation in order to understand what data can be retrieved from which endpoint, how objects relate to one another and using this information to construct Entity Relationship Diagrams for the data that customers require to generate insights and drive business decisions.

You will be comfortable with a scripting language, have developed proprietary data pipelines in the past and have worked extensively with 3rd-party REST APIs.

Whilst Fivetran will offer short-term maintenance for deployed code, our goal is not to maintain responsibility for the functions we develop. An essential part of the role of the Data Engineer will therefore be enabling customers to take responsibility for your code once it has been tested and is ready for deployment into a Production environment. To this end, you should feel  comfortable in producing enablement collateral and training teams to adopt code that isn't theirs.

Technologies You’ll Use

• Python
• AWS, GCP or Azure environments and services
• 3rd-party REST APIs
• git
• Fivetran
• DBT
• SQL, PL/SQL

What You’ll Do

• Work with customers to define analytics use-cases
• Analyze REST API documentation to inform development decisions
• Construct high-level Entity Relationship Diagrams to reflect customer data requirements & to reflect how your function will land that data
• Develop custom functions to ingest data from sources for which Fivetran does not provide a native Connector
• Ensure non-functional requirements are defined and that your delivered code meets those requirements
• Produce enablement and training collateral to ensure our customers can take responsibility for your code

Skills We’re Looking For

• Applied knowledge of Python in a data engineering context
• Experience with serverless computing (AWS Lambda, Google Cloud Functions or Azure Functions)
• Experience writing production code, as well as debugging and deciphering code written by others
• Experience with CI/CD tools, predominantly the git suite
• Strong prioritization and organizational skills
• Applied knowledge of DBT
• Applied Knowledge of SQL, PL/Sql

Nice-to-Haves

• Data modeling experience
• Database understanding 
• Replication understanding
• Cloud experience

Perks and Benefits:

• 100% paid Medical, Dental, Vision and Basic Life Insurance. Benefits begin on your first day!
• Option of Health Savings Account (HSA) or Flexible Savings Account (FSA)
• Generous paid time off (PTO) plus paid sick time, holidays, parental leave, and volunteer days off
• 401k match program
• Eligible donation match program
• Monthly cell phone stipend
• Home office setup reimbursement program for 100% remote employees
• Professional development and training opportunities
• Company virtual happy hours, free food, and fun team building activities
• Pet Insurance
• Commuter benefits to help with transit and parking costs
• Employee Assistance Program (EAP)
• Referral Bonuses
• RSU's - every employee is granted RSU's when they walk in the door
• Annual Camp Fivetran trip that brings together every employee from around the world

#LI-Remote