# Resident Solution Architect **Company:** [Fivetran](https://zerogtalent.com/ai-companies/fivetran) **Location:** Philadelphia (dbt) **Work mode:** Remote **Employment type:** Full Time **Salary:** USD 168K–190K/yr **Category:** Software **Department:** Other **Listed:** 2026-11-05 [View and apply on Zero G Talent](https://zerogtalent.com/ai-jobs/fivetran/resident-solution-architect-8196171003) ## What you'll do - Lead implementation and troubleshooting for customer technical projects - Consult on data architecture and design for dbt platform - Collaborate with sales, support, and solution architecture teams - Provide product feedback to improve dbt platform and resolve issues - Become a product expert in dbt and the modern data stack ## What you need - 2+ yrs dbt experience, ideally 1 yr dbt platform - Deep expertise in Snowflake, Databricks, BigQuery, or Redshift - Proficient in SQL with some Python experience - Customer-facing post-sales, technical architect, or consulting experience - Comfort managing scope, timelines, and deliverables across engagements ## Job description 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 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 is building data pipelines to power the modern data stack for thousands of companies. We’re seeking an experienced Resident Solution Architect with a passion for solving challenging problems with dbt to join our Professional Services team. RSAs are billable to dbt Platform Enterprise customers and help achieve our mission to empower data developers to create and disseminate organizational knowledge. This is a full-time position based in the United States, with a focus on MST, CST, and EST timezones. **Technologies You’ll Use** - **dbt Platform and dbt Core** for data modeling, testing, documentation, development workflows, and jobs - **SQL and Jinja** for building and maintaining data transformations; **Python** for scripting and integrations as needed - **Cloud data platforms**, such as Snowflake, Databricks, BigQuery, or Redshift - **Git and GitHub**, including branching, pull requests, and **CI/CD** workflows - **Data ingestion and integration tools**, including Fivetran, plus APIs and connectors - **Cloud and orchestration tools** used in customer environments; the specific tools will vary by engagement **What You’ll Do** - Work on a variety of impactful customer technical projects — inclusive of implementation, troubleshooting configurations, instilling best practices, and solutioning MVPs and long term solutions to customer specific requirements - Consult on architecture and design - Ensure our most strategic dbt platform customers are adopting the product - Collaborate with other internal customer facing teams at dbt Labs - Sales, Solution Architects, Training, Support - Provide critical feedback to dbt Labs product and engineering teams to improve and prioritize customer requests and ensure rapid resolution for engagement specific issues - Become a product expert with dbt in the context of the modern data stack (if you aren't already) **You are a good fit if:** - You have deep experience working with enterprise customers across a variety of use cases, ideally in a customer-facing post-sales, technical architect, or consulting role - You have deep expertise in at least one data platform (Snowflake, Databricks, BigQuery, Redshift) - You have at least 2 years of experience with dbt, ideally including 1 year with dbt platform - You are proficient in writing SQL and have some python experience - You look forward to building skills in technical areas that support deployment and integration of dbt platform solutions to complete customer projects - You are customer focused - embracing one of our core values that users are our best advocates - You are highly organized. Comfort with technical project delivery - managing scope, timelines, and deliverables - this role will be staffed on multiple engagements at once - You communicate clearly and concisely with internal and external stakeholders - demonstrating a capacity to clearly and concisely communicate about complex technical, architectural, and/or organizational problems and propose thorough iterative solutions - You thrive in a remote organization that highly values transparency and cross-collaboration - ~10% travel should be expected (occasional customer visits, company retreat and offsites) **Bonus Skills**​ - You have obtained the [dbt Analytics Engineering Certification](https://www.getdbt.com/certifications/analytics-engineer-certification-exam/) - You have the ability to advise on dbt Platform recommendations, and build direction/consensus with the customer to move forward - Experience with traditional Enterprise ETL tooling (Informatica, Datastage, Talend) #LI-REMOTE 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. Pay Range $167,983—$190,000 USD **Perks and Benefits** - 100% employer-paid medical insurance**\*** - 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. - RSU stock grants\* - Professional development and training opportunities - Company virtual happy hours, free food, and fun team-building activities - Monthly cell phone stipend - 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. _**\***May vary by country and worker type - please reach out to your recruiter for more information_ _Click [here](https://drive.google.com/drive/folders/1CdawUwjo1Q1B7ghZJ_owdmmHB8VtqhBu?usp=sharing) to learn more about Fivetran's Benefits by Region._ * * * We’re honored to be [valued at over $5.6 billion](https://fivetran.com/blog/hvr-acquisition-series-d), but more importantly, we’re proud of our [core values of Get Stuck In, Do the Right Thing, and One Team, One Dream](https://fivetran.com/culture). Read about us in [Forbes](https://fivetran-com.s3.amazonaws.com/news/forbes-aug-sept-2022-digital-reprint-10-21-22.pdf).      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, [click here](https://www.youtube.com/watch?v=xlhtp4dGh8o) and enjoy our video. To learn more about our candidate privacy policy, you can [read our statement here](https://fivetran.com/candidate-privacy). * * * _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 [form](https://forms.gle/V7k3t4u9j523XkEt6). 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._ ## Other open roles at Fivetran - [Global Head of Deal Strategy and Operations](https://zerogtalent.com/ai-jobs/fivetran/global-head-of-deal-strategy-and-operations-8197321003) — Austin (dbt) - [Global Head of Deal Strategy and Operations](https://zerogtalent.com/ai-jobs/fivetran/global-head-of-deal-strategy-and-operations-8196773003) — Oakland, California, United States, AMER - [Global Head of Deal Strategy and Operations](https://zerogtalent.com/ai-jobs/fivetran/global-head-of-deal-strategy-and-operations-8197319003) — New York (dbt) - [Global Head of Deal Strategy and Operations](https://zerogtalent.com/ai-jobs/fivetran/global-head-of-deal-strategy-and-operations-8197314003) — Denver, Colorado, United States, AMER - [Manager, Sales Engineering Specialists](https://zerogtalent.com/ai-jobs/fivetran/manager-sales-engineering-specialists-8048527003) — Remote, California, United States, AMER --- *Source: [Zero G Talent](https://zerogtalent.com), the job board for space, defense, AI, robotics and frontier-tech companies.*