Junior Commercial Analyst INTERNAL CANDIDATES ONLY

  • 22.04.2024
  • London, England, United Kingdom
  • Advertising

Job description

Junior Commercial Analyst (up to £32,500)


At Immediate, we’re home to some of the biggest and most loved consumer brands in the UK, including Radio Times, Good Food and Gardeners World. Our trusted, quality content reaches millions of people a month across digital, print, video, podcasts, apps and live events.

We’re the destination for people looking to get more from the things they love. We help inspire them; deepening their knowledge, skills and fuelling their passions, to enjoy more of what life has to offer.

Whether it’s the big things, or the little things; from reaching fitness goals to savouring good food, cultivating outdoor, or indoor, spaces, or enjoying the latest TV sensation with loved ones – we help bring our audiences joy!

About the role

As a Junior Commercial Analyst, you will join a dynamic and commercially focused data team that is increasingly using big data as a core driver of digital advertising revenue. You will be using key data tools to extract, analyse and visualise insights into our advertising business, feeding this back to senior analysts and managers as well as key stakeholders and actioning findings. The ability to offer actionable insight is also crucial in driving data-backed decisions.


As a Junior Commercial analyst you will;

  • Utilise Salesforce CRM-A our business intelligence tool, harnessing Einstein GPT/AI for advanced dashboard creation and predictive analysis, driving strategic decision-making.
  • Provide monthly sales reporting to management team, providing insight on market-share, yield, revenue, and key client activity as well as monitoring KPIs such as Page Views, CTR & STR
  • Provide ad hoc reporting and analytical support across the department upon request.
  • Support new ad product initiatives by providing insight on the impact of making various on-site changes.
  • Support the commercial data team in bringing in new datasets, utilising APIs when required. Using SQL and the Azure DWH to cleanse, wrangle and join data from a variety of sources.
  • Build and maintain optimal production pipelines in the data warehouse to drive efficiency, reliability and accuracy.
  • Monitor and update the pricing structure of online advertising products to ensure optimal results and carry out benchmark analysis.
  • Produce client presentations/documents for stakeholders across the business and contribute to L&D via the Ad academy.
  • Explore and develop machine learning opportunities to enhance decision making and results.
  • Attend industry related events providing key takeaways in improving ways of working.


  • Proficient in Microsoft Excel (pivot tables, VLOOKUP’s, Index match etc.)
  • Experience of using visualisation platforms such as Tableau and Salesforce preferable
  • Intermediate SQL skills
  • Ability to understand, digest and communicate complex information to stakeholders.
  • Ability to build relationships with a variety of colleagues and stakeholders.
  • Strong communication and interpersonal skills.
  • Ability to work collaboratively in a team environment.
  • Excellent attention to detail and organisational skills.
  • Proficiency in Microsoft Excel and financial modelling.
  • Strong analytical and quantitative skills, with a focus on commissions analysis and Salesforce CRM usage.
  • Experience with Salesforce CRM or willingness to learn.


  • A relaxed working environment with regular socials including a summer festival
  • Immediate Community webinars, well-being initiatives and Mental Health First aiders
  • 25 days holiday plus a day for your birthday. Our offices will be closed between Christmas and New Year’s which are in addition to your annual entitlement
  • Tailored training and development through our Love Learning platform
  • A progressive and transparent culture with clear career progression
  • Flexible/hybrid working plus early finish Fridays
  • Cycle to work scheme
  • Enhanced Family Policies including paternity, adoption and surrogacy leave. We also provide a pregnancy loss, fertility, and carers policy
  • Competitive pension plans and Life Assurance
  • A newly renovated modern office with lots of collaborative spaces

We pride ourselves on our open, collaborative, and dynamic culture. This encourages our people to thrive, and give their best whilst being supported, developed, and nurtured. As we care about our people, our environment, and the impact we make, we have an active Diversity and inclusion network, comprehensive well-being programmes, and clear sustainability strategies.

Diversity, equity and inclusion are at the heart of all our values and leadership behaviours to ensure Immediate remains a place where everyone feels included and empowered;

We care

We succeed together

We enjoy the ride

We are bold

We never settle

We get on with it

People are at the heart of our business and creating a diverse and inclusive working environment is extremely important to us. Immediate is an equal opportunities employer. We’ll never treat anyone less favourably because of their sex, gender reassignment, pregnancy and maternity, marital/civil partnerships, sexual orientation, race, nationality, ethnic origin, age, religion or belief or disability. We’re also committed to supporting applications from those who are returning to work following a career break, maternity leave or caring responsibilities.

We work with talented, driven people to make our vision reality

Such an amazing team requires nothing short of the best. That’s why we put a lot of effort into creating a work environment they deserve.

Two immediate employees at workAn Immediate employee works at a computer
Discover our culture