Resident Solution Architect
fivetran
USA - Philadelphia (dbt)
Systems Analyst
Job Score
80 pts
On-site model (+70)
Systems Analyst (+10)
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
- 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 to learn more about Fivetran's Benefits by Region.
We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.
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 and enjoy our video.
To learn more about our candidate privacy policy, you can read our statement here.
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. 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.
What did you think of this job?
Loading comments...
About Systems Analyst
The Systems Analyst is the professional responsible for analyzing, designing, and implementing technology solutions that meet business needs. They act as a bridge between business areas and the development team, ensuring that systems deliver real value to the organization.
Key skills include requirements gathering and analysis, process modeling (BPMN), data modeling, technical and functional documentation, system integration (APIs, microservices), and knowledge of ERPs and CRMs. Tools like Jira, Confluence, Visio, and project management platforms are essential.
Systems Analysts in technology companies are highly valued, especially those who master agile requirements analysis (user stories, backlog), system integration, and solution architecture. The field offers opportunities from junior analyst to solution architect, with a focus on efficiency, quality, and technological innovation.
Discover Other Areas
Understand the scope of work, key skills, and tools used in different career areas.
About Product Manager
The Product Manager (PM) is the professional responsible for defining the strategy, vision, and roadmap of a digital product. They work at the intersection of technology, business, and user experience (UX), leading the discovery and delivery of solutions that solve real problems in a viable way for the company.
Key skills include product discovery, data and metrics analysis (AARRR, NPS, LTV), user research, go-to-market strategy, roadmapping, strategic prioritization, and leadership by influence. Tools like Amplitude, Mixpanel, Hotjar, Jira, and Notion are fundamental.
Product Managers play a central role in the growth of startups, scale-ups, and large technology companies, with career progression opportunities to Product Leader, Head of Product, and Chief Product Officer (CPO).
About Graphic Designer
The Graphic Designer is the professional responsible for creating visual pieces for print and digital communication, from visual identity and logos to marketing materials and packaging. They combine creativity with technique to convey messages visually and impactfully.
Key skills include Adobe Photoshop, Illustrator, and InDesign, CorelDRAW, visual identity design, typography, color theory, packaging design, and motion graphics. Knowledge of vector illustration, offset/digital printing, and print production is a differentiator.
Graphic Designers in technology companies are highly valued, especially those who master social media design, infographics, and can create materials that strengthen brand visual identity. The field offers opportunities from junior graphic designer to art director and design director.
About Digital Marketing
Digital Marketing is a constantly expanding field, driven by e-commerce growth and the need for a strong digital presence. Marketing professionals master tools like Google Ads, Meta Ads, HubSpot, Google Analytics, and automation platforms.
Most sought-after specializations include Growth Marketing, Performance, SEO, Content Marketing, and Growth Hacking. The combination of creativity with data analysis is the most valued differentiator in the market.
The market offers opportunities in both agencies and technology companies, with competitive salaries and remote work possibilities.
About People Analyst
The People Analyst is the professional responsible for transforming people data into strategic insights for HR decision-making. They combine data analysis knowledge with people management vision to help organizations understand workforce metrics, turnover, engagement, and diversity.
Key skills include people analytics, workforce analytics, turnover and retention analysis, HR metrics (time-to-hire, cost-per-hire, e-NPS), data visualization (Power BI, Tableau, Visier), workforce planning, and compensation analysis. Knowledge of statistics, SQL, and people analytics tools is a differentiator.
People Analysts in technology companies are highly valued, especially those who can translate complex people data into actionable insights for retention, diversity, and growth strategies. The field offers opportunities from HR analyst to head of people analytics, with a focus on data-driven people management.
About Office Suite
Proficiency in Office Suite is an essential skill for professionals across various areas. Microsoft Excel, Word, PowerPoint, and Outlook are fundamental tools in the corporate day-to-day, while Google Workspace and other collaborative solutions are gaining increasing space.
Key skills include advanced Excel (formulas, pivot tables, Power Query, VBA/Macros), Word (formatting, mail merge, styles), PowerPoint (presentation design, animations), Outlook (email and calendar management), and collaborative tools like Google Sheets, Notion, and Airtable.
Professionals with advanced Office Suite proficiency are valued in administrative, financial, data, and operational areas. Microsoft Office Specialist (MOS) certifications are important differentiators. The combination of advanced Excel with data analysis skills is one of the most in-demand competencies in the market.
Comments 0