Music is Universal It’s the passionate and dedicated team at Universal Music who help make us the world’s leading music company. From A&R to finance, legal to digital, sales to marketing, Universal Music is the place to grow and develop your career within a truly commercial and innovative business that leads in everything it does. Everyone is welcome to apply for our roles, and we are determined to ensure that no applicant or employee receives less favourable treatment because of gender, race, disability, sexual orientation, religion, belief, age, marital status, background, pregnancy, or caring responsibilities. We also recognise the importance of diversity of thought within our teams and are fully committed to embracing the talents of people with autism, dyslexia, ADHD, and other forms of neurocognitive variation. We will always seek to make appropriate adjustments to recruitment, workplaces, and work processes to be fully inclusive to people with different needs and working styles. If you need us to make any reasonable adjustments for you from application onwards, including alternatives to the online form or to disclose a neurocognitive condition, please email UniversalMusicCareersumusic.com. The A Side: A Day in The Life Universal Music UK is looking for a data analyst to become part of our in-house creative agency The Square. The role offers a unique opportunity to join us at the start a new chapter within data & technology, where we are looking to grow & expand on the foundation of work we’ve already begun. The role is perfect for a candidate that is passionate about music, data and technology and has a thirst for acquiring, analysing and communicating knowledge through data. In a creative organisation such as ours, reducing a complex problem into something simple is key, so any experience managing clients would also be a strength. As well as being proficient in SQL, you should have a strong grasp of ETL processes, advanced troubleshooting skills, the ability to run queries efficiently and a basic knowledge of statistical modelling, This role also requires data to be reduced to simple takeaways for clients, so strong communication and data visualisation skills are also essential. Any machine knowledge a bonus. As The Square sits centrally, you’ll have a chance to work across all divisions, including frontline labels, our catalogue division UMR, our music content studio Mercury Studios and all other central agencies, as well as data teams within the business. This includes end-to-end product design from the inception of an idea to a fully working piece of technology that supports & supercharges the labels. At the heart of this role is a desire to give us a competitive edge in connecting our artists with audiences across the globe. More will be explained at Interview. Rest assured, this is an exciting role as part of an innovative new initiative within the organisation. The B Side: Skills & Experience Be Data-Driven Supporting core strategic research with data & audience insight Researching & developing data driven solutions to solve current & future business problems Utilising partner data to pull out key metrics and feeding back to the label teams Advising on data related topics to help guide or inform business decisions Sourcing, cleaning and preparing data for modelling, product creation or visualisation Developing new data sets or features that become integral to how the business operates Be Collaborative Working directly with The Square team to support artists & labels across the business Person Specification Necessary Ability to translate complicated datasets into simple, digestible suggestions Creative and innovative approach to problem-solving rather than falling on old habits Strong client engagement, management and translation from problem to solution Ability to lead data projects from ideation to realization Proficient in SQL with knowledge of querying databases accurately and efficiently Familiarity with Google Cloud Platform products (or equivalent AWS), such as BigQuery Familiarity with software development tools such as Git Strong knowledge of ETL processes Proven track record working in a data analyst or related role Background in engaging clients in a consultative or analytical capacity Experience working with development teams to productionise work Desirable Basic programming knowledge, ideally in Python Basic knowledge of machine learning concepts, techniques and their application Knowledge of music repertoire is advantageous Bonus Tracks: Your Benefits Group Personal Pension Scheme (between 3% and 9%) Private Medical Insurance 25 paid days of annual leave Interest Free Season Ticket Loan Holiday Purchase scheme Dental and Travel Insurance options Cycle to Work Scheme Salary Sacrifice Cars Subsidised Gym Membership Employee Discounts (Reward Gateway) Just So You Know… The company presents this job description as a guide to the major areas and duties for which the jobholder is accountable. However, the business operates in an environment that demands change and the jobholder's specific responsibilities and activities will vary and develop. Therefore, the job description should be seen as indicative and not as a permanent, definitive, and exhaustive statement. Job Category: Data, Analytics & Business Intelligence