Data Analyst Apprentice
At Warner Music UK they are passionate about providing opportunities and committed to developing new talent. They are an organisation of music lovers who are innovative and forward thinking - priding ourselves on their diverse, exciting and stimulating working environment.
Their team of 5, handles the processing and invoicing of Warner's worldwide digital sales (excluding the US - that's handled across the pond), as well as reporting these sales to their worldwide affiliates for onward royalty payment to their artists. They work very closely with a number of other departments, namely Royalties, Business Development, Business Affairs and International Finance.
- Processing the detailed streaming and download reports from our service providers (from the likes of Spotify, Apple, Youtube, Amazon, Deezer etc.).
- Loading of sales into our bespoke digital sales system.
- Investigation and resolution of any loading errors.
- Assisting the team with ensuring sales reported match up to the cash we receive.
- Liaising directly with these providers on any issues.
- Clearing of sales which are held in suspense due to error.
- Monitoring suspense levels to ensure they don't get too high, keeping the team up to date.
- Providing assistance to the technical team with the current project to upgrade our sales system.
- Analysis of sales data as and when required by the team.
- Proactively looking for ways we can do anything more efficiently or faster.
- Helping Warner's worldwide affiliates with any queries they may have.
- Undertaking ad hoc errands for the team as directed by the Senior Director - Digital Financial Systems or the Digital Systems Finance Manager.
- Ability to work independently and maintain a high degree of self-motivation
- Team work skills
- Organisational skills
- Good written and oral communication skills
- High proficiency in English; both spoken and written
- Strong Microsoft Excel skills and IT acumen essential
- Experience or familiarity using advanced text editors or working with databases (Notepad++, UltraEdit, Microsoft Access, TOAD, OracleDB) would be very helpful but by no means essential
- Adaptability and flexibility
- Positive attitude and energy
- A creative and enthusiastic individual with an interest in technology and music
- Someone with proven IT, Mathematical or Financial skills (e.g. great A-levels in Maths, IT or Economics, or equivalent previous work experience) as well as eagerness to learn
- Somebody comfortable working with multiple currencies
- Someone organised, pro-active and hard-working, who can manage their own workload
- A positive ‘can-do' attitude (particularly with technology) - a pro-active team-player, who Is ready to muck in with a busy team on wide variety of tasks, big and small
5 GCSEs or equivalent (ideally A* - C) including English and Maths.Future prospects Tech and digital professionals in London earn an average salary of £52,500 per year, so this Apprenticeship could be the start of a very promising and profitable career. AFTER THE APPRENTICESHIP Over 90% of our Apprentices move on to permanent full time employment in the tech industry. There are also opportunities to extend your training with a higher level Apprenticeship programme. Just IT have already helped over 1000 young people kick-start their tech and digital careers with an Apprenticeship. Things to consider The current National Minimum Wage for an apprentice is £3.50 an hour. This rate applies to apprentices under 19 and those aged 19 or over who are in their first year. Apprentices must be paid at least the minimum wage rate for their age if they are aged 19 or over and have completed their first year. The minimum wage rates are £5.60 an hour for 18-20 year olds and £7.05 for anyone aged 21 and over. Apprentices are paid for their normal working hours and training that's part of their apprenticeship (usually one day per week).