Data Engineer

Role Overview
We are seeking a Data Scientist to own the data, integration and automation work behind our agency, ourinternal teams and our clients, from understanding the problem to delivering a working solution. Most ofthis work runs through Claude Code. You will build AI agents that pull data from ad platforms, CRMs andbusiness tools, clean and transform it, load it into a central database or Zoho Analytics, and turn it into
dashboards, reports and analysis that people use to make decisions. You will also connect the tools ourteams use every day, so data moves between them without manual entry.
This is a data scientist role, not a reporting analyst role: you build the complete data flow and you analysethe data yourself. It is a remote, contractual role with a BYOD policy, worked in either the UK or the US shift, for a professional who can take a brief, work out the right solution in our environment (Zoho and Claude Code) and deliver it quickly with minimal supervision. Selection is an interview followed by a oneweek paid trial project on a real task

Roles and Responsibilities

• Own each data, integration or automation request from start to finish: understand the problem, ask the right questions, map the workflow and agree what the finished solution looks like before you build it.
• Build and run AI agents in Claude Code (skills, subagents, MCP connections and scheduled jobs) that handle data extraction, transformation, loading, reporting and routine analysis.
• Develop and maintain ETL pipelines that pull data from Google Ads, Meta Ads, GA4, CRMs and other business tools through APIs and connectors, then clean, standardise and load it into a central database.
• Integrate the tools our teams and clients use (Zoho apps, CRMs, forms, SMS and calling tools) through APIs and webhooks, so records update automatically instead of being entered by hand.
• Build and manage dashboards in Zoho Analytics (and Looker Studio or Power BI where a client needs it), blending several data sources into one clear view of spend, leads, sales and performance.
• Automate recurring client and internal reports (weekly, monthly and quarterly) so they go out accurate and on time without manual effort.
• Analyse the data to answer real business questions: what is working, where budget is being wasted, which leads turn into customers and what next month is likely to look like. Use forecasting, segmentation or anomaly detection when the problem calls for it.
• Work within our tool stack, mainly Zoho (Analytics, CRM, Bigin, Recruit, Creator, Flow) and Claude Code, and choose the simplest reliable way to solve each problem in that environment.
• Handle client data, API keys and platform access securely, and monitor every pipeline, agent and dashboard you build so broken data is caught and fixed before anyone else notices.
• Explain your work, findings and recommendations in plain English to non-technical clients and internal teams, share short written progress updates, and document every workflow so the team can run itwithout you.

Must-Have Requirements

• A minimum of 3 years of hands-on experience in a data science role where you built complete data flows (extract, transform, load) and analysed the data yourself.
• Hands-on, proven experience using Claude Code, including building AI agents or automated data workflows with it. You should be able to show us something you built.
• Proven experience integrating platforms through APIs, webhooks or connectors, for example pulling Google Ads, Meta Ads, GA4 or CRM data into a working dashboard.
• Strong Python and SQL, and working knowledge of at least one database or warehouse such as PostgreSQL, Supabase, BigQuery or Snowflake.
• Experience building dashboards in a BI tool such as Zoho Analytics, Looker Studio, Power BI or Tableau.
• Demonstrated ability to take a loosely defined business brief, break it down, design the workflow and deliver a working solution quickly.
• Clear written and spoken English, with the confidence to explain technical work to non-technical clients.
• Demonstrated ability to take ownership of your work and deliver independently with minimal supervision.
• Willingness to work on a contractual basis, remotely, using a personal device (BYOD) and a reliable high-speed internet connection, in either the UK shift (2:00 pm to 11:30 pm IST) or the US shift (7:00pm to 4:00 am IST).

Nice-to-Have

• Hands-on experience with Zoho tools, especially Zoho Analytics, Zoho CRM or Bigin, Zoho Creator,Deluge scripting or Blueprint automation.
• Experience working at or for a digital marketing or web development agency.
• Understanding of marketing metrics and tracking, such as CPA, ROAS, conversion tracking and lead quality.
• Machine learning or statistical modelling for business problems, such as forecasting, lead scoring or marketing mix modelling.
• Experience with GoHighLevel (GHL) or other marketing CRMs, including SMS and calling integrations such as Twilio.
• Experience with MCP (Model Context Protocol) servers or other ways of connecting AI agents to business tools.
• Google Sheets automation with Apps Script, or Airtable.