Automation Engineer & Data Integration Specialist | ZR_28650_JOB
BruntWork.com
Hybrid
Remote
Full Time
This is a remote position.
Job Highlights:- Contract type: Independent Contractor
- Schedule: Mon-Fri 9am - 5pm GMT/BST - can be flexible as long as core hours of 10am - 4pm are being served.
Role Purpose
To design, build, and maintain automations, data pipelines, and lightweight software tools that make the company's marketing operations and client reporting run efficiently — reducing manual work across the business.
Responsibilities
Automation & Integration
- Build and maintain automations using n8n, Zapier, or Python.
- Connect Gmail, ClickUp, Slack, Google Sheets, Xero, SEMrush, and similar tools.
- Develop AI-driven workflows (e.g., email → LLM summary → ClickUp ticket creation).
- Maintain API keys, authentication, and error logging for reliability.
Data & Dashboard Support
- Pull data from APIs (Google Lighthouse, Screaming Frog, Majestic, SEMrush, DataForSEO).
- Clean and merge datasets in Google Sheets, PostgreSQL/MariaDB, or Airtable.
- Prepare data feeds for Legmark’s Digital Dashboard and automated reports.
- Support web developers by maintaining simple PHP/Python endpoints and cron jobs.
- Manage hosting for automations on AWS Lightsail or Cloudways.
- Deploy and monitor background scripts or bots.
- Create clear documentation for each workflow (inputs, outputs, dependencies).
- Use GitHub for version control and change tracking.
- Recommend new opportunities to automate repetitive tasks.
Requirements
- Proficient in Python (requests, pandas, APIs, JSON).
- Experienced with n8n, Zapier, or similar automation tools.
- Familiar with MySQL/MariaDB/PostgreSQL databases.
- Basic understanding of web technologies (HTML, CSS, JavaScript).
- Experience integrating with Google, ClickUp, Slack, and email APIs.
- Comfortable deploying scripts on a VPS (Lightsail/Linux).
- Strong written and spoken English.
Nice-To-Have
- Data visualization (Looker Studio, Grafana, Streamlit).
- SEO/digital-marketing background or interest.
- Understanding of cron jobs and webhook architecture.
Reporting & Collaboration
- Daily short update via Slack/ClickUp (work done + next steps).
- Weekly check-in call with Sam Borrett.
- Collaborates with:
- Alex (development partner) for dashboard integration.
- Dora (operations) for workflow rollout.
Example Projects in the First 3 Months
- Email-to-ClickUp Intake Bot – analyze client emails via AI → auto-create tasks.
- Automated Lighthouse & Screaming Frog Reports – weekly site audits.
- Keyword Discovery + DataForSEO Enrichment pipeline.
- ClickUp → Google Sheets Sync for client reporting.
- Slack Reminder Bots for timesheets and task updates.
Performance Metrics
- Automations running reliably with <2% failure rate.
- All scripts documented and version-controlled.
- Demonstrated reduction in manual admin time (tracked via ClickUp).
- Positive feedback from internal users (Sam, Dora, Alex).
Benefits
Independent Contractor Perks:- HMO Coverage for eligible locations
- Permanent Work from home
- Immediate Hiring
- Steady Freelance job
Please note that since this is a permanent work-from-home position and an “Independent Contractor” arrangement, the candidates must have their own computer and internet connection. They will handle their own benefits and taxes. The professional fees are on hourly rates and the rate depends on your performance in the application process.
ZR_28650_JOB