Analytics & Automation Engineer (Remote)

Who is Basemakers?

Basemakers is one of the most trusted retail sales management companies in the food and beverage industry. After hitting the INC 500/5000 list of the fastest growing privately-held companies in America five consecutive times (as of 2025), we’re expanding our sales services (and most recently, our technology) to continue our growth. At the heart of our success is our unwavering belief in the transformative power of relationships—this is the ethos that propels us forward. We are not just a company; we are a dynamic force for change, partnering with trailblazing brands like Olipop, Guayaki (Yerba Madre), Nixie, C20 Coconut Water, and Honey Stinger. These partnerships help turn innovative products into household names. Our approach goes beyond retail sales and merchandising; we forge deep connections with brands, communities, and individuals who are driven to make a meaningful impact. Join Basemakers, and be part of a team that’s reshaping the world of CPG, one relationship at a time.

Be a Basemaker

Our Basemakers are committed to living our core values:

• P - We PURSUE EXCELLENCE 
• I  -  We act with INTEGRITY 
• T - We choose TEAMWORK
• C - We COMMUNICATE
• H - We bring HEART 

The Opportunity

If we didn't already have this job, we would apply for it ourselves! This is a rare opportunity to join a high-growth company right at the inflection point of a major strategic transformation. We are making a massive investment to rebuild our service offering around Data, AI, and Automation—and we need a builder to help us execute it.
You will report directly to the Data & Tech Lead, acting as their right hand in architecting and building key parts of an "internal operating system" that our Brand Partners and Field Teams will rely on every day. You won't just be maintaining databases, you will be building full stack data applications and ETL pipelines connecting our SaaS tools (Salesforce, Notion, Repsly), into a unified, AI-first internal intelligence layer.

This role sits at the intersection of Analytics Engineering and Process Automation. You are an ideal fit if you have strong technical chops (SQL/Python) but care more about solving the business problem than optimizing server configurations. We welcome candidates from non-traditional backgrounds—if you’ve been a Technical PM, a Systems Architect, or a RevOps lead who learned to code to get things done, we want to talk to you.

What You'll Build (The Projects)

You won't just be writing SQL queries; you'll be building full-stack data applications and agentic workflows.

• The "Glue" Work: Write robust Python scripts to pull data from SaaS APIs (Salesforce, Notion, Shopify, Repsly), transform it, and push it to BigQuery or trigger actions in other tools.
• Data Products vs. Dashboards: Instead of static spreadsheets, you will build interactive tools (using Streamlit and Plotly) that allow our internal teams to optimize workflows and track performance dynamically.
• AI-Enhanced Workflows: Move beyond chatbots. You will build autonomous agents that perform actual work.
  • Example: A "One-Click QBR Agent" that aggregates partner data and generates a presentation draft automatically.
  • Example: "Field Eyes" – using Computer Vision APIs, analyze in-store photos for stock levels and shelf placement.
    

Who You Are (Qualifications)

• SQL & Python Native: You can write a complex CTE in SQL and immediately switch to Python to loop through a JSON response from an API.
• A "Full-Stack" Analyst: You are bored of standard BI dashboards. You get excited when you see custom visualizations integrated natively into Salesforce or Slack bots answering business questions.
• System-Oriented: You see the big picture. You understand how changing a dropdown in Salesforce affects the downstream report in Tableau.
• A Finisher: You understand that "perfect" is the enemy of "shipped." You don't just write the script; you automate it, monitor it, and ensure the final data is accurate.

The Toolkit

• Must Have:
  • Strong proficiency in Python (handling APIs, JSON, automation scripts).
  • Advanced SQL (Window Functions, Modeling, CTEs).
  • SaaS API Experience: You know how to read documentation and get systems (Salesforce, Notion, Shopify) to talk to each other.
  • Visualization: Experience building clear, high-impact data tools (Tableau, Looker, Streamlit, or Plotly).
• Nice to Have:
  • Google Cloud Platform (BigQuery, Cloud Functions).
  • dbt (Data Build Tool).
  • AI Engineering experience (OpenAI API, LangChain)
  • CPG Industry experience
    

Our Philosophy

We welcome qualified candidates from non-traditional backgrounds. If you’ve been a Technical PM, a Systems Architect, or a RevOps lead who taught yourself to code to solve your own problems, we want to talk to you!

Compensation

Estimate $100,000 - $120,000 + Benefits

Compensation could vary depending on region and skill level.

Location

Remote work from home, United States. You will have generally 1-2 opportunities for in-person interactions during the year, including potential travel.

Benefits You'll Enjoy

• Medical, dental, and vision insurance (dental/vision coverage is free!)
• 401k plan with employer match
• Frontloaded PTO
• 8 paid holidays
• Monthly amount to recognize and be recognized by others.
• Company events: quarterly get-togethers, annual all-company meetings.

#LI-JH1