The Royal Society is the UK’s national academy for science. Its purpose is to recognise, promote and support excellence in science, and encourage the development and use of science for the benefit of humanity. Scholarly communication has been central to the Society’s mission since it launched the world’s first scientific journal, Philosophical Transactions, in 1665. Researchers who have published in the journals of The Royal Society include Isaac Newton, Robert Hooke, Benjamin Franklin, Caroline Herschel, Charles Darwin, Michael Faraday, Dorothy Hodgkin, James Clerk Maxwell, Albert Einstein, Kathleen Lonsdale, Alan Turing and Stephen Hawking. The Publishing section publishes a portfolio of 11 prestigious journals, which disseminate high quality research worldwide and generate a positive financial return for The Royal Society. The Society is committed to making all of its journals Open Access on sustainable models. This new role delivers data insights that drive strategic decisions in the Publishing section. The Data Visualisation Analyst will collate data on KPIs that measure journal performance, guide the actions of the team and build dashboards that visualise KPI data. With strong analytical skills and a focus on business intelligence, the role holder will create actionable insights to enable improvement of the existing business and development of new products and services. Reports to : Head of Sales & Marketing Line manages : NA Location : Carlton House Terrace, London, SW1Y 5AG Hours: Full, 35 hours a week Pay band : E, £45,000-£62,000 per annum The application closing date is 24 May at 23:59. Please note that we are unable to offer sponsorship for this role. Collate, clean and provide high quality data across the Publishing section Build analytical data structures, models, reports and insights that contribute to strategy and journal performance Create dashboards which visualise KPI data in an easy-to-understand form for the team Identify and implement process improvements on an on-going basis Ensure consistent use of data systems across the Publishing section Map data sources across systems used by the Publishing section and create work flow diagrams Prepare and present clearly understandable analyses via Excel, PowerPoint and other relevant software to key stakeholders Create market segment analysis, as directed Liaise with other teams within the Royal Society on data issues Undertake other analytic tasks as directed by the Head of Sales and Marketing Ability to gather, clean and analyse large data sets Data modelling and data visualisation from raw data, including development of user-friendly dashboards Advanced Excel skills are essential including formula construction, add-ins and VBA Experience working with Tableau/Power BI, APIs and SQL or similar programming is highly desirable Commercial focus, able to prioritise and work to deadlines Ability to present findings to internal and external stakeholders Experience of STM journal publishing and familiarity with Open Access business models is desirable but not essential Self-management Identifies difficult situations Recognises stress in others and takes steps to reduce it Controls pressurised situations Effectively enthuses those in the team Proactively sets goals and targets for own work Working with others Actively seeks ideas and criticisms from within the team Resolves conflicts within and between teams Embeds feedback processes within the team Seeks out new networks that will create opportunity for the Society Able to present complex issues simply Uses discretion, tact and empathy when negotiating with and/or seeking to influence others Understands the need to manage expectations and to only promise what is deliverable Resource management Determines strategy and deployment of resources, balancing cost and benefit; risk and potential for maximum impact across significant business areas Manages complex cross-cutting projects to time, budget and specification Ensures others accept responsibility towards results or quality Sets the quality standards for own business areas in accordance with strategy and contributes to the formulation of quality standards across the Society Sets and monitors priorities Identifies and manages risk effectively Critical thinking Uses questioning, analytical and probing skills to ‘dig deeper’ Knows when enough information has been obtained and adapts presentation of information to the needs of the audience Evaluates the benefits, practicalities and value for money of ideas and obtains feedback Makes sound decisions in a complex or ambiguous environment and is able to gain support and manage challenges confidently Adaptability Actively seeks the input and opinions of others, often outside his/her section and accommodates and incorporates this thinking into any output. Actively seeks new challenges and projects; leads discussions surrounding new ideas, approaches and projects Anticipates need for innovation and seeks new ideas, approaches and solutions Managing people and relationships Sets expectations of others and ensures they deliver Demonstrates a positive attitude towards work, celebrating success and instilling confidence, which encourages the same from others Encourages others to share ideas and participate in the discussion and decisions of the team Assesses needs of clients/stakeholders/staff and makes plans to meet these needs