Junior Analyst
Universal Music Group
Santa Monica, CAThis was removed by the employer on 10/1/2019 9:24:00 AM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the Marketing Category
Browse the Music Category
Search for Junior Analyst jobs in Santa Monica-CA
Search all Junior Analyst postings
Full Time Job
Description
As a part of the Research, Reporting & Analytics Group at Interscope Records, 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 junior 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 junior 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, DOMO, or other data manipulation / visualization platforms.
What Bandmember Are You?
• 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,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.
How You Will Rock Your Role:
• 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 Alteryx, Tableau, DOMO, 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
• 1– 2 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, Tableau, BigQuery, Alteryx, etc.
• BS in Business Administration, Accounting, Computer Science, Mathematics, or a similarly quantitative degree
What’s in it For You?
• Competitive Compensation Package including Salary, Benefits and Generous 401k Savings Plan
• Paid Time Off – Paid Holidays, “Gift Week”, Summer Fridays
• Student Loan Repayment Assistance
• Employee Developmental Support
• Annual Gym Reimbursement Package
• Pet Insurance, plus much more!
Universal Music Group is an Equal Opportunity Employer