Junior Commercial Analyst

Job Description

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.

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

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)

Just So You Know…

The company presents this job description as a guide to the major areas and duties for which the jobholder is accountable. However, the business operates in an environment that demands change and the jobholder's specific responsibilities and activities will vary and develop. Therefore, the job description should be seen as indicative and not as a permanent, definitive and exhaustive statement.

Jobcode: Reference SBJ-gm8mnx-3-137-220-120-42 in your application.