Junior Data Analyst

At TRP Research we combine deep media and consumer knowledge with new and existing data sources to produce research our clients act on. Our TRP Consult team works with some of the world’s largest media and technology companies, helping them make evidence-based, strategic decisions.

Increasingly, that work is built on single-source consumer data: a UK panel that links what people watch, hear and see with what they actually buy, verified through receipts. The data arrives raw, large and often unstructured. Turning it into something a client can trust takes engineering as much as analysis.

You’ll join a small, senior team working directly with our VP Research and Research Director on this work. Much of what we do hasn’t been done before, so there isn’t always a manual. You’ll help write it.

What you’ll be doing:

• You’ll take ownership of the processes that move our panel data from raw outputs to finished client deliverables and help shape new ones as projects evolve. That will include:
• Querying large datasets in a cloud data warehouse to extract and validate the data each project needs
• Building and maintaining Python pipelines (pandas, regex, rule-based matching) that clean and structure messy inputs
• Using large language model APIs (for example Gemini or Claude) within those pipelines to classify and match data, with guidance on their limitations and where human checking is needed
• Linking datasets together cleanly, including deduplication and verification
• Supporting the team’s analysis, including exposed-versus-unexposed comparisons and campaign effectiveness measures
• Producing clear, accurate outputs that feed into dashboards, presentations and charts built by the wider team
• Documenting processes so they can be rerun and handed over, and automating repeat tasks over time
• You’ll be using AI coding assistants daily as part of this work, and we’ll expect you to use them well: to move faster, while still checking and understanding every output.

The work is varied and often undefined at the start. One week you might be rebuilding a cleaning step; the next you’re working out how to measure something a client has never measured before. As you grow, you’ll take on more of the project lifecycle, from scoping through to presenting findings to clients. We’ll train you, and several of our current senior managers grew into their roles this way.

• Looking for an early-career role. Ideally, someone with around 1-2 years’ experience in a data or analytics role (or a strong graduate with demonstrable SQL and Python), who wants to grow into a more senior data role with us.
• Practical SQL: comfortable with joins and aggregations, and checking that results make sense
• Working Python knowledge for data processing, and the ability to write and debug scripts that someone else can run
• Experience cleaning messy data, and a feel for when it “looks weird” and the curiosity to find out why
• The ability to work things out from scratch: breaking an undefined problem into steps, and trying sensible approaches
• Good judgement about accuracy: knowing when an automated output needs checking
• Clear written and verbal communication, including the ability to explain technical work in plain English to non-technical colleagues, in writing and in conversation
• The ability to manage your own workload

In addition, we’re looking for someone who:

• Is curious about the “why” behind consumer behaviour, not just the “how” of the code
• Uses their initiative and is comfortable without a fixed playbook
• Is adaptable: what you’re working on next week may be unknown, or change at short notice
• Has excellent attention to detail
• Enjoys learning new tools and sharing what they’ve learned with the team

It would be great if you also have:

• Experience with AWS (Athena, S3, Glue) or another cloud data platform
• Experience calling LLM APIs from code
• Data visualisation or dashboard skills
• Familiarity with consumer panel, purchase or media audience data
• Experience with experimental methods (test vs control, incrementality, lift measurement)
• Experience in building simple front-ends or dashboards (for example HTML/JavaScript, or a BI tool)
• A background in market research, media or advertising

We pride ourselves on a flexible, supportive working environment. Our offices are in Taunton, and you’re welcome to work some or all of the time from the office, bearing in mind that some things are better done in person and certain activities will require you to be there.

• Our annual profit share bonus scheme offers all eligible employees the opportunity to share in company success.
• Our in-house Development Scheme will help shape your career development within TRP Research and give you a tailored path towards progression.
• You will be entitled to 22.5 days of holiday plus UK bank holidays, increasing to a maximum of 27.5 with each year of service. We also offer holiday flexibility, allowing you to carry holiday from one Financial Year to another and purchase up to 10 extra holiday days.
• In addition to your statutory entitlement to family leave, we offer new parents 6 weeks of paid leave at 70% of their average weekly salary.
• On successful completion of a minimum 3-month probation period you will also be entitled to join our Private Healthcare scheme which includes travel insurance and free eye tests, and a cash back allowance to help you pay for glasses, lenses and dental treatment.
• Our Bicycle and Tech Purchase schemes allow you to buy products via salary sacrifice in a tax efficient way over a twelve-month period. Payroll Giving allows you to make charitable donations.
• We recognise that you may prefer to split your working week between our offices and your home, and encourage everyone to engage in a discussion with their manager about their preferences, * Casual dress
• Company events
• Company pension
• Cycle to work scheme
• Enhanced maternity leave
• Enhanced paternity leave
• On-site parking
• Private dental insurance
• Private medical insurance
• Profit sharing
• Sick pay
• Work from home