Input and Validation Specialist

Role Purpose

Each of Ad Intel Internationals Clients’ services are customised. No service is the same as another. The Input and Validation Expert is the point of contact within Operations for any technical requirements in regards to Clients (BAU or FTD), new data and any User Acceptance Testing to be carried out for a process (Client or Internal).

This includes support for both the Nielsen & TCS Teams and also transfer of non-technical language from Operations to Application Development to resolve an issue. It is a key skill as they need to have technical knowledge of the database backend and have SQL developer experience to be able to pull and read the data from the database to assist other team members who have less technical expertise.

The candidate must also be able to speak with stakeholders in daily stand up calls and have experience working in Agile developments taking part in sprint planning processes and taking on work to support the business in these phases.

The specialist will also be responsible for testing new data from all of our key suppliers making sure it fits the requirements for data loading, they will need to understand the formats we have and have experience in handling large data files often in excess of 600,000 rows or more and checking not only format but also the content that fits with the Ad Intel International backend and the 7 different data formats the data can be sent in.

Understanding of how data lakes work and how data is set up and pulled is required as in Ad Intel this is a growing source of where data is coming in from.

This can also involve conversations via video call with suppliers who are unable to produce our format so are giving support on what's needed to correct using their experience in relational databases.

In Ad Intel International the client has two reporting databases. Within the role of an Input and Validation specialist they will need to set these up for clients to use. They must be competent in using logical filters, AND & OR expressions using this for multiple conditions to ensure correct data is given to the client. Experience is essential in logical filtering for this role.

Key Skill Requirements

• Clear & confident communication skills are essential.This role requires frequent interaction with colleagues locally and internationally as well as our data suppliers.
• Ability to work in Agile environment, liaising with tech rolling out new features to existing platforms whilst also carrying out User Acceptance & Regression testing so it fits the purpose for the end user
• Participating in daily scrum meetings and presenting work in fortnightly sprint reviews.
• Collaborating with Technology bringing ideas from the operations team and translating terminology between the two teams to aid both.
• Ability to work in a pressured environment
• Comfortable working within a team or on their own.
• Due to the nature of the role someone that is organized, analytical, with outside of the box thinking solves problems.
• Competent with SQL programming and relational databases. This is used daily to be able to query data.
• Able to work with different data platforms including Datalakes and Amazon S3 Buckets.

Personal Attributes

• Good organizational skills with the ability to prioritize work effectively.
• Strong character
• Excellent Communication written and verbal
• Flexibility acting with speed and purpose.
• Working as part of a team
• Attention to detail

Key tasks and responsibilities:

• Workflow Management

• Data testing of new data from existing suppliers and new suppliers

• Set up new countries on Oracle for the TCS team to use

• Collaborate with the Tech Ops team to undertake any User Acceptance Testing that is required that fits into the Ad Intel International Scope

• Add new clients onto W+/Portfolio delivery platform

• Work with the coordinators and managers in the team to troubleshoot and streamline processes where applicable

• Where required, participate in giving feedback to the Client Liaisons on feasibility requests from commercial.

• Be a support for the Ops team on technical queries

• Assist the TCS team with loading questions

• Effectively escalate major issues to the Operations manager

• Training of peers and TCS Team.

Application Testing

• Where applicable take part in User Acceptance Testing to check work carried out by Tech Ops is suitable for the operations team

Continuous Improvement

• At Nielsen we always strive to better our team members in order to be able to improve our quality and efficiency for our clients.

IT Issues

• Escalate IT problems effectively and efficiently to minimize impact on the team and clients.

New Starter Induction

• Assist with training helping new starters learn their role

Scope:

• Key Interface Relationships:
• Commercial Team
• Ops
• Local Suppliers
• Application Development Team
• TCS

Number of employees managed - None

Number of third party employees (contractors/outsourced) managed - None

This role is global/regional/local - Mix of local and global clients

Other factors indicating size / complexity of role:

• Mix of local and global clients
• Knowledge of Ad Intel International coverage and category structure
• Knowledge of relational databases & SQL.
• Experience of using data lakes and Amazon S3 Buckets
• Agile Working