Analytics & Automation Engineer
Posted 49ds ago
Employment Information
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.
















