Data Solutions Executive

UNAVAILABLE; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A global media agency in London is seeking a Data Solutions professional to develop bespoke data solutions, manage product feeds, and create dashboards using tools like Power BI and Tableau. The ideal candidate will have strong analytical skills, understand SQL, and be comfortable in client-facing situations, contributing to innovative data operations. This position offers a dynamic work environment with emphasis on collaboration and growth.

Qualifications

• Basic understanding of SQL (BigQuery) or similar language.
• Strong analytical skills and problem-solving mindset.
• Comfortable in client-facing situations.

Responsibilities

• Develop bespoke data solutions for clients and internal teams.
• Manage product feeds across various channels.
• Create and manage dashboards using data visualization tools.

Skills

Understanding of SQL

Analytical thinking

Attention to detail

Proactive initiative

Client-facing communication

Microsoft Excel

Tools

Power BI

Tableau

Looker Studio

Job description

About Us

Assembly is a global agency delivering media, data, technology and talent to help brands perform. We are a purpose-driven organisation with a culture that values diversity, continuous learning, adaptability and meaningful impact. We are 1,500 people across 25 offices globally, working to create data, technology and media solutions that enable faster and smarter problem solving in a collaborative environment.

We are a meritocratic, high-performance business with a growth mindset. Our core DNA lies in digital performance marketing, expanding across all media to connect traditional channels with digital execution, measurement and automation. We embody three core values:

Show Up: actively contribute to personal and collective growth

Make Change: embrace obstacles as opportunities, taking intentional steps to drive positive change

Win Well: approach success with integrity, responsibility, and collaboration, understanding that the journey is as important as the destination

We look forward to meeting you and discussing how we can grow together.

Overview

The Data Solutions team at Assembly is expanding both service proposition and client base, proving a need to develop a worldwide support system.

This Team:

• Provides data visualisations (dashboard creation), ETL solutions and puts in place best practice measurement and data collection processes
• Manages various STAGE (our proprietary tech backed by Google Cloud Platform) products such as Shelfshare, SERPWatch, Forge
• Creates, manages and manipulates product feeds for all paid media channels

The role spans all existing paid media channels (including but not limited to display, paid social, organic performance, affiliates, content creation and localisation) as well as working on standalone propositions and new services centred around the use of data.

Responsibilities

• Addressing challenges or opportunities presented by clients or internal teams, creating bespoke solutions using technology
• Working with the Data Solutions and Development teams to identify and implement changes to available systems
• Ideation, management and improvement of additional services centred around any currently available or newly sourced datasets
• Stay abreast of developments in the industry, changes to formats, performance factors, and other industry services
• Liaising with internal teams, addressing their product feed challenges or opportunities, creating bespoke solutions using technology
• End-to-end management of product feeds for various channels and platforms, including (but not limited to) Google and Bing shopping, social, affiliates and display activity.
• Identifying and sourcing available raw data, managing the pipelines, and combining data from any additional sources
• Creation and management of client dashboards using Power BI, Tableau, Looker Studio

Required Skills

• Basic understanding of SQL (BigQuery) or another similar language
• Strong analytical individual who enjoys lateral thinking and problem solving
• Attention to detail and able to effectively troubleshoot issues across various data sources and platforms
• Proactive individual who is confident taking the initiative and working with colleagues across teams and departments
• Comfortable in client facing situations; presenting and discussing activity in emails, calls and in meetings
• Confident using Microsoft Excel for data interrogation

Desired Skills

• Understanding of Google shopping mechanics and product feed structure
• Any additional coding or data management experience (Python, SQL,...)
• Any experience working with and consolidating multiple data sources (direct from media platforms, APIs, Google Sheets, FTP, HTTP etc.)
• Any prior experience with data visualisation tools; Looker Data Studio, Datorama, Tableau, Power BI or similar

Equal Opportunities

Assembly is an advocate for equal opportunity in the workplace. We are committed to ensuring equal opportunities regardless of race, colour, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability and gender identity. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires accommodation, please let us know.