Junior Analyst

| Santa Monica

We are UMG, the Universal Music Group. We are the world's leading music company. In everything we do, we are committed to artistry, innovation and entrepreneurship. We own and operate a broad array of businesses engaged in recorded music, music publishing, merchandising, and audiovisual content in more than 60 countries. We identify and develop recording artists and songwriters, and we produce, distribute and promote the most critically acclaimed and commercially successful music to delight and entertain fans around the world.

As a part of the Research, Reporting & Analytics Group at Interscope Records, this person will work with the team to provide 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, DOMO, or other data manipulation / visualization platforms.

Job Functions:

  • 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 BigQueryor other SQL platforms, and build visualizations in Tableau, DOMO, and Google DataStudio 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.
  • Analyze Brand Partnership & Advertising initiatives with data organization and analysis
  • Build, develop and maintain various partner, consumer behavior, and consumption trend projects with ongoing summaries and recommendations to constantly evolve the company.
  • 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.

Job Requirements:

Skills/Abilities:

  • 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
  • Familiarity with statistical concepts and tools, along with the ability to use them effectively in analyses
  • Ability to visualize data within Tableau, DOMO, or other data visualization platforms
  • 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:

  • 2 – 3 years 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, VBA, Tableau, DOMO, BigQuery, Alteryx, etc.

Education:

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

Universal Music Group is an Equal Opportunity Employer.

Disclaimer

This job description only provides an overview of job responsibilities that are subject to change.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • jQueryLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • AccessDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • SAP HANADatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • DrupalCMS
    • WordpressCMS
    • SalesforceCRM
    • Constant ContactEmail

Location

UMG IT is primarily based in Woodland Hills, a neighborhood bordering the Santa Monica mountains in the San Fernando Valley region of Los Angeles

An Insider's view of Universal Music Group

What’s the vibe like in the office?

Everyone is hard working but it’s still a pretty relaxed and friendly environment. If you need any help people are always ready to make time. Between the conference room with all over music related decorations, big lunch room with table-football and arcade games and a very casual dress code, the overall vibe is really chill.

Laurent Burte

Enterprise Portfolio Management Project Manager

How do you collaborate with other teams in the company?

Our team serves departments across the company by providing feedback and best practices on software asset management. We get to work with a lot of different teams which is really interesting.

Ashia Coleman

Junior Windows Systems and Application Administrator

What makes someone successful on your team?

Our team relies on the ability to have quick and meaningful communications, sharing of ideas in a constructive way and working closely as a whole team. You also need to be interested in always learning. Technology never stands still and neither does this team.

Todd Hancsicsak

Director, Rights & Repertoire Technology

What does your typical day look like?

There is no typical day at UMG, which is a good thing! I get an opportunity to work with numerous individuals within IT and the business on a variety of global projects. Having the opportunity to work with so many talented people globally and continuously learn and contribute to our business is very exciting.

Gauri Gohokar

Project Manager

What are Universal Music Group Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Parking
Fitness Subsidies
More Jobs at Universal Music Group54 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Project Mgmt
Sales
Content
Data + Analytics
new
Santa Monica
Marketing
new
Hollywood
Marketing
new
Hollywood
Marketing
new
Santa Monica
Content
new
Santa Monica
Project Mgmt
new
Los Angeles
Marketing
new
Hollywood
Project Mgmt
new
Los Angeles
Marketing
new
Los Angeles
Operations
new
Hollywood
Content
new
Santa Monica
Operations
new
Los Angeles
Content
new
Santa Monica
Operations
new
Santa Monica
Sales
new
Santa Monica
Sales
new
Santa Monica
Marketing
new
Santa Monica
Marketing
new
Santa Monica
Operations
new
Los Angeles
Marketing
new
Hollywood
Marketing
new
Hollywood
Data + Analytics
new
Los Angeles
Operations
new
Los Angeles
Marketing
new
Santa Monica
Marketing
new
Santa Monica
Design + UX
new
Hollywood
Finance
new
Santa Monica
HR
new
Santa Monica
Finance
new
Los Angeles
Operations
new
Santa Monica
Internships
new
Los Angeles
Internships
new
Los Angeles
Operations
new
Los Angeles
Data + Analytics
new
Los Angeles
Internships
new
Santa Monica
Internships
new
Los Angeles
Internships
new
Hollywood
Operations
new
Santa Monica
Data + Analytics
new
Santa Monica
Operations
new
Santa Monica
Operations
new
Los Angeles