Senior Data Analyst
Role details
Job location
Tech stack
Job description
You'll be joining the team behind some of the UK's biggest and most loved radio competitions, including Make Me A Winner. Sitting within the Consumer Competitions Data team you'll be responsible for reporting on and helping colleagues drive revenue delivery and operational excellence. The Difference you will make As Senior Data Analyst, you'll be the go to person for understanding how listeners and customers engage with our competitions across multiple channels - from SMS and online forms to app and web entries. Using SQL you'll turn raw entry and revenue data into clear stories about customer behaviour, preferences and trends, helping the team optimise mechanics, prize strategies, marketing and pricing. You'll work closely with product, marketing, commercial and content colleagues to make sure our competitions are driving both audience engagement and revenue. Your role
- Use SQL (e.g. Redshift) to extract and transform competition and customer data.
- Build and maintain dashboards (e.g. in Power BI/Tableau).
- Analyse competition entry behaviour across channels (e.g. SMS, online, app, web).
- Identify customer segments and trends in competition formats, prize types, price points and entry patterns.
- Build and maintain views of customer lifecycle and frequency.
- Evaluate mechanics and recommend changes to improve engagement and ROI.
- Own regular reporting on competition performance: entries, unique players, conversion,
- Design and analyse tests (e.g. different price points, copy, prize types, entry limits).
- Provide clear recommendations on what to scale, stop or refine based on data.
- Partner with SMEs in the Consumer Competitions team to understand their questions and turn them into clear analytical briefs.
- Present insights and recommendations in a straightforward, non-technical way - focusing on "so what" and "what next"., This is a full-time role, Monday - Friday, 37.5 hours a week. We also support a hybrid working model that balances working from home and our office in Manchester (Castle Quays)
Requirements
Do you have experience in Tableau?, * Significant experience as a data/BI/insight analyst using SQL.
- Strong SQL skills, comfortable working with large transactional datasets.
- Experience with at least one BI/visualisation tool (e.g. Power BI, Tableau).
- Experience analysing customer behaviour, segmentation, funnels or lifecycle metrics.
- Good grasp of statistics (e.g. A/B testing, significance, basic regression/propensity).
- Excellent communication skills - able to tell a clear story with data.