Junior Data Analyst
Role Overview
Join TRP Consult, a small senior team working on consumer panel data that links what people watch, hear and see with verified purchase information.
Turn raw, large and often unstructured data into trusted research outputs for media and technology clients.
The work is varied and may involve developing approaches where no established manual exists.
Key Skills for This Role
Full Job Posting
Role overview
Join TRP Consult, a small senior team working on consumer panel data that links what people watch, hear and see with verified purchase information.
Turn raw, large and often unstructured data into trusted research outputs for media and technology clients.
The work is varied and may involve developing approaches where no established manual exists.
Compensation
- Salary is £30,000 full-time equivalent.
Workplace and hours
- Hybrid role requiring at least two days each week in the Taunton office.
- Permanent role, ideally full-time at 37.5 hours per week; fewer hours across five days may be considered.
- Planned start date is January 2027.
Responsibilities
- Own and develop processes that turn panel data into client deliverables.
- Query and validate large cloud warehouse datasets; build Python pipelines to clean and structure inputs.
- Use LLM APIs for classification and matching, with appropriate human checking.
- Link, deduplicate and verify datasets; support campaign effectiveness analysis.
- Prepare accurate outputs for dashboards, presentations and charts; document and automate repeatable work.
- Use AI coding assistants responsibly and, as experience grows, contribute to project scoping and client presentations.
What the role requires
- Ideally around 1–2 years of data or analytics experience, or graduate-level potential with demonstrable SQL and Python.
- Practical SQL joins and aggregations; Python scripting and debugging; experience cleaning messy data.
- Problem-solving, accuracy judgment, clear communication and workload management.
- Curiosity about consumer behavior, initiative, adaptability, attention to detail and willingness to learn and share tools.
Advantageous experience
- AWS services such as Athena, S3 or Glue, or another cloud data platform; calling LLM APIs from code.
- Data visualization, dashboards, consumer panel or media audience data, and experimental methods.
- Simple front ends or dashboards, such as HTML/JavaScript or a BI tool; market research, media or advertising background.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career