Paid Social and AI data analyst

Somerce®; Greater London; On-site; GBP 40,000 - 55,000; Full time

Benefits offered by this job

Exposure to marketing and technical problem-solving

Opportunity to shape agency operations

Growth path into senior operations

Job summary

A digital marketing agency in Greater London is seeking a data analyst/prompt engineer. The ideal candidate will support account managers with data for client performance and build AI and data pipelines to spot revenue opportunities. Required skills include strong knowledge of paid social platforms, proficiency in SQL and Python, and experience with data integration. This role offers an opportunity to impact marketing data strategies and advance into senior operations.

Qualifications

• Strong knowledge of paid social platforms including Meta, TikTok, and Google Ads.
• Proficiency in SQL and Python for data analysis and automation.
• Understanding of AI and experience with data pipelines.

Responsibilities

• Support account managers with relevant data for client performance.
• Optimise analysis processes to maximise client return.
• Build AI and data pipeline to identify revenue opportunities.

Skills

Paid social platforms knowledge

SQL proficiency

Python for data analysis

API integration experience

Excel/Google Sheets skills

AI LLM and agent frameworks

Building data pipelines

Understanding marketing data

Agency experience

Job description

About the Role

Somerce is a TikTok Shop specialist agency focused on driving GMV growth for brands. We work with some of the fastest-growing beauty, fashion, lifestyle and FMCG brands in the UK, US and EU, managing everything from live commerce and affiliates to paid media and trading strategy.

We have a unique role for a data analyst / prompt engineer to work at the cutting edge of social commerce and AI, who will suit a self‑starter keen to leave their mark in data and marketing.

Reporting to: Director of Performance

Key Responsibilities

• Support account managers to ensure they have relevant data for client performance
• Optimise and automate analysis processes to maximise return for client and identify gaps in performance for account managers
• Provide data transparency through reports from senior to junior staff, and clients
• Evangelise data storytelling

AI and Revenue Generation

• Build an AI and data pipeline that enables the team to spot revenue and cost opportunities
• Build opportunities into plans for clients and present ideas back to clients
• Explore and implement AI agent solutions to improve efficiency in reporting, research, and campaign management
• Support data integrity across platforms, ensuring consistency and accuracy
• Ensure data security is a top priority for all clients

Skills & Experience

• Strong knowledge of paid social platforms (Meta, TikTok, Google Ads)
• Proficiency in SQL and Python for data analysis and automation
• Experience with APIs and data integration
• Strong Excel/Google Sheets skills
• Understanding and demonstrated usage of AI LLM and agent frameworks is required
• Experience or knowledge of building or deploying AI agents for automation, data analysis, or research tasks
• Ability to understand marketing data and translate into actionable recommendations
• Experience in building data pipelines
• Experience in an agency setting is a plus

Personal Attributes

• Analytical thinker with attention to detail
• Problem‑solver with a focus on efficiency
• Curious about AI applications in marketing and operations
• Comfortable working independently and with cross‑functional teams
• Excellent written and verbal communication skills
• Self‑starter

What We Offer

• Exposure to both marketing and technical problem‑solving
• Opportunity to shape how the agency works at scale
• Growth path into senior operations