Magnet.me  -  The smart network where hbo and wo students find their internship and first job.

The smart network where hbo and wo students find their internship and first job.

This opportunity has expired. It is therefore no longer possible to like or apply.

See similar opportunities instead

Junior Commercial Analyst

Posted 24 Mar 2024
Work experience
1 to 3 years
Full-time / part-time
Full-time
Job function
Degree level
Required language
English (Fluent)

Your career starts on Magnet.me

Create a profile and receive smart job recommendations based on your liked jobs.

The A Side: A Day in The Life

The successful candidate will work within a team dedicated to providing first class commercial intelligence. The role requires the delivery of trend and performance analysis across both the Market and Business Partners. The successful candidate will also be responsible for delivering ad-hoc project work and supporting the wider Commercial Affairs team.

In all cases, the analysis delivered should culminate in key learnings, and where appropriate strategic recommendations, always with the intention of adding value to the business – Analysis In Action.

To that end, the role requires a keen commercial acumen, alongside strong analytical and inter-personal skills, project management and a proactive approach to problem solving.

The successful candidate must have advanced knowledge of SQL and is preferred to have knowledge of the music industry.

The B Side: Skills & Experience

Be Collaborative

  • Serve as support to the wider Commercial Affairs and Commercial Analytics team, reporting into the Senior Analyst
  • Work with the other members of the team, or other departments in the Commercial Division, to support the analytical needs of the business
  • Maintain and build relationships with other analysts in the business, to maximise shared learning

Be Commercial

  • Deliver established market, channel and partner analysis (This can cover all aspects of the business from demographic trends to revenue tracking)
  • Keep abreast of new technological, Business Partner and industry developments with a view to how they impact the analysis undertaken by then team

Be Organised

  • Create and maintain internal dashboard and external-facing reports
  • Deliver ad-hoc project work on the market, partners, or broader strategic questions
  • Query data using SQL and other tools
  • Present data in an understandable way

Person Specification

Necessary

  • Highly numerate and results-orientated with a clear focus on high quality, attention to detail, and profit maximisation
  • Excellent IT skills, with experience including:
  • Advanced SQL (or similar)
  • Advanced Excel (Array functions / Macros or similar)
  • Google Products (Data Studio, Big Query, Cloud Services or similar)
  • Data Transformation Services (DOMO/Business Intelligence, MicroStrategy or similar)
  • Presentation Tools (Keynote, PowerPoint, Canva or similar)
  • Proactive and a keen problem solver
  • Proven ability to make rational judgement from the available information, by demonstrating an inquisitive and analytical approach
  • Diligent and reliable, capable of managing and delivering on multiple projects simultaneously and to a high standard, both autonomously and as part of a team
  • Able to work on their own as well as part of a team and with management at all levels of the business
  • Very familiar with current issues and trends; stays ahead of the game and can produce innovative ideas, approaches, insights and identify opportunities by applying business and industry knowledge
  • Technically confident; ideally with a personal interest in new media, digital and all technology; understands key terminology and communicates effectively with experts and novices alike
  • Confident in presenting to both small and large groups

Desirable

  • Beginner-level experience with Python/r is a bonus

Bonus Tracks: Your Benefits

  • Group Personal Pension Scheme (between 3% and 9%)
  • Private Medical Insurance
  • 25 paid days of annual leave
  • Interest Free Season Ticket Loan
  • Holiday Purchase scheme
  • Dental and Travel Insurance options
  • Cycle to Work Scheme
  • Salary Sacrifice Cars
  • Subsidised Gym Membership
  • Employee Discounts (Reward Gateway)

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…


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.

Entertainment
London
7,000 employees