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 Design
The Design field, especially UX/UI and Product Design, has experienced significant growth in recent years. With accelerated business digitization, the demand for professionals who can create intuitive and pleasant digital experiences has never been higher.
Key skills include Figma, Sketch, Adobe XD, user research, design thinking, prototyping, and system design. Product designers are increasingly valued for their direct impact on business results.
Remote work has opened doors for Brazilian designers to work for global companies, with competitive salaries in dollars and euros.
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.
About Account Manager
The Account Manager is the professional responsible for managing and expanding the relationship with clients after the sale. They act as a strategic partner, ensuring satisfaction, retention, and account growth, connecting client needs with company solutions.
Key skills include relationship management, negotiation, upsell and cross-sell, contract renewal, account planning, business reviews, metrics analysis (NPS, churn, LTV), and CRM knowledge (Salesforce, HubSpot). Communication, empathy, and business vision are fundamental differentiators.
Account Managers in technology and SaaS companies are highly valued, especially those who can increase recurring revenue (MRR/ARR) through account expansion and churn prevention. The field offers opportunities from account executive to director of accounts, with a focus on strategic relationship, revenue growth, and customer success.
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 Cloud Solutions
The Cloud Solutions area is responsible for designing, implementing, and managing cloud infrastructure and services (AWS, Azure, GCP) for companies. Cloud professionals architect scalable, secure, and cost-optimized solutions, from data center migrations to serverless and multi-cloud architectures.
Key skills include IaC (Terraform, CloudFormation), containers (Docker, Kubernetes), serverless (Lambda, Cloud Functions), managed databases (RDS, DynamoDB, BigQuery), cloud networking (VPC, CDN, load balancer), and security (IAM, WAF, KMS). Knowledge of FinOps, cloud governance, and AWS/Azure/GCP certifications is a differentiator.
Cloud Solutions professionals in technology companies are highly valued, especially those who master multi-cloud architectures, FinOps, and can optimize costs while maintaining performance and security. The field offers opportunities from cloud engineer to cloud solutions architect, head of cloud, and chief cloud architect.
Comments 0