Sr. Staff Systems Engineer

Oakland, California, United States, AMER·Posted today

data-platformstypescriptpythonawsgcp

<div class="content-intro">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.</div>About Us Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data. Together, we’re delivering the data infrastructure layer that helps organizations move, transform, and trust their data — from the moment data moves, through every transformation, to the context teams and AI systems rely on. Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable, governed insights. Together, we support thousands of organizations as they build a trusted foundation for analytics, AI, and better business decisions. As we bring our teams and technology together, we’re building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. It’s an exciting time to join us: we’re creating a company with the scale, talent, and technology to help more organizations put their data to work with greater speed, confidence, and impact. During this transition period, you may see references to both Fivetran and dbt Labs throughout our recruiting process as we integrate our teams, systems, and career sites. About the Role  Fivetran + dbt Labs is building data pipelines to power the modern data stack for thousands of companies. We’re looking for a Senior Staff Systems Engineer, Data and Integrations to join our Systems Engineering team and set the technical direction for the data that runs Fivetran's business. In this role, you will own the data architecture behind our marketing, sales, billing, and product operations: the canonical data models, the contracts between systems, and the pipelines and transformations that move data reliably between them. You will lead our largest and most consequential data initiatives, such as system migrations, org consolidations, and re-platforming of core integrations, from design through validation and cutover. This position sits at the crossroads of data engineering, data modeling, and business process. You will partner closely with our Systems, Analytics, and Engineering teams, as well as Marketing, Revenue Operations, Accounting, Product Operations, and other business partner teams, and you will mentor the engineers who build within the standards you set. This is a full-time position based out of our Oakland, California office. Technologies You’ll Use   Our core systems are Salesforce, Netsuite, Coupa, Workday, and Zendesk, with BigQuery as our data warehouse. Our current integration stack includes Celigo and Fivetran itself.  You should be an expert in SQL and strong in a general purpose programming language such as Python or TypeScript, and comfortable evaluating and adopting new tools when necessary. A data engineering background is required, with expertise in data modeling, ETL/ELT development, data quality testing, and data validation at scale. Experience with dbt or a similar transformation framework, and with API-based and event-driven integration patterns, is preferred. Help us bring established data engineering practices to internal business systems, and define what those practices should be here. What You’ll Do Data Architecture and Standards <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Own the canonical data models for Fivetran's marketing, sales, billing, and product operations integrations, and define how business concepts map to data across our core systems.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Define team-wide standards for data modeling, data quality, testing, governance, and documentation, and drive their adoption across Systems Engineering and partner teams.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Contribute to the design of integration architecture, establishing guidance for when to use batch, real-time, and event-driven data movement.</li> </ul> Delivery of Complex Initiatives <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Lead the design and execution of our most complex data initiatives, including bulk migrations, system consolidations, and re-implementation of core integrations, from target-state design through validation, cutover, and stabilization.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Build, review, and ship the SQL and Python transformations and pipelines behind these initiatives, setting the bar for code quality on the team.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Design the validation and reconciliation approach for migrations and pipeline changes, and sign off with stakeholders that record counts, values, and business rules reconcile.</li> </ul> Reliability and Observability <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Design the monitoring, alerting, and data quality framework that gives end-to-end visibility into data freshness and accuracy across systems, and define the KPIs used to measure integration and data health.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Lead root cause analysis on the most complex cross-system data issues, and drive the systemic fixes that prevent recurrence.</li> </ul> Business Partnership Technical Leadership <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Translate ambiguous requirements from cross-functional business partners into data models and technical designs, and drive alignment across teams with competing priorities.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Serve as the technical lead and subject matter expert for business data within the Systems Engineering team.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Mentor other engineers and review their designs and code, raising the team's proficiency in data modeling, testing, and pipeline design.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Write and maintain design documents and data flow documentation for current and target state, so decisions are legible to the team and to partners.</li> </ul> Skills We’re Looking For <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">10+ years of experience in Data Engineering, Analytics Engineering, or a similar role, with a deep focus on modeling and transforming business data and a track record of technical leadership on complex, multi-team initiatives.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Expert SQL proficiency, including complex transformations, performance tuning, and large-scale data reconciliation.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Strong proficiency in a general purpose programming language such as Python or TypeScript, with experience building production-grade, tested data pipelines.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Hands-on experience with business systems data models such as those for Salesforce, NetSuite, Coupa, Workday, or Zendesk, including a data migration, org merge, or major re-implementation.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Demonstrated experience designing and delivering large-scale ETL/ELT solutions and the data quality, validation, and governance frameworks around them.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Ability to evaluate trade-offs between short-term delivery and long-term data architecture health, and to communicate those decisions clearly.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Ability to lead through influence, driving alignment across technical and non-technical stakeholders without direct authority.</li> </ul>   Bonus Skills <ul> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Experience with dbt or a similar transformation framework.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Hands-on experience with iPaaS platforms such as Celigo, Workato, or Boomi, and with reverse ETL tools, including experience choosing between them.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Experience with cloud platforms such as AWS or GCP, infrastructure as code, and CI/CD for data pipelines.</li> <li style="color: rgb(0, 0, 0) !important; font-family: helvetica, arial, sans-serif; font-size: 10pt;">Familiarity with AI/ML capabilities to augment data quality, matching, and automation.</li> </ul>   By stepping into this role, you will define how Fivetran's + dbt Labs business data is modeled, governed, and moved, and lead the initiatives that make it scale.   #LI-HYBRID #LI-VA1  <div class="content-pay-transparency"><div class="pay-input"><div class="description">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.</div><div class="title">Oakland Pay Range</div><div class="pay-range">$202,787—$253,483.50 USD</div></div></div><div class="content-conclusion">  Perks and Benefits <ul> <li>100% employer-paid medical insurance*</li> <li data-pm-slice="1 1 []">Generous paid time away from work, including paid vacation or flexible/unlimited vacation depending on role and country, plus paid sick time, inclusive parental leave, paid holidays, including a year-end Global Week of Rest, and volunteer days off.</li> <li>RSU stock grants*</li> <li>Professional development and training opportunities</li> <li>Company virtual happy hours, free food, and fun team-building activities</li> <li>Monthly cell phone stipend</li> <li>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.</li> </ul> *May vary by country and worker type - please reach out to your recruiter for more information Click <a href="https://drive.google.com/drive/folders/1CdawUwjo1Q1B7ghZJ_owdmmHB8VtqhBu?usp=sharing" target="_blank">here</a> to learn more about Fivetran's Benefits by Region. <hr> We’re honored to be <a class="c-link" href="https://fivetran.com/blog/hvr-acquisition-series-d" target="_blank" data-stringify-link="https://fivetran.com/blog/hvr-acquisition-series-d" data-sk="tooltip_parent">valued at over $5.6 billion</a>, but more importantly, we’re proud of our <a class="c-link" href="https://fivetran.com/culture" target="_blank" data-stringify-link="https://fivetran.com/culture" data-sk="tooltip_parent">core values of Get Stuck In, Do the Right Thing, and One Team, One Dream</a>. Read about us in <a class="c-link" href="https://fivetran-com.s3.amazonaws.com/news/forbes-aug-sept-2022-digital-reprint-10-21-22.pdf" target="_blank" data-stringify-link="https://fivetran-com.s3.amazonaws.com/news/forbes-aug-sept-2022-digital-reprint-10-21-22.pdf" data-sk="tooltip_parent">Forbes</a>.      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, <a href="https://www.youtube.com/watch?v=xlhtp4dGh8o" target="_blank">click here</a> and enjoy our video. To learn more about our candidate privacy policy, you can <a href="https://fivetran.com/candidate-privacy" target="_blank">read our statement here</a>. <hr> 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 <a href="https://forms.gle/V7k3t4u9j523XkEt6">form</a>. 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.</div>

Apply for this role