Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome jobs for you.

Data Cleansing and Coding Analyst - Client Experience

Learn more about Kantar


Data Cleansing and Coding Analyst - Client Experience

Norwalk, CT
Full Time
  • Responsibilities

    Job Details

    Kantar is a specialist growth consultancy. With over 1,000 analysts, thought leaders, software developers and expert consultants we help clients develop and execute brand, marketing, retail, sales and shopper strategies to deliver growth. Kantar owns market leading assets including PoweRanking, GrowthFinder, Global Monitor, RetaiI IQ, RichMix, XTEL and Marketing, Insights and Purpose 2020. We track 1200 retailers globally, have purchase data on over 200 million shoppers and forecast social, cultural and consumer trends across the world.


    As a Data Cleansing and Coding Analyst on the Client Experience team you will help manage, clean, and analyze large amounts of data in a team-based setting, providing support to internal teams and clients. Primary responsibilities include the download, manipulation, cleaning, management, and analyzing of data within Excel and Microsoft SQL Server Management Studio. Additionally, you will be tasked with using proprietary tools to develop historical analyses of categories and products within a retail environment to better determine future performance. Timely completion of these tasks is necessary to our client deliverables and you will be critical in ensuring delivery.


    • Manipulate, manage, and segment data – involves gathering data from various sources on a monthly basis and tagging items according to attribute characteristics to ensure they can be accurately recognized by our proprietary Perfect Category software platform
    • Load, clean, and query data within Microsoft SQL Server Management Studio
    • Use proprietary tools to generate regression models measuring historical category performance for use within the Perfect Category platform
    • Quality Assurance testing to ensure the integrity of the data outputs and the tools we utilize
  • Qualifications


    • Experience in Excel, Microsoft SQL Server, and statistics/regression modeling preferred but not necessary
    • Strong interest in business, shopper marketing, consumer goods, and retail
    • Detail-oriented with strong analytical abilities and ability to manage multiple workstreams and deadlines
    • Logical thought process and ability to effectively communicate information verbally and in writing
    • Problem solving and critical thinking skills


    At Kantar we have an integrated way of rewarding our people based around a simple, clear and consistent set of principles. Our approach helps to ensure we are market competitive and also to support a pay for performance culture, where your reward and career progression opportunities are linked to what you deliver.We go beyond the obvious, using intelligence, passion and creativity to inspire new thinking and shape the world we live in. Apply for a career that’s out of the ordinary and join us.

    At Kantar, the diversity of our employees provides a richer environment for our employees and broader depth and breadth of thinking for our clients. Kantar is committed to inclusion and diversity, therefore we welcome applications from all sections of society and do not discriminate on the basis of age, race, religion, gender, pregnancy, sexual orientation, gender identity, disability, marital status or any other legally protected characteristics.

    PRIVACY DISCLOSURE: Please note that by applying to this opportunity you consent to the personal data you provide to us to be processed and retained by The Kantar Group Limited (“Kantar”). Your details will be kept on our Internal ATS (Applicant Tracking System) for as long as is necessary for the purposes of recruitment, which may include your details being shared with the hiring manager(s) and for consideration for potential future opportunities by Kantar and its affiliate Kantar group companies. For full details of our privacy policy please visit

  • Industry
    Market Research
  • About Us

    Kantar is the world’s leading data, insights and consulting company. We help clients understand people and inspire growth. We have a complete, unique and rounded understanding of people around the world: how they think, feel and act, globally and locally in over 90 markets. We don’t just help clients understand what’s happened, we tell them why and how they can shape the future.