Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse programmatic data and create engaging content like blogs and case studies.
- Company: Join Picnic, a leader in media quality for programmatic advertising.
- Benefits: Freelance role with remote work, flexible hours, and project-based engagement.
- Why this job: Combine your analytical skills with creativity to impact the adtech industry.
- Qualifications: Experience in programmatic advertising and strong writing skills required.
- Other info: Opportunity for ongoing projects and career growth in a dynamic field.
The predicted salary is between 3000 - 5000 ÂŁ per month.
Picnic is building the surface layer for media quality and curation in programmatic advertising. Our platform, PIQ (Picnic Inventory Quality), helps agencies, brands and platform partners understand and optimise the quality of the websites and inventory where ads run. We work with programmatic buyers to turn quality signals into practical decisions that improve outcomes across campaigns and supply.
We’re looking for a freelancer who can combine deep, credible analysis of programmatic campaign and inventory data with the ability to turn that analysis into excellent marketing materials. This role is a blend of:
- Data analysis (campaign performance + inventory quality insights)
- Insight generation (what’s happening, why it matters, what to do next)
- Content creation (blog posts, case studies and occasional whitepapers)
- Light visualisation (simple charts and tables to support the story)
Projects will be set and scoped individually. Typical scope might be 1 blog post plus supporting analysis and charts, or a case study/whitepaper-style output.
Requirements
What you’ll do
- Analyse campaign + PIQ data
- Deep dive into campaign performance data and PIQ quality datasets to uncover patterns and clear “so what” insights
- Identify drivers of performance and quality across:
- domains/subdomains
- inventory cohorts
- formats (e.g., video, display, instream/outstream where relevant)
- placements/environments (where available)
- Blogs (data-led insights, trends, explainers)
- Case studies (results, before/after, methodology)
- Whitepapers / reports (deeper thematic analysis)
Example project topics
- The relationship between inventory quality and key outcomes (e.g., viewability, VCR, CTR, CPM efficiency)
- Domain/subdomain-level insights: what separates high-performing inventory from the long tail
- “Before vs after” quality filtering: performance changes when excluding low-quality inventory
- What agencies/brands miss when relying only on standard verification metrics
- Format-specific insights (e.g., instream video performance drivers)
What we’re looking for
Must-have
- Strong experience in and understanding of programmatic advertising (agency, DSP/SSP, adtech, analytics)
- Ability to work directly with real-world campaign datasets and messy exports
- Excellent writing skills for agencies, brands and platform partners
- Comfort producing charts and supporting tables (light but polished)
- Good judgement: you can separate a real signal from noise and avoid over-claiming
Nice-to-have
- SQL competency (you can query and transform datasets independently)
- Python for analysis and charting
- Familiarity with APIs and/or BigQuery
- Prior experience writing in the style of programmatic industry blogs (clear, data-led, commercially useful)
Tooling & data access
You’ll work with data provided via:
- CSV exports
- SQL access
- Picnic’s API
- (Nice-to-have) BigQuery
Typical working tools: Excel required, SQL/Python preferred.
How we work
We’ll scope each project clearly (objective, datasets, intended audience and content type). You’ll run analysis, propose angles and draft the piece. We’ll review and iterate quickly to finalise a publish-ready output.
Final content will be used across:
- Website/blog
- Sales enablement
- PR
Engagement structure
Project-based engagement. Rough cadence: 1 project every 2 months. We’ll start with a test project, then continue on an ongoing basis if it’s working well.
When Applying:
- Please share:
- 2-4 relevant writing samples (programmatic/adtech preferred)
- Brief summary of your programmatic background (roles, platforms, analysis experience)
- A short note on your preferred working style for data-to-content projects
If you have any additional material to support your application that can’t be included here, please feel free to email.
Benefits
This is a freelance, project-based contract role, not a permanent (PAYE) position. You’ll work remotely from anywhere, with flexible working hours and we’ll agree clear scope, timelines, and deliverables for each project. The engagement is designed for an independent freelancer who can take ownership of analysis-to-content work and deliver high-quality outputs on a defined project cadence (roughly one project every two months).
Freelance Data Analyst + Content Writer (Programmatic/Adtech) in London employer: Dataanalystjobs
Contact Detail:
Dataanalystjobs Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Freelance Data Analyst + Content Writer (Programmatic/Adtech) in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the programmatic advertising space. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have a lead on a freelance gig!
✨Tip Number 2
Show off your skills! Create a portfolio that highlights your best data analysis and content writing work. Make sure it’s easy to navigate and showcases your ability to turn complex data into engaging narratives. We love seeing what you can do!
✨Tip Number 3
Tailor your pitch! When reaching out to potential clients, customise your message to reflect their needs. Mention specific projects or insights that align with their goals. This shows you’ve done your homework and are genuinely interested in working with them.
✨Tip Number 4
Apply through our website! It’s the easiest way to get your application noticed. Make sure to include those relevant writing samples and a brief summary of your experience. We’re excited to see how you can contribute to our projects!
We think you need these skills to ace Freelance Data Analyst + Content Writer (Programmatic/Adtech) in London
Some tips for your application 🫡
Show Off Your Skills: Make sure to highlight your experience in programmatic advertising and data analysis. We want to see how you've tackled similar projects before, so don’t hold back on those relevant writing samples!
Keep It Clear and Concise: When you’re summarising your programmatic background, stick to the key points. We love a good story, but we also appreciate brevity. Let’s get to the good stuff quickly!
Tailor Your Content: Make your application resonate with us by aligning your writing style with our needs. Show us that you can turn complex data into engaging content that speaks to our audience in plain English.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to keep track of your application and ensure it gets the attention it deserves!
How to prepare for a job interview at Dataanalystjobs
✨Know Your Data Inside Out
Before the interview, dive deep into your past experiences with programmatic advertising data. Be ready to discuss specific campaigns you've analysed, the insights you uncovered, and how those insights influenced decision-making. This will show your expertise and ability to turn data into actionable content.
✨Craft Compelling Narratives
Prepare to showcase your writing skills by bringing along samples that highlight your ability to translate complex data into engaging narratives. Think about how you can explain technical findings in plain English, as this is crucial for the role. Practice summarising your analysis in a way that’s clear and relatable.
✨Visuals Matter
Since light visualisation is part of the job, be ready to discuss how you create charts and tables. Bring examples of your work that demonstrate your ability to present data visually. Make sure you can explain the story behind each visual and how it supports your analysis.
✨Align with Picnic's Vision
Research Picnic and its platform, PIQ, to understand their mission and values. During the interview, express how your skills and experiences align with their goals in media quality and curation. Showing that you’re on the same page will make a strong impression.
