Resident Solution Architect

Fivetran • Philadelphia, PA

2d • Remote

About The Position

Fivetran is seeking an experienced Resident Solution Architect to join its Professional Services team and help dbt Platform Enterprise customers solve challenging data problems. Resident Solution Architects are billable to customers and support the mission of empowering data developers to create and share organizational knowledge. This is a full-time role based in the United States, focused on the MST, CST, and EST time zones, with approximately 10% travel for occasional customer visits, company retreats, and offsites.

The role involves delivering customer technical projects, including implementations, troubleshooting, establishing best practices, and designing MVPs and longer-term solutions for customer-specific needs. The Resident Solution Architect consults on architecture and design and helps strategic dbt Platform customers adopt the product. They work with internal customer-facing teams and provide feedback to product and engineering teams to improve the product and resolve engagement-specific issues.

The role uses dbt Platform and dbt Core, SQL, Jinja, Python, cloud data platforms such as Snowflake, Databricks, BigQuery, and Redshift, Git and GitHub, and data ingestion and integration tools including Fivetran. Other cloud and orchestration tools vary by customer engagement. The position is suited to someone experienced with enterprise customers, data platforms, dbt, and technical project delivery who communicates clearly and is comfortable working in a remote, collaborative organization.

Requirements

• Deep experience working with enterprise customers across a variety of use cases, ideally in a customer-facing post-sales, technical architect, or consulting role.
• Deep expertise in at least one data platform: Snowflake, Databricks, BigQuery, or Redshift.
• At least 2 years of experience with dbt, ideally including 1 year with dbt Platform.
• Proficiency writing SQL and some experience with Python.
• Interest in building technical skills that support deployment and integration of dbt Platform solutions.
• Customer-focused approach.
• Strong organization and comfort managing scope, timelines, and deliverables across multiple engagements.
• Clear, concise communication with internal and external stakeholders about complex technical, architectural, and organizational problems, including proposing thorough iterative solutions.
• Ability to thrive in a remote organization that values transparency and cross-collaboration.
• Willingness to travel approximately 10% for occasional customer visits, company retreats, and offsites.

Nice To Haves

• dbt Analytics Engineering Certification.
• Ability to advise on dbt Platform recommendations and build customer direction and consensus.
• Experience with traditional enterprise ETL tools such as Informatica, Datastage, or Talend.

Responsibilities

• Deliver technical customer projects, including implementation, configuration troubleshooting, best-practice guidance, MVP solutioning, and longer-term solutions for customer-specific requirements.
• Consult with customers on architecture and design.
• Help strategic dbt Platform customers adopt the product.
• Collaborate with internal customer-facing teams, including Sales, Solution Architects, Training, and Support.
• Provide feedback to product and engineering teams to help improve and prioritize customer requests and rapidly resolve engagement-specific issues.
• Develop expertise in dbt within the context of the modern data stack.
• Manage scope, timelines, and deliverables across multiple customer engagements.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed