Client Implementations Data Solutions Architect

Company: Subscript, Inc.
Location: San Francisco
Posted on: May 24, 2025

Job Description:

Data Solutions works with new customers to set up their data in Subscript and verify everything is correct!Exciting update: We just closed our Series A a couple months ago (see more details). It's a really fun + empowering time to be joining our Subbie team!The basics

• The product : We're building the premier metrics-first finance and billing platform that empowers B2B SaaS leaders to invoice their customers, tell their ARR story, and track accounting revenue, all in one place-regardless of how complex their customers' contracts are
• The role you'll play on our team:
  • You'll be the first point of contact for new customers after they've signed on to Subscript , and will work with them through complex, data-intensive implementations . You'll hook our new customers up to their source data, help them clean and validate their data in Subscript, and help do the types of analysis that give them the most value .
  • Over the course of each implementation, you'll work to get ARR metrics, invoices, and accounting revenue clean and complete, referencing clients' CRMs (e.g. Hubspot, Salesforce), general ledgers (e.g. Quickbooks, Xero), billing tools (e.g. Stripe, Maxio, Chargebee), and spreadsheets.
    • The Subscript app acts as our de-facto ETL pipeline, but is highly customizable, which means working with an in-house transformation layer (built off of ) to configure our ingestion rules.
    • You can expect to split your time across four main tools:
      • 1. Spreadsheets - Transforming and cleaning clients' past data to be ingested into Subscript, as well as validating results
      • 2. Internal configuration JSON files - The transformation rules described above, used for hooking up to external data sources
      • 3. SQL - To understand internal data, e.g. after ingestion
      • 4. Postman/APIs - To fetch and explore external data (e.g. Hubspot deals or Quickbooks invoices) that will be ingested into Subscript
      • (Bonus) Python - This isn't strictly required, but we occasionally make use of Colab notebooks to do data fetching and/or transformation that would be too challenging via other methods
      • You'll be the seventh member of the Data Solutions team, and will help define what the role becomes as we grow! You'll work closely with the whole company, including our co-founders and . They formerly built and successfully exited a B2B SaaS company called , and this is their second start-up.
      • We're a young company with a lean team (current under 30 people, but growing quickly!), so you'll have a huge say in how we shape and build all parts of our organization ---. You'll have a ton of autonomy in defining + iterating on best practices and processes to really help both our customers AND our teammates reach the moon!
      • You'll not only work directly with the new clients you take on, but also support other team members as they encounter new challenges and could learn from your experience and insight.
      • The way we work:
        • We are an asynchronous team
          • We don't do scheduled internal meetings, so the vast majority of communication is available to anybody at any time in written documentation, whole-company Slack channels, and video documentation. If you're sick of pointless meetings, this is the place for you!
          • Sounds a little nuts, right? But it works! And it's one of our secret sauces for why our team is so high-performing (and happy!). You can hear more about working in our Async culture in featuring our CEO.
          • We operate completely autonomously
            • No one will tell you what to do; everyone gets transparent context and details about the company goals and you will figure out how to work towards them with the rest of the team!
            • This is a remote job - work anywhere you want
              • Although we are fully remote and asynchronous internally, our clients are all over the world; you'll be taking live calls most days of the week with customers in California, Australia, or US-East, so a substantial overlap in your working hours is a must! You can expect to be working US-Pacific hours
              • We're a team that loves working together
                • We love playing board games (these we do synchronously ). Full-time team members meet up multiple times per year for live off-sites around the world (expenses paid!)Our interview processWe like to be really transparent and communicative about everything at Subscript, including our interview process:Our interview process is designed to focus on your intuition with analytics, and your ability to communicate clearly (both written and in video calls). We default to asynchronous communication internally, so the majority of the interview process follows suite .The interview will focus around your ability to understand, support, and engage our awesome customers
                • First, we'll ask you to work on spreadsheet task similar to the type of data work you'll be doing with our customers! As part of this simulation, you'll get a chance to ask clarification questions about the data .
                • We'll then have a short live call to talk through your background, career goals, and working style, which will also offer you the chance to talk through questions you may have about the role, the product, the team, or whatever else is on your mind.
                • The second asynchronous task will be a SQL exercise (postgres) to show your ability in working with databases. We'll provide the data and details on the required output, and you'll provide the query to get there.
                • Next, you'll have a chance to show off your customer communication, as you prepare for and lead a live kick-off call with a brand new Subscript customer (who we will be taking on the role of for the purposes of the interview ????).
                • Finally, you'll have a chance to meet and talk with one of our cofounders. This isn't graded or used in evaluation, but is an opportunity for you to go to know us better and answer any lingering questions you might have. It's important for us that our company and working style is a good fit for you and that you have everything you need to make the right decision.
                  • Our ideal candidate loves data (analyzing it, talking about it, advising our customers using it). You'll be acting as a key strategic advisor to our customers using that data!
                    • We're looking for...
                      • serious spreadsheet skills
                      • experience requesting and reading JSON data from APIs
                      • satisfaction in getting to perfectly clean data
                      • SQL mastery
                      • familiarity with B2B SaaS business models
                      • ability to work US-Pacific time
                      • 5+ years relevant experience
                        • We're also happy to see (but don't require)---
                          • comfort in Python
                          • experience with general ledgers used in SaaS finance (e.g. Quickbooks, Xero, and and Netsuite)
                          • exposure to CRM software (Hubspot and Salesforce)
                          • You're kind, empathetic, and communicative . Both externally, as you'll be collaborating closely with customers, as well as internally, as you'll be supporting with the broader team in written docs + recorded videos.
                            • Unlimited vacation
                            • Flexible work schedule - work anytime and anywhere you want (as long as you are available to work with clients during their business hours and join live calls with them)
                            • Benefits appropriate to your location (health/dental/vision in the USA)
                            • Company-wide retreats multiple times per year, all expenses paid
                            • Like all start-ups we're scrappy, but not scrappy on compensation: Subscript is committed to paying our awesome team members at market-rate, including benefits.
                              #J-18808-Ljbffr

Keywords: Subscript, Inc., Santa Rosa , Client Implementations Data Solutions Architect, Other , San Francisco, California