Inventory and yield analyst (12 month FTC)

Salary: £32,375

Location: London

Turn data into insight at Channel 4, shaping commercial decisions through impactful reporting and analysis.

Channel 4 creates innovative and alternative content which is distributed for free and admired globally. We are a publicly-owned, commercially-funded public service broadcaster, we don’t receive any public funding and have a remit to be innovative, experimental and distinctive.

Channel 4 Inventory & Analysis is responsible for providing reporting solutions to the Commercial team. This includes designing, building and maintaining Excel models and Power BI based reports. Further to this, I&A provide key insights to inform business decisions with a specialist understanding of the data in order to ensure the reporting is meaningful and impactful.

We therefore require a commercial analyst with good knowledge of the 4Sales business to work within the I&A team on all reporting requirements, This will involve the end to end analytics process from gathering requirements, working closely with our business intelligence team to deliver robust data models, collaborate on the design and development of reports and managing enhancement requests. This includes understanding our data in detail, implementing new reports, training report users and maintaining existing reporting solutions.

Key responsibilities

• Work with the Inventory & Yield Managers to create and maintain our suite of reports in Power BI, excel models and bespoke reporting dashboards used for the management of inventory and deal management.
• Be the go-to point of contact within the Commercial team for reporting queries in terms of design, build, implementation and training.
• Using latest visualisation and interactive software to present the data clearly and impactfully
• Always looking to evolve reporting, audit existing ones and create new ways to make reporting more relevant and useful for all commercial teams
• Communicate latest reporting developments to wider stakeholders, escalating issues to I&Y Lead and reporting to stakeholders, ensuring analysis is accurate and consistent.
• Train and empower other members of the Commercial team to contribute to projects defined by the broad commercial remit keeping best practice front of mind.
• Use domain knowledge and attention to detail to ensure reporting accuracy and consistency across reporting solutions to build confidence in user experience.
• Support people to learn, develop new tools and improve ways of reporting and consuming data analytics at 4Sales.

Knowledge, skills and experience

Essential

• Intermediate user experience of both Microsoft Excel and Power BI.
• Enthusiastic proactive approach and can do attitude to tackle complex business problems.
• Sense of urgency in responding to queries from the broader commercial team, with a naturally inquisitive mind.
• Understanding of change management and supporting change through the development of new business processes and reports.
• Good communication skills both written, verbal and presenting to groups.
• Experience of working in Advertising, demonstrate an understanding of the reporting needs of a Commercial Sales team.
• Cultivates a positive working environment by being a helpful and considerate team member who always supports their colleagues
• Curious and comfortable with adapting as projects evolve and work to deadlines.
• Proactive and able to think outside the box for new ways of doing things, making suggestions and contributing to ideas and planning.
• Positive attitude and relishes the opportunity to expand the breadth of their skills and knowledge.
• Ability to work with multiple stakeholders, understanding their needs and roles in a project and how to engage accordingly.
• Exceptionally well organised, responsive and delivery focused. Open and willing to learn from mistakes.

Desirable

• Advanced Power platform experience in Power BI, Power Apps, Flow and Forms.
• Thorough experience of TV and VoD advertising trading, selling and booking end to end process.
• Understanding of functions on Stellar or similar Airtime Sales systems.

We welcome and encourage applications from candidates who are under-represented in the creative industries.

Please make sure that you state in your application that you found this role via Creative Access.