BI Developer in London

Pan Macmillan are looking for an experienced BI Developer to join our London-based Analytics team on a 15-month fixed-term contract and play a pivotal role in migrating our Tableau dashboards. This project moves beyond repointing and a cosmetic refresh; it’s an opportunity to rationalize and improve how we deliver insight to the business. If you enjoy working at the intersection of technology and the creative industries, translating complex data into intuitive stories that drive better decisions, this role offers the chance to make a lasting impact within a collaborative and thoughtful team.

Your team:

You’ll join a collaborative Analytics team of five, reporting to the Head of Analytics and working closely with our Data Engineers and Analysts. We are a project team that balances technical rigour with a supportive, flexible culture to support insight-led decision-making across the business. Our current priority is ensuring a smooth transformation of our Tableau dashboards to align with our modern data warehouse, ensuring every department has access to high-quality, actionable insights. We pride ourselves on being a trusted partner to the business, translating complex technical logic into clear visual stories.

Your role:

As BI Developer, you will be the primary delivery resource for the redevelopment and migration of our Tableau dashboards. You’ll work closely with the Analysts, Data Engineers, and stakeholders to define and deliver a suite of high-quality dashboards and their underlying data sources. Alongside this project work, you’ll contribute to business-as-usual analytics activity, helping to maintain existing dashboards, support users, and ensure continuity during the migration period.

Your key responsibilities:

• Delivery lead for the redevelopment and migration of Tableau dashboards.
• Build and maintain Tableau dashboards in line with the house style, focusing on clarity and usability.
• Technical collaboration with Data Engineers to review and define reporting logic using modern cloud tools such as dbt and Snowflake.
• Validate reporting outputs by writing and interpreting complex SQL queries to ensure business expectations and data accuracy.
• Create documentation including dashboard reviews, wireframes, definitions, and guidance materials.
• Support the embedding of new dashboards throughout the business, through clear communication and training.
• Contribute to business-as-usual operations, including maintaining existing analytics products and responding to ad-hoc queries.
• Manage workload and project deliverables to meet timelines.

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

• Proven reporting modernization experience: Hands-on experience with the redevelopment or evolution of dashboard suites, from initial discovery through to final deployment.
• Data visualization & performance: Workplace experience building and maintaining dashboards using modern BI tools (preferably Tableau Desktop), with a focus on high-performance design, calculated fields, and optimization.
• Technical rigour & architecture: A solid understanding of dimensional data concepts (facts, dimensions, grain), including their relation to BI reporting and experience working within modern data warehouse environments such as Snowflake.
• SQL proficiency: A strong working knowledge of SQL, with the ability to write and interpret complex queries to validate data, audit logic, and collaborate on the design of data marts.
• Strategic translation: A proven ability to translate business questions into technical requirements, rationalizing reporting suites and bringing structure to ambiguous requests.
• Stakeholder engagement: Strong communication skills, with the ability to act as a link between technical teams and business users to explain complex reporting logic to non-technical audiences.
• Project documentation: Experience creating clear project documentation, including wireframes, dashboard definitions, and support guidance to ensure data consistency.
• Agile delivery: The ability to manage workloads effectively in a flexible, project-based environment with a keen eye for detail and data quality and accuracy.
• Inclusion & representation: An active dedication to promoting diverse voices and inclusive practices, taking personal responsibility for ensuring our data insights and workplace reflect the communities we serve.
• Community: A collaborative, team-oriented approach, comfortable working as part of a multi-disciplinary Analytics team to build a supportive environment.
• Curiosity: A strong drive for learning, a readiness to embrace different perspectives, and a genuine interest in how data supports the creative world of publishing.
• Integrity: A foundation of openness and honesty, taking responsibility for data accuracy and learning from technical challenges to drive better decisions.

Desirable skills we’d love you to have:

• Familiarity with: Publishing, media, or consumer data.
• Data transformation concepts or tools (e.g. dbt) and an understanding of advanced database objects such as materialized views or dynamic tables.
• Experience with: Working as part of a database migration team.
• Managing Tableau Cloud content.
• Contributing to analytics documentation and standards.
• Working with project management tools such as Asana.

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.

Some of the benefits we offer:

• 28 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 and gym memberships; Christmas club savings.
• Daily free breakfast and monthly company lunch.

This is a fifteen-month fixed term 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.

At Pan Macmillan, we are committed to publishing a wide range of voices that reflect the full breadth of the communities we serve. Joining us means playing an active role in bringing our titles to life as part of a team that champions inclusion at every level. We are dedicated to building a workplace that is as diverse and welcoming as the stories we tell, ensuring all perspectives are celebrated across everything we do.

We are highly committed to promoting diversity, equity and inclusion (DEI) at every level of our organisation. We welcome applications from all individuals, including any age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief. Our efforts to promote DEI are ongoing, and we continually strive to learn and improve our policies and practices.