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: Flexible remote work, project-based engagement, and the chance to showcase your skills.
- Why this job: Combine data analysis with creative writing to make an impact in the adtech industry.
- Qualifications: Strong understanding of programmatic advertising and excellent writing skills.
- Other info: Work independently on exciting projects with clear objectives and timelines.
The predicted salary is between 30000 - 50000 £ per year.
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 are 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.
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
- 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
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 connie@picnic.io
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: Picnic Media Limited
Contact Detail:
Picnic Media Limited 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
Get your networking game on! Reach out to folks in the programmatic advertising space, join relevant online communities, and don’t be shy about sharing your expertise. You never know who might have a project that needs your skills!
✨Tip Number 2
Show off your analytical chops! Create a portfolio showcasing your best data analysis projects and content pieces. Make sure to highlight how your insights led to real-world improvements in campaign performance.
✨Tip Number 3
When you apply, tailor your pitch! Use the job description as your guide and align your experience with what Picnic is looking for. Mention specific tools and techniques you’ve used that relate to their needs.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about working with us at Picnic!
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 showcasing your relevant skills and achievements!
Craft Compelling Writing Samples: When sharing your writing samples, pick pieces that reflect your ability to turn complex data into engaging content. We love clear, data-led narratives, so choose examples that demonstrate your knack for making insights accessible.
Be Clear About Your Working Style: In your application, let us know how you prefer to work on data-to-content projects. Whether you like to collaborate closely or prefer a more independent approach, being upfront about your style helps us understand how we can work together effectively.
Apply Through Our Website: We encourage you to apply directly through our website. It streamlines the process for both of us and ensures your application gets the attention it deserves. Plus, it’s super easy!
How to prepare for a job interview at Picnic Media Limited
✨Know Your Data Inside Out
Before the interview, dive deep into your understanding of programmatic advertising and data analysis. Be ready to discuss specific campaigns you've worked on, the insights you derived, and how they impacted performance. This will show that you can not only analyse data but also translate it into actionable insights.
✨Craft Your Content Samples
Since this role involves content creation, prepare a few writing samples that showcase your ability to turn complex data into engaging narratives. Focus on clarity and relevance to the programmatic audience. Highlight any case studies or blog posts that demonstrate your analytical skills and writing prowess.
✨Visualisation Skills Matter
Brush up on your chart-making skills! Be prepared to discuss how you would present data visually. Bring examples of simple yet effective charts or tables you've created in the past. This will help illustrate your ability to support your analysis with clear visual aids.
✨Align with Picnic's Vision
Research Picnic and its platform, PIQ. Understand their mission and how they position themselves in the market. During the interview, express how your skills and experiences align with their goals. This shows that you're not just looking for any freelance gig, but are genuinely interested in contributing to their success.
