Analyst

| Santa Monica

Are you interested in working for the music industry? Would you like to help develop unique and clever ways to drive the music industry into the future using data driven strategies and insights?

Universal Music Group is looking for an Analyst to help brainstorm, create, and implement critical business solutions for a wide variety of stakeholders throughout the organization. These stakeholders would include Senior Executives, as well as individuals within our Global Digital Strategy, Global Streaming Marketing, Business Development, Global Communications, Commercial Partnership, and Finance units.

The ideal candidate should be well-versed in data analysis and financial modelling, with a solid understanding (or an eagerness to learn) the business models that are currently revolutionizing digital and subscription-based media. Candidates should be complete wizards in Excel (including VBA / Macros), PowerPoint, SQL, Tableau, DOMO, or other data manipulation / visualization platforms. 

This candidate should also have a demonstrated ability to manage client or audience requests in a professional manner, communicate findings to a variety of different audience types (from Senior Executives down to fellow Analysts), and work in project teams to solve interesting problems in a consultative fashion.

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 partner negotiations, executive presentations, label meetings, global communications, etc.
  • 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
  • Identify user / partner trends, including but not limited to user engagement, listening habits, conversion, retention, monetization per stream / user, genre insights, among many others
  • Present overall findings to executives throughout the company in a clear and concise manner
  • Job Requirements:

    Skills/Abilities:

  • Passion and curiosity for music and the data that is used within the industry
  • 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
  • Experience:

  • 2 – 3 years of work experience in management consulting, investment banking, or similar role
  • Experience managing and engaging with clients in a consultative or analytical capacity
  • Experience working with analytical tools including, but not limited to Excel, VBA, Tableau, DOMO, BigQuery, etc.
  • Education:

    • BS required 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 provide 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 Group49 open jobs
    All Jobs
    Finance
    Data + Analytics
    Dev + Engineer
    HR
    Internships
    Legal
    Marketing
    Operations
    Product
    Project Mgmt
    Sales
    Content
    Marketing
    new
    Santa Monica
    Data + Analytics
    new
    Santa Monica
    Operations
    new
    Santa Monica
    Data + Analytics
    new
    Santa Monica
    HR
    new
    Santa Monica
    Finance
    new
    Santa Monica
    Operations
    new
    Los Angeles
    Data + Analytics
    new
    Los Angeles
    Internships
    new
    Los Angeles
    Internships
    new
    Santa Monica
    Internships
    new
    Hollywood
    Finance
    new
    Santa Monica
    Data + Analytics
    new
    Los Angeles
    Operations
    new
    Santa Monica
    Content
    new
    Santa Monica
    Operations
    new
    Santa Monica
    Marketing
    new
    Santa Monica
    Sales
    new
    Santa Monica
    Operations
    new
    Santa Monica
    Marketing
    new
    Hollywood
    Operations
    new
    Los Angeles
    Product
    new
    Los Angeles
    Finance
    new
    Santa Monica
    Sales
    new
    Santa Monica
    Operations
    new
    Santa Monica
    Marketing
    new
    Santa Monica
    Data + Analytics
    new
    Santa Monica
    Marketing
    new
    Hollywood
    Data + Analytics
    new
    Los Angeles
    Operations
    new
    Los Angeles
    Content
    new
    Santa Monica
    Content
    new
    Santa Monica
    Marketing
    new
    Santa Monica
    Operations
    new
    Santa Monica
    Operations
    new
    Hollywood
    Developer
    new
    Santa Monica
    Finance
    new
    Los Angeles