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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonSQLETLAPI integrationData visualizationData modelingAutomationJSONSaaSFull-stack development

Soft Skills

System-orientedAttention to detailProblem-solvingAdaptabilityCollaborationCreativityTime managementCommunicationFinisher mindsetCritical thinking