Data Analyst

You'll be reporting into the Head of Analytics, alongside a senior Data Analyst and a Data Engineer, in this small but dynamic project team. We're responsible for providing accurate and timely data to enable insight-driven decision-making throughout the business. The team manages an ever-evolving data warehouse, which we're in the process of migrating to Snowflake, and a suite of automated Tableau dashboards and reporting. Our projects address commercial and business priorities., Day to day you will be querying our SQL data warehouse to create Tableau dashboards and reports that support informed decision-making across the business. You will be using and communicating sales, market and operational data. You can also expect to be involved with maintaining and updating our existing suite of dashboards, working with our data engineer to ensure the quality and accuracy of data and assisting dashboard users to self-serve wherever possible.,

• Maintain, improve and contribute to our suite of Tableau dashboards and automated solutions


• Understand reporting and insight needs


• Participate in requirement-gathering and specification activities


• Develop digestible and visually appealing automated dashboards to actively promote self-service, efficiency and transparency


• Interrogate and analyse data: creating code in SQL and Tableau, etc., to perform analysis and to create data sources. Upskilling, wherever relevant, to new requirements


• Communicate insight to stakeholders: email, written reports, presenting at meetings, etc., including answering one-off questions, regular reporting and writing commentary


• Support and train others to self-serve and familiarise themselves with Analytics dashboards and tools


• Support the data engineer role with the maintenance and development of the data warehouse to ensure accurate delivery of quality data: monitoring pipelines, packages, data prep, data cleansing, documentation, testing and verification


• Documentation and administrative duties, including specification and documentation of new data sources


• Manage workload using Asana to ensure timely deliverables as part of a project team.
  
  This role is ideal for a detail-oriented book lover who naturally looks to data and research to find answers, and has the ability to effectively communicate this insight to others. You will have at least 1-3 years' experience as a Data Analyst or in a relevant data-handling role., An enquiring mind that enjoys problem-solving, with the ability to refine questions and translate from numbers to meaning


• Experience or knowledge of using data visualisation / BI tools to create user-friendly graphs, tables and dashboards


• Proficiency with the Microsoft suite, especially Excel (including formulas, functions, pivots, and preferably macros / VBA)


• Working knowledge of using SQL to create queries and views to enable analysis


• The ability to create and maintain relevant documentation


• Some experience with handling and cleaning data (with an interest or experience in the principles of data engineering)


• Ability to think both practically and visionarily about applications and sources of data - demonstrate initiative, creativity and flexibility in delivering solutions


• A commercial awareness with the ability to work both at detail and strategic level for data-driven decision-making


• Strong communication skills with the ability to present and interpret data to non-data audiences


• Collaborative team player with a willingness to contribute ideas


• Excellent attention to detail with a focus on accuracy, relevancy and quality


• Ability to work under pressure and manage time effectively to meet deadlines.


Desirable skills we'd love you to have:

• An interest or experience in publishing, reading or the contemporary book market


• Experience with publishing technologies and systems, e.g. Biblio, Vista, Midas, BookScan


• Experience in a commercial industry or department / commercial awareness, with the ability to work both at a detailed and strategic level


• Experience with the following technologies would be advantageous: APIs, Tableau Desktop, Microsoft SQL Server, Snowflake, Matillion, DBT, AWS environment, Python and other scripting languages.
  
  We pride ourselves not just in winning awards and publishing the bestselling books in the market, but also on the wellbeing and satisfaction of everyone who works with us. This is a company where all voices are heard and new, creative ideas are welcomed.


We seek to recruit and develop talent from all backgrounds, creating a diverse and inclusive workplace. This has a profound impact on our perspective and ideas, encouraging us to learn from each other and to nurture the best talent leading us to publish books that appeal to the broadest possible readership.

Our mission is to publish the very best authors and illustrators successfully and sustainably because we believe that books enrich people's lives and help build empathy and understanding.

Our values

To ensure that everyone who works at Pan Macmillan delivers on our mission and shares the same goals, we have developed a set of values that define our working culture and are the foundation of our publishing. These values were derived in consultation with the whole company and they are deliberately illustrated in a circle to underline a lack of hierarchy in importance.

In return we can offer you a range of great projects, a supportive and collaborative working environment as well as a competitive salary and benefits package.

Salary starting from: £32,000,
• 25 days annual leave increasing with years of service + bank holidays


• Generous pension scheme


• Discounted private medical insurance


• Group income protection scheme


• Enhanced family pay and leave


• Flexible working hours and summer hours (early finish on a Friday during summer months)


• 2 Volunteer Days per year


• 75% off all Pan Macmillan books and regular staff book sales (highly reduced rates)


• Season ticket loan/advance


• Cycle to work scheme


• Discounts on shopping, Tastecard+ and gym memberships; Christmas club savings


• Daily free breakfast and monthly company lunch


This is a full time, permanent role, and will be based in our offices in Farringdon, London, with some flexibility to work from home each week.

All applicants must be able to demonstrate the right to live and work in the UK in order to be considered for this role.