At a Glance
- Tasks: Create and maintain impactful reports using Power BI and Excel for Channel 4's sales team.
- Company: Join Channel 4, a leading media company with a focus on innovation and collaboration.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on learning and development.
- Why this job: Make a real impact by optimising inventory strategies and enhancing reporting solutions.
- Qualifications: Intermediate skills in Excel and Power BI; experience in advertising is a plus.
The predicted salary is between 35000 - 45000 £ per year.
The Ad Operations team is responsible for the creation and delivery of maximum revenue across all delivery methods of viewing across C4’s Sales portfolio. The team is required to deliver exceptional levels of service to Sales and our customers, in addition to conceiving and executing innovative methods of creating value through systems, working practices and new trading opportunities.
The Inventory & Analysis team is specifically responsible for business modelling and detailed reporting across both VoD and Linear inventory at Channel 4 Sales, leading the strategy for inventory product mix to maximise and increase yields across the C4 portfolio. The monitoring and proactive control of the on-going delivery of agency deals, from both a cost and quality perspective, is essential to maximising revenue for Channel 4 and maintaining constructive relationships with agencies and advertisers.
JOB PURPOSE
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, collaborating 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.
ESSENTIAL EXPERIENCE & SKILLS
- 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, demonstrating 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 EXPERIENCE & SKILLS
- 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.
Inventory & Yield Analyst employer: Channel 4
Channel 4 is an exceptional employer, offering a unique opportunity to influence the future of public service broadcasting in the UK. With a commitment to diversity and inclusion, employees are encouraged to bring their authentic selves to work, fostering a vibrant and collaborative culture. The roles of Non-Executive Directors not only provide a platform for impactful decision-making but also offer significant professional growth opportunities within a high-profile organisation dedicated to creative innovation and audience engagement.
StudySmarter Expert Advice🤫
We think this is how you could land Inventory & Yield Analyst
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Channel 4!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Inventory & Yield Analyst at Channel 4.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Channel 4.
✨Apply Directly through Our Website
When you find a suitable opening like Inventory & Yield Analyst at Channel 4, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Inventory & Yield Analyst
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Channel 4, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Channel 4. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Channel 4
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Channel 4!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
