Automation & Data Intelligence Engineer

Regalado Company
Windermere, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 125K

Job location

Windermere, United States of America

Tech stack

API
Artificial Intelligence
Data analysis
Business Logic
Data Integration
ETL
Web Development
Data Intelligence
Intrusion Detection Systems
Python
PostgreSQL
Marketing
Standard Sql
SQL Databases
Google Data Studio
Facebook Ads Api
Data Pipelines
Service Stack
Airtable

Job description

Regalados Group is building an internal creator advertising intelligence platform focused on:

  • Meta/Facebook advertising analytics
  • Amazon affiliate tracking IDs
  • profitability reporting
  • campaign intelligence automation
  • creator monetization systems

We are seeking a highly capable automation and data engineer to help build an internal reporting and decision-making system that connects advertising spend directly to commission profitability.

This is not a generic web development role. We are looking for someone who understands:

  • performance marketing
  • affiliate marketing
  • APIs
  • automation systems
  • attribution logic
  • operational analytics, * Creator Analytics Engineer
  • Media Buying Intelligence Engineer
  • AI Workflow Engineer

Phase 1 Scope (Initial Engagement)

Estimated Project Size

  • Approximately 100-120 hours total

The initial engagement will focus on building a reliable automated profitability reporting system.

Core Deliverables

  1. Meta Ads Data Integration

Automate daily imports from Meta Ads including:

  • campaign
  • ad set
  • ad name
  • spend
  • clicks
  • CPC
  • CPM
  • CTR
  • frequency
  1. Amazon Tracking ID Reporting Integration

Automate import of:

  • tracking IDs
  • clicks
  • shipped revenue
  • commission earnings
  • returned revenue
  • returned earnings
  1. Tracking ID Attribution Logic

Build logic connecting:

  • Meta campaigns/ad namesto
  • Amazon tracking IDs
  1. ROI & Profitability Engine

Build calculations for:

  • net profit
  • ROI
  • EPC
  • return rates
  • spend efficiency
  1. Daily Reporting Dashboard

Create automated daily reporting showing:

  • winners
  • losers
  • scaling opportunities
  • inefficient spend
  • high-return products
  • profit rankings by campaign/tracking ID

Preferred Technology Stack

  • Python
  • Meta Ads API
  • SQL
  • n8n
  • Airtable or Supabase
  • Google Sheets
  • Retool / Looker Studio

Requirements

Do you have experience in SQL databases?, Strong experience with:

  • APIs
  • automation workflows
  • ETL/data pipelines
  • dashboard systems
  • SQL
  • Python
  • Meta Ads API

Preferred experience:

  • affiliate marketing
  • Amazon Associates / Creator Program
  • ecommerce attribution
  • media buying analytics
  • AI workflow automation

Ideal Candidate

You are:

  • analytical
  • systems-oriented
  • operationally minded
  • proactive
  • capable of working independently
  • comfortable translating business logic into scalable automation

Benefits & conditions

$30 - $60 an hour - Contract, * AI-generated campaign intelligence

  • fatigue detection
  • creative analysis
  • predictive scaling alerts
  • category/hook analysis

Phase 3

  • multi-platform integrations
  • advanced attribution systems
  • creator intelligence platform development
  • scalable commercial deployment

This has the potential to evolve into a long-term strategic role within Regalados Group's media and technology division.

Compensation

Compensation structure may include:

  • hourly contractor
  • milestone/project-based
  • long-term engagement potential

Initial Phase 1 Budget Target

  • Approximately 100 hours total
  • Preferred range:
  • $30-$60/hour depending on experience and execution quality

Apply for this position