Universal Music Group (UMG) is the world leader in music-based entertainment, with a broad array of businesses engaged in recorded music, music publishing, merchandising and audiovisual content in more than 60 countries. Featuring the most comprehensive catalog of recordings and songs across every musical genre, UMG identifies and develops artists and produces and distributes the most critically acclaimed and commercially successful music in the world. Committed to artistry, innovation and entrepreneurship, UMG fosters the development of services, platforms and business models in order to broaden artistic and commercial opportunities for our artists and create new experiences for fans.

Universal Music Group's labels include A&M Records, Astralwerks, Blue Note Records, Capitol Christian Music Group, Capitol Records, Capitol Records Nashville, Caroline, Decca, Def Jam Recordings, Deutsche Grammophon, Disa, Emarcy, EMI Records Nashville, Fonovisa, Geffen Records, Harvest, Interscope Records, Island Records, Machete Music, MCA Nashville, Mercury Nashville, Mercury Records, Motown Records, Polydor Records, Republic Records, Universal Music Latino, Verve Label Group, Virgin Records, Virgin EMI Records, as well as a multitude of record labels owned or distributed by its record company subsidiaries around the world. UMG's catalog is marketed through two distinct divisions, Universal Music Enterprises (in the U.S.) and Universal Strategic Marketing (outside the U.S.).

UMG also includes Universal Music Publishing Group, one of the industry's premier music publishing operations worldwide and Bravado, the leading provider of consumer, lifestyle and branding services to recording artists and entertainment brands around the world. Universal Music Group is a Vivendi company.

As a part of the Research, Reporting & Analytics Group at Interscope Capitol Labels Group, this person will work with the team to provide data and detailed analysis with a focus on artist consumption, release, account, consumer and revenue strategies.The analyst will need to be a proven self-starter, solutions based creative thinker with a hunger to constantly learn and evolve strategies associated with the company’s artists and commercial partners.

The analyst will be required to dive deep into performance across streaming platforms with a requirement to make recommendations based on compelling analyses, insights and big data queries. These recommendations will be used by management and senior executive team to make informed business decisions.

The ideal candidate should be well-versed in data analysis. Candidates should have advanced skills in Excel, and experience with SQL, Tableau, Alteryx, or other data manipulation / visualization platforms.

How You'll CREATE

• Deliver data-driven solutions and recommendations to executives and necessary parties that incorporate rigorous research and analysis
• Develop dynamic / automated models to help key stakeholders with business decisions
• Create SQL scripts in order to extract necessary data from files that could be greater than 100 TB in size within Google BigQuery or other SQL platforms, and build visualizations in Tableau, Alteryx, and various other visualization tools to present findings in a visually compelling way
• Identify user/partner/ track/album/market trends
• Present overall findings to executives throughout the company in a clear and concise manner
• Research & build customized reports based on financial and marketing data.
• Build, develop and maintain various partner, consumer behavior, and consumption trend projects with ongoing summaries and recommendations.
• Monitor and understand key performance indicators relating to our streaming partner’s consumer behavior and consumption trends to integrate into data analysis.
• Help develop and review methodology for cross-departmental reporting tools.
• Other duties as assigned.
• Passion and curiosity for music and the data that is used within the industry, preferably with an-depth knowledge of current music industry trends including key account, consumption pattern shifts, and the impact/variety of social media.
• Ability to query our databases (using platforms such as BigQuery) accurately and efficiently using SQL
• Advanced level Excel skills, with the ability to develop dynamic models using named ranges / formulaic references
• Understanding of API usage for importing data for analysis
• Understanding of TikTok and social media trends
• Familiarity with statistical concepts and tools, along with the ability to use them effectively in analyses
• Ability to visualize data within Alteryx, Tableau, or other data visualization platforms. Experience with Alteryx Designer a plus.
• Adept in distilling large amounts of data into concise, actionable summaries.
• Highly organized and detail-oriented team player.
• Ability to present findings in a visually compelling and articulate manner.
• Self-sufficient with the confidence to independently pursue information.
• Ability to thrive in fast paced environment, manage multiple tasks at once and work to deadlines

Experience

Bring Your VIBE:

• 1 year of work experience in data analysis, management consulting, entertainment industry analysis, or similar role. Music Industry preferred but not required.
• Experience working with analytical tools including, but not limited to Excel, Tableau, BigQuery, Alteryx, etc.

Education

• BS in Business Administration, Accounting, Computer Science, Mathematics, or a similarly quantitative degree