Skip to content

Pan Macmillan

Your team
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.

Your role
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.

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.

Your key responsibilities

  • 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.

Essential experience, abilities and knowledge you’ll need to succeed

  • 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.

What you’ll get in return
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

Some of the benefits we offer

  • 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

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

At Pan Macmillan, we are highly committed to promoting diversity, equity and inclusion at every level of our organisation. We welcome applications from all individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief. Our efforts to promote DE&I is ongoing, and we continually strive to learn and improve our policies and practices. You can read our full Diversity & Inclusion Pledge is available here https://www.panmacmillan.com/about/diversity-and-inclusion

Please note that all personal information which we process in connection with your application will be treated in accordance with our Recruitment Privacy Notice available here: https://panmacmillan.com/recruitment-privacy-notice. Please read our Recruitment Privacy Notice before submitting your application

To apply for this job please visit careers.panmacmillan.com.