We’re the world’s leading data, insights, and consulting company; we shape the brands of tomorrow by better understanding people everywhere.

Worldpanel provides brands and retailers with a unique, 360-degree understanding of consumer behaviour across the globe. We are shopper-centric, continuously monitoring the purchase and usage behaviour through the largest omnipanel in the world. With unparalleled datasets, pioneering technology and expert analysts, we partner with brands and retailers of all sizes, empowering them to reimagine what’s possible, and change the landscape to create a better, healthier, more sustainable and inclusive world.

Job Details

Job Title & Location

Data Processing & Systems Support Specialist

London, Westgate (Hybrid)

About the Role

We are seeking a proactive and detail-oriented Data Processing & Systems Support Specialist to join our team. This role is a hybrid position, combining data processing, system support, and troubleshooting, with a focus on preparing clean, accurate datasets for analysis by other partners. The successful candidate will also be responsible for supporting various administrative tasks and activities to ensure smooth operation of our data systems and processes.

In this role, you will ensure data is processed, formatted, and organized correctly, and ready for downstream analysis. You will also assist with administrative functions that support the team's daily operations and contribute to overall system efficiency.

Key Responsibilities

Data Processing & Preparation:

Use advanced Excel functions (e.g., Pivot Tables, IF formulas, VLOOKUP, and data formatting) to process, clean, and structure data for analysis.Ensure data consistency and accuracy, organizing datasets in formats that are easy for other teams to work with.Prepare and validate large datasets for analysis, ensuring the data is properly cleaned and ready for consumption by analysts.

System Support & Troubleshooting:Monitor and troubleshoot data systems, resolving issues related to data flow, system performance, and data availability.Work closely with internal teams to diagnose and resolve technical issues promptly, ensuring data is available when needed.

Database Management:Maintain and manage databases, ensuring data is stored in a structured, accessible, and secure manner.Optimize queries and database performance to ensure efficient data retrieval and storage.Oversee the data management processes to ensure data integrity and availability for analysis.

SQL & Stored Procedures:Write and optimize complex SQL queries to extract and manipulate data for reporting and analysis.Understand and manage stored procedures, ensuring proper execution and integration with data processing systems.Troubleshoot and support batch processes to ensure smooth, error-free data processing.

Administrative Support:Assist with various administrative tasks, including maintaining documentation, tracking data system issues, and managing internal records.Support day-to-day operations by helping coordinate tasks, reporting, and follow-up activities.Maintain records of system issues, process improvements, and data-related changes for audit and reporting purposes.Assist with the preparation of internal reports or presentations as required.

Required Skills & QualificationsStrong proficiency in Microsoft Excel, including advanced functions such as Pivot Tables, IF formulas, Lookups, and data formatting.Proficient in SQL, with the ability to write and optimize complex queries to manage and extract data.Understanding of stored procedures and their role in managing and processing data.Solid knowledge of database management practices and ensuring efficient data storage and access.Experience with batch processing and troubleshooting related issues.Ability to prepare, clean, and organize data for analysis, ensuring data readiness and consistency.Strong administrative and organizational skills, with the ability to manage multiple tasks and maintain detailed records.Strong problem-solving skills and data accuracy.

Preferred SkillsExperience with ETL (Extract, Transform, Load) processes or tools.Familiarity with data warehousing concepts and tools.Knowledge of programming languages (e.g., Python, R) for data manipulation is a plus.Experience in system administration or network troubleshooting is a plus.

Personal AttributesStrong analytical approach with the ability to structure and prepare data for others to analyze.Superb communication skills, with the ability to collaborate with both technical and non-technical teams.Proactive, hard-working, and able to take ownership of tasks and responsibilities.Organized and able to manage multiple priorities while maintaining attention to detail.A great teammate who is comfortable working with multi-functional teams to ensure smooth data and system operations.

What you’ll get from us25 days annual leave (excl. bank holidays), plus your birthday off!Flexible benefits across health, wealth and lifestyleExtensive training and excellent scope for career developmentA collaborative and supportive work environment!

#LI-HP1 #LI-Hybrid

Country

United Kingdom

Why join Kantar?

We shape the brands of tomorrow by better understanding people everywhere. By understanding people, we can understand what drives their decisions, actions, and aspirations on a global scale. And by amplifying our in-depth expertise of human understanding alongside ground-breaking technology, we can help brands find concrete insights that will help them succeed in our fast-paced, ever shifting world.

And because we know people, we like to make sure our own people are being looked after as well. Equality of opportunity for everyone is our highest priority and we support our colleagues to work in a way that supports their health and wellbeing. While we encourage teams to spend part of their working week in the office, we understand no one size fits all; our approach is flexible to ensure everybody feels included, accepted, and that we can win together. We’re dedicated to creating an inclusive culture and value the diversity of our people, clients, suppliers and communities, and we encourage applications from all backgrounds and sections of society. Even if you feel like you’re not an exact match, we’d love to receive your application and talk to you about this job or others at Kantar.