Principal Solution Architect

About this role

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 Role
The Professional Services team at Fivetran is growing and you can 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!
As a Principal Solution Architect at Fivetran Professional Services, you will play a pivotal role in guiding our most strategic, complex, and high-impact customer engagements across the modern data ecosystem — with a strong focus on Data Lakes, Transformations, and extended Modern Data Architectures.
You will serve as a technical thought leader and trusted advisor, shaping our customers’ data integration and AI journeys, while also mentoring fellow architects and influencing Fivetran’s product and delivery evolution.
You will lead by example — defining architectural standards, developing reusable frameworks, and ensuring delivery excellence across engagements. As a trusted partner to Fortune 500 and high-growth customers, you’ll work directly with executive and technical stakeholders to architect secure, scalable, and high-performance data integration frameworks that drive time-to-value and business outcomes.
You’ll collaborate closely with Sales, Product, Engineering, Support, and Customer Success to influence roadmap direction, drive innovation, and enable field and customer teams through scalable technical enablement programs.
This is a full-time position based remotely in the US.
Technologies You’ll Use

•

Fivetran Data Integration Products:

• Including SaaS Connectors, HVR, and Customer-Managed (formerly “Hybrid Deployment”) options

•
Databases (Source Target Systems):

• Relational and enterprise systems: Oracle, SAP HANA, Microsoft SQL Server, IBM Db2, MySQL, PostgreSQL

•
Cloud Data Warehouses Lakehouses:

• Snowflake, BigQuery, Amazon Redshift, Databricks

•
Cloud Object Storage Data Lakes:

• Amazon S3, Azure Data Lake Storage (ADLS), Google Cloud Storage (GCS)

• Modern open table formats: Apache Iceberg, Delta Lake

•
Cloud Platforms Infrastructure:

• Amazon Web Services (AWS), Google Cloud Platform (GCP), Microsoft Azure

•
Operating Systems:

• Linux and Unix-based systems, Windows Server environments

•
Containerization Orchestration:

• Docker, Podman, Kubernetes, Helm

•
Modern Data Transformation, Orchestration, and Activation:

• dbt, SQLMesh, Apache Airflow, Prefect, Census

•
Developer, Scripting Infrastructure Tools:

• Git, REST APIs, Python, Bash, PowerShell

• Infrastructure as Code: Terraform

• CI/CD tooling experience is a plus

•
Security, Secrets Governance (Optional but Valued):

• Vault, AWS KMS, and enterprise IAM integrations (optional, relevant for sensitive deployments)

What You’ll Do
As a key leader of our customer-facing team, you’ll be directly leading the customer implementation journey successfully and optimize Fivetran products across various data environments. Your responsibilities will include:

• Lead Enterprise Architectures: Design and deliver complex, enterprise-grade data integration and transformation architectures across cloud, hybrid, and on-prem environments.

• Drive Customer Success: Partner with senior customer stakeholders to define business objectives, translate them into scalable technical designs, and drive measurable business value.

• Scale the Field: Develop and maintain reference architectures, delivery frameworks, and internal training assets that uplift the PS organization and enable efficient scaling.

• Mentor Guide: Serve as a mentor and coach to architects and consultants, uplifting team skills in advanced data replication, hybrid deployments, and lakehouse integrations.

• Engage Cross-Functionally: Partner with Product and Engineering to influence roadmap decisions, and guide enterprise customers through the rollout of new features and deployment models.

• Thought Leadership: Represent Fivetran in customer workshops, partner discussions, and executive briefings — contributing to our industry presence as a strategic advisor.

• Innovation AI Readiness: Lead engagements that help customers prepare for AI workloads (LLMs, ML pipelines), advising on best practices for data quality, lineage, and compliance.

• Customer Enablement: Produce enablement assets and lead sessions that help customers adopt new architectures confidently — ensuring long-term success and self-sufficiency.

Skills We’re Looking For

• 12+ years of progressive experience in enterprise data architecture, solution engineering, or consulting leadership, with specialization in modern data integration platforms, data lakes, transformation pipelines, and large-scale implementation programs.

• Deep technical fluency with the modern data stack, including data ingestion tools, cloud data warehouses (Snowflake, BigQuery, Redshift), orchestration tools (Airflow, dbt, SQLMesh, Prefect), and observability or metadata catalog solutions.

• Demonstrated expertise in enterprise replication from transactional databases (e.g., Oracle, SQL Server, DB2, SAP) into analytical or data lake platforms — with experience designing and tuning log-based replication, schema mapping, and network/security controls within customer-managed environments.

• Practical implementation experience with open table formats like Delta Lake or Apache Iceberg, including schema evolution, time travel, compaction strategies, file pruning, and optimization for cost-effective, high-performance analytics.

•…