Job Description

The Role

We're looking for a

data-savvy automation specialist

who will be the critical bridge between our Meta Ads specialist and GHL expert. You'll be the "data plumber" who ensures every click, lead, and sale is tracked accurately from Facebook ads through to our client dashboards.

You'll own the entire data pipeline - capturing events from multiple sources, processing them through Pabbly Connect, storing them correctly, and visualizing them in beautiful Looker Studio dashboards that make our clients say "WOW!"

Your Mission:

Build and maintain automated systems that track every customer touchpoint with 95%+ accuracy, giving our clients crystal-clear visibility into their marketing ROI.

Your Daily ResponsibilitiesCore Duties (80% of your time):

Pabbly Connect Automation (40%)

Build complex multi-step workflows connecting GHL ? Google Sheets ? Facebook CAPI Handle webhook receivers and data routing Create error handling and retry logic Optimize workflows for speed and reliability Debug failed automations and fix data flow issues

Data Pipeline Management (20%)

Design Google Sheets structure for events storage Write Google Apps Script for data processing Create calculated fields and attribution logic Ensure data deduplication and accuracy Build data transformation rules

Dashboard & Reporting (20%)

Create stunning Looker Studio dashboards Build custom metrics and KPIs Design customer journey visualizations Set up automated report delivery Create client-specific filtered views

Supporting Duties (20% of your time):

Integration & Testing

Test tracking across entire funnel Verify Facebook CAPI events are firing correctly Ensure UTM parameters are captured properly QA dashboard data against source systems Document all automations and processes

Client Support

Debug tracking issues for specific clients Customize dashboards based on client needs Create training videos for common questions Monitor system health and uptime

Technical Skills Required

MUST-HAVE Skills (Non-negotiable)

1. Pabbly Connect Expertise

? Complex workflow creation (10+ steps)
? Webhook handling (receive and send)
? Iterator and aggregator functions
? Conditional routing (IF/THEN logic)
? Error handling and retries
? API module configuration
? JSON parsing and manipulation
? Custom code blocks (JavaScript)
? Schedule triggers and delays
? Data transformation and mapping

Google Sheets + Apps Script

? Advanced formulas (QUERY, ARRAYFORMULA, VLOOKUP, etc.)
? Google Apps Script coding
? Custom functions creation
? Triggers and time-based execution
? API calls from Apps Script
? Data validation and cleaning
? Pivot tables and data modeling
? Performance optimization for large datasets

3. Webhooks & APIs

? Understanding of REST APIs
? JSON structure and manipulation
? Authentication methods (API keys, OAuth)
? Webhook payload handling
? HTTP methods (GET, POST, PUT)
? Error codes and debugging
? Postman or similar tool usage
? Rate limiting concepts

4. Looker Studio (Google Data Studio)

? Data source connections
? Calculated fields and metrics
? Blending data sources
? Custom dimensions
? Filter controls and parameters
? Chart selection and customization
? Report sharing and permissions
? Scheduled email delivery

5. Data & Attribution Understanding

? UTM parameters structure
? Basic SQL concepts (even if using sheets)
? Attribution models (first-click, last-click)
? Data deduplication strategies
? Event tracking concepts
? Conversion tracking
? Basic statistics (conversion rates, averages)

NICE-TO-HAVE Skills (Preferred but not required)

? Facebook Conversions API knowledge
? GoHighLevel basic understanding
? Make.com or Zapier experience
? Basic JavaScript/Python
? BigQuery or database experience
? Git/version control
? Segment or similar CDPs
? Google Tag Manager
? Data privacy (GDPR) understanding

Job Type: Full-time

Pay: ₹437,022.93 - ₹756,804.42 per year

Benefits:

Work from home
Work Location: Remote