BI Developer; Tableau Migration

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

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. As a technical team within a creative industry, we value curiosity, innovation, clear communication, flexibility, and a pragmatic approach to problem‑solving, particularly during periods of change such as this migration.

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

• Proven reporting modernisation experience:
  Hands‑on experience with the redevelopment or evolution of dashboard suites, from initial discovery through to final deployment.
• Data visualisation & performance:
  Workplace experience building and maintaining dashboards using modern BI tools (preferably Tableau Desktop), with a focus on high‑performance design, calculated fields, and optimisation.
• 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, rationalising 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…