Data Analyst, Universal Music Group

• Proficient in SQL with knowledge of querying databases accurately and efficiently
• Strong knowledge of ETL processes
• Familiarity with Google Cloud Platform products (or equivalent AWS), such as Big Query
• Familiarity with software development tools such as Git
• Basic programming knowledge, ideally in Python
• Ability to lead data projects from ideation to realization
• Basic knowledge of machine learning concepts, techniques and their application
• Creative and innovative approach to problem-solving
• Knowledge of music repertoire is advantageous
• A proven track record in an SQL developer or related role
• Background in engaging clients in a consultative or analytical capacity
• Experience working with development teams to productionise work
• Be strategic
• Researching and developing data driven solutions to solve current and future business problems
• Supporting the core strategic unit through data research and audience insights around our artists
• Developing new data sets or features that become integral to how the business operates
• Strive to cultivate the desire to give us a competitive edge in connecting our artists with audiences across the globe
• Be operational
• Building, refining and improving SQL pipelines that feed directly into data dashboard or tools
• Sourcing, cleaning and preparing data for modelling, product creation or visualisation
• Be informative
• Utilising partner data to pull out key metrics and feeding back to the labels
• Advise on data related topics to help guide or inform business decisions

Desirable

• 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 and technology, where we are looking to grow and expand on the foundation of work we’ve already begun
• 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 and supercharges the labels