Responsibilities

• Build and maintain data pipelines between ad platforms, CRM, and Supabase (or central database).
• Eliminate Google Sheets as secondary storage by migrating processes to structured databases.
• Set up automated syncing, deduplication, and validation workflows to ensure clean, reliable data.
• Replace brittle Zapier automations with robust Supabase functions, Python scripts, or low-code backend workflows.
• Coordinate with AdOps and backend engineers to ensure smooth data ingestion, transformation, and delivery.
• Automate repetitive tasks like campaign tagging, data normalization, and monthly sales-ranking feeds.
• Develop dashboards and automated reports that summarize campaign performance, ROI, CAC, and conversion trends.
• Use AI models or Python tools to automatically clean data, identify anomalies, and generate narrative summaries.
• Support leadership with predictive insights (e.g., lead quality trends, campaign saturation).
• Work closely with the marketing team, analyst, and AdOps to streamline reporting and tracking processes.

Requirements

• 3+ years of experience in marketing automation, analytics, or data engineering.
• Strong skills in Python, SQL, and data transformation (ETL/ELT).
• Experience with Supabase, BigQuery, or similar modern databases.
• Familiarity with ad platforms, Zapier, and API integrations.
• Exposure to AI/ML tools for reporting, data cleaning, or predictive analysis.
• Excellent analytical and problem-solving skills with attention to data accuracy and automation reliability.