Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team to maintain and improve Tableau dashboards and support data-driven decisions.
- Company: Pan Macmillan is a leading publisher committed to diversity and inclusion.
- Benefits: Enjoy flexible working hours, 28 days annual leave, and discounts on books and shopping.
- Why this job: Perfect for problem-solvers eager to learn and communicate insights in a collaborative environment.
- Qualifications: Experience with SQL, Tableau, and a curious mindset for data analysis required.
- Other info: This role offers a competitive salary starting from £36,000 and opportunities for growth.
The predicted salary is between 28800 - 50400 £ per year.
Pan Macmillan is looking for a detail-oriented Data Analyst to join our London-based Analytics team. This role is ideal for someone who enjoys problem-solving, learning new technologies, working with data to generate insight and communicating findings to a broad range of stakeholders.
Your Team
You’ll be joining a small but dynamic team of four, reporting to the Head of Analytics and working alongside a Data Analyst and a Data Engineer. We provide accurate and timely data to support insight-driven decision-making across the business, managing an expanding Snowflake data warehouse and a suite of automated Tableau dashboards. We are a project team, addressing commercial and business priorities, and all roles have some overlap and collaboration.
Your Role
Day to day, you will be maintaining and improving our existing suite of Tableau dashboards, querying our data warehouse, helping colleagues use data effectively, and answering ad hoc data queries. You will also work on longer-term projects, ensuring our suite of dashboards and reporting evolve to meet business needs.
This role also involves developing your ability to support our Engineer in maintaining our data warehouses, ensuring data quality, managing pipelines and contributing to the ongoing development of our analytics infrastructure.
Your Key Responsibilities
- Maintaining, improving, and contributing to our suite of Tableau dashboards and automated solutions
- Understanding reporting and insight needs:
- Participating in requirement gathering and translating needs into effective dashboards
- Identifying, assessing, and developing suitable data sources to support business reporting and insight needs
- Developing visually appealing and digestible reports to encourage self-service and efficiency
Essential experience, abilities and knowledge you’ll need to succeed:
- Working knowledge of relational databases, especially using SQL for querying and creating views to support analysis (ideally T-SQL or Snowflake SQL)
- Experience with data visualization / BI tools to create user-friendly dashboards (e.g. Tableau)
- Experience with one or more of our technologies: APIs, Tableau Desktop, Microsoft SQL Server, Snowflake, Matillion, DBT, AWS, Python, or other scripting and programming languages
- Some experience with data handling and data cleaning, with an interest in developing data engineering principles
- Proficiency with the Microsoft suite, especially Excel (including formulas, functions, pivots, and preferably macros/VBA)
- A curious mindset with a problem-solving approach, able to refine questions and extract stories and meaning from data
- Strong commercial awareness and the ability to apply data insights to business decisions
- Ability to balance both practical and strategic thinking when working with data to produce actionable insight
- A collaborative approach and willingness to contribute ideas in a small team
- Strong communication skills, including the ability to present and interpret data for non-data audiences
- Excellent attention to detail with a focus on accuracy, relevancy, and quality
- Ability to manage workload effectively and meet deadlines.
Desirable Skills We’d Love You To Have
- Experience with using SQL to create or manage stored procedures and functions
- Familiarity with database principles and data flow concepts
- Experience with creating and maintaining project and process documentation
- Ability to understand and apply statistical methods and to identify trends, and anomalies
- 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, with an understanding of business data applications.
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: £36,000
Closing Date: 16 March 2025
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, 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.
At Pan Macmillan, 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. We want to ensure that all candidates are supported throughout the recruitment process, if you have any reasonable adjustments or accessibility requirements please do let us know. Our efforts to promote DEI are ongoing, and we continually strive to learn and improve our policies and practices. You can read our full Diversity & Inclusion Pledge here: Diversity & Inclusion Pledge
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: Recruitment Privacy Notice . Please read our Recruitment Privacy Notice before submitting your application #J-18808-Ljbffr
Data Analyst employer: Pan Macmillan
Contact Detail:
Pan Macmillan Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Familiarize yourself with Snowflake and Tableau, as these are key tools for the role. Consider taking online courses or tutorials to enhance your skills in these platforms, which will help you stand out during the interview process.
✨Tip Number 2
Brush up on your SQL skills, especially T-SQL or Snowflake SQL. Being able to demonstrate your ability to query databases effectively will be crucial, so practice writing complex queries and creating views that support analysis.
✨Tip Number 3
Showcase your problem-solving mindset by preparing examples of how you've used data to drive insights in previous roles. Be ready to discuss specific projects where you identified trends or anomalies and how you communicated those findings to stakeholders.
✨Tip Number 4
Highlight your collaborative approach by sharing experiences where you've worked closely with team members or cross-functional teams. Emphasize your willingness to contribute ideas and support others in using analytics tools effectively.
We think you need these skills to ace Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the job description. Focus on your proficiency with SQL, Tableau, and any data visualization tools you've used.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention specific projects or experiences that demonstrate your problem-solving skills and ability to work collaboratively in a team.
Showcase Your Technical Skills: Clearly outline your technical skills related to data analysis, such as your experience with Snowflake, APIs, and data cleaning. Provide examples of how you've used these skills in previous roles.
Highlight Communication Abilities: Since the role involves communicating insights to stakeholders, emphasize your strong communication skills. Include examples of how you've presented data findings to non-technical audiences.
How to prepare for a job interview at Pan Macmillan
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, Tableau, and any other relevant technologies. Highlight specific projects where you've used these tools to create dashboards or analyze data, as this will demonstrate your hands-on expertise.
✨Communicate Clearly
Since the role involves presenting insights to non-data audiences, practice explaining complex data concepts in simple terms. Use examples from your past experiences to illustrate how you effectively communicated findings to stakeholders.
✨Demonstrate Problem-Solving Abilities
Prepare to discuss instances where you've tackled data-related challenges. Emphasize your curious mindset and how you approach problem-solving, as this aligns with the company's focus on insight-driven decision-making.
✨Emphasize Collaboration
Given that you'll be working in a small team, highlight your collaborative experiences. Share examples of how you've contributed ideas and worked alongside others to achieve common goals, showcasing your ability to thrive in a team environment.
