Connect siloed MarTech platforms (Google Analytics 4, Google Ads, Meta Ads, Ahrefs, HubSpot) into centralized data warehouses (e.g., BigQuery) and visualize them in real-time using Looker Studio, PowerBI, or Tableau.
Design and maintain complex automation flows using Make.com , n8n, or Zapier to trigger internal agency alerts, client onboarding sequences, and task creation in Jira/Asana.
Integrate LLM APIs (OpenAI, Gemini, Anthropic) into internal workflows (e.g., automating programmatic SEO outlines, ad copy generation testing, or summarizing client call transcripts into actionable tickets).
Build and maintain ETL (Extract, Transform, Load) pipelines to ensure our client reporting data is 100% accurate, fresh, and properly formatted.
Audit our current software subscriptions and consolidate/replace expensive SaaS tools with customized internal automated solutions where possible.
Requirements
Strong proficiency in Python and/or Node.js specifically for API integrations and data manipulation.
Expert-level experience with Make.com (Integromat) or n8n (not just basic Zapier).
Experience writing SQL and managing data in Google BigQuery. Advanced skills in BI visualization (Looker Studio, Metabase, or similar).
You must understand digital marketing data structures. You need to know the difference between a "Click" and a "Conversion" and be familiar with the APIs of Google Ads, Meta Graph, GA4, and leading CRM platforms.
Proven experience calling REST APIs for major LLMs, writing structured system prompts, and handling JSON outputs to feed back into databases.
Tech Stack
BigQuery
ETL
JavaScript
Node.js
Python
SQL
Tableau
Benefits
Software Replacement Bonus: If an internal system is built that successfully replaces a paid software subscription, the engineer will receive a one-time cash bonus equal to 15% of the annualized cost of the canceled software. (Condition: The internal tool must be fully adopted and used by the team without critical failure for 30 consecutive days before payout).
Project Deployment Bonuses: Flat cash bonuses ranging from ₱15,000 to ₱50,000 will be paid upon the successful launch and team adoption of pre-approved major automation milestones (e.g., Automated Reporting Pipelines, AI Content Engines).