Analytics & Automation Engineer

Posted 49ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Analytics & Automation Engineer at Basemakers building full stack data applications and ETL pipelines. Join a high-growth company transforming data, AI, and automation in the food and beverage industry.

Responsibilities:

  • 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.
  • 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.
  • 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.
  • You will build autonomous agents that perform actual work.

Requirements:

  • 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.
  • 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).

Benefits:

  • 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.