10 hours ago
Base Salary
$203k - $253k/yr
Responsibilities
- Own canonical data models and define how business concepts map across marketing, sales, billing, and product operations systems.
- Define and drive adoption of standards for data modeling, quality, testing, governance, and documentation.
- Lead complex migrations, system consolidations, and core integration re-implementations through design, validation, cutover, and stabilization.
- Build, review, and ship SQL and Python transformations and production data pipelines.
- Design validation, reconciliation, monitoring, alerting, and data quality frameworks for integration health, freshness, and accuracy.
- Lead root cause analysis and systemic remediation of complex cross-system data issues.
- Translate business requirements into data models and technical designs while aligning technical and non-technical stakeholders.
- Serve as a technical lead, review designs and code, and mentor engineers.
- Maintain design documents and current- and target-state data flow documentation.
Requirements
- 10+ years of experience in Data Engineering, Analytics Engineering, or a similar role, with deep business data modeling and transformation experience.
- Expert SQL proficiency, including complex transformations, performance tuning, and large-scale reconciliation.
- Strong proficiency in Python or TypeScript and experience building production-grade, tested data pipelines.
- Hands-on experience with Salesforce, NetSuite, Coupa, Workday, or Zendesk data models, including a migration, organizational merge, or major re-implementation.
- Experience designing and delivering large-scale ETL/ELT solutions and related data quality, validation, and governance frameworks.
- Ability to evaluate short-term delivery versus long-term architecture trade-offs and communicate decisions clearly.
- Ability to lead through influence across technical and non-technical stakeholders without direct authority.
- Preferred experience with dbt or a similar transformation framework.
- Preferred experience with iPaaS platforms such as Celigo, Workato, or Boomi and reverse ETL tools.
- Preferred experience with AWS or GCP, infrastructure as code, and CI/CD for data pipelines.
- Familiarity with AI/ML capabilities for data quality, matching, and automation.
Benefits
- Full-time position based in the Oakland, California office with hybrid work indicated.
- 100% employer-paid medical insurance, subject to country and worker type.
- Paid vacation or flexible/unlimited vacation depending on role and country, paid sick time, inclusive parental leave, paid holidays, a year-end Global Week of Rest, and volunteer days off.
- RSU stock grants.
- Professional development and training opportunities.
- Company virtual happy hours, free food, and team-building activities.
- Monthly cell phone stipend.
- Mental health support platform offering therapy, coaching, and self-guided mindfulness resources for employees and covered dependents.
Tech Stack
Categories
Data Engineering
About Fivetran
Fivetran builds a managed data integration platform that extracts data from hundreds of SaaS apps and databases and loads it into cloud data warehouses for analytics and AI teams. Sold as a subscription SaaS service, it provides prebuilt connectors, automated schema management, and ELT/replication to destinations like Snowflake, BigQuery, Databricks, and Redshift. Founded in 2012 and headquartered in Oakland, it serves customers such as Autodesk, Condé Nast, JetBlue, and Morgan Stanley.