Data Engineer / Analyst – 12 Month Fixed Term Contract
On site
London, United Kingdom
Freelance
06-04-2025
Job Specifications
Pan Macmillan is looking for an experienced Data Engineer with the technical, analytical, and project skills to accelerate delivery of three key projects in data migration and expansion. This role is ideal for someone with a keen eye for detail who enjoys delivering innovative and appropriate data solutions.
Your Team
You’ll be joining a small but dynamic team, reporting to the Head of Analytics and working on projects alongside a Database Engineer and two Data Analysts. You’ll also collaborate with colleagues in the US and technology support teams.
The team provides accurate and timely data to drive decision-making across the business, managing a suite of Tableau reports and the underpinning Snowflake database. We are a project team working closely with stakeholders in the commercial, creative, business, and process areas to meet the evolving needs of the company and the publishing industry.
Your Role
You will be working on three key projects:
Completing migration from Microsoft SQL Server to Snowflake, using Matillion as the primary transformation tool.
Migrating Tableau dashboards to point at our newly structured data warehouse, including requirement gathering, data scoping, and building views and data marts
Expansion of commercial data sources, including scoping business requirements, pipeline development, and API integration.
You can expect project delivery to involve improving automation and data-flow reliability, leveraging APIs for data enrichment and integration, exploring AI-assisted solutions for data cleansing and categorisation, and creating Tableau dashboards to monitor data content and quality.
Adaptability and proactive problem-solving are essential in this fast-evolving environment, as is being a team player and a willingness to help deliver business as usual.
Your Key Responsibilities
Data warehouse migration & infrastructure
Collaborate with the Data Engineer to deliver the migration of the enterprise data warehouse from SQL Server to Snowflake.
Contribute to data mapping, modelling, shaping, and architecture design to support efficient and scalable data structures.
Handle data transfers and manage regular maintenance and updates of data pipelines.
Build and maintain ETL/ELT transformations using relevant tools.
Verify data, transformations, and packages to ensure completeness and accuracy.
Performance, quality & monitoring
Carry out query, data, and connection optimisation to improve pipeline performance.
Design and implement data quality assurance and monitoring processes.
Conduct troubleshooting and proactively resolve data-related issues, ensuring minimal disruption to data flows.
Integration & automation
Discover and integrate new data sources in line with business priorities.
Review and improve existing data-handling processes for automation, efficiency, and better leveraging of APIs.
Develop data-cleansing and categorisation solutions, including exploration of AI-assisted approaches.
Dashboards & migration
Review Tableau dashboards to define data requirements for migration to the restructured warehouse.
Maintain, improve, and contribute to our suite of Tableau dashboards and automated solutions.
Develop complex SQL queries, views, and marts to support Tableau dashboards and other outputs.
General Responsibilities
Participate in requirement gathering and specification activities for analytics projects.
Manage your workload using Asana to ensure timely delivery of tasks as part of a collaborative project team.
Support the Analytics team in delivering business-as-usual reporting and data support.
Share knowledge and provide support to team members, upskilling where relevant to meet new requirements.
Documentation of updates, decisions, and data solutions to support team knowledge and continuity.
Essential experience, abilities, and knowledge you’ll need to succeed:
Proven experience with SQL, including working knowledge of pipeline management, data architecture, and performance optimisation.
Working knowledge of cloud-based data warehousing and the following technologies: Python, AWS, APIs, DBT, with the ability to quickly upskill in Matillion.
Working knowledge of data visualisation / BI tools, with experience in creating or editing dashboards and reports.
Experience with handling commercial data and understanding the data use-cases of commercial teams.
Clear record of problem-solving capabilities, with strong analytical skills for data-driven decision-making.
Technical scoping expertise, especially:
Reviewing existing dashboards to recommend improvements to data sources and flows.
Assessing new data sources to deliver pipeline and data-handling recommendations.
Data cleansing, validation, and transformation skills.
Creating and maintaining clear and relevant technical documentation.
Ability to manage time effectively and meet deadlines under pressure.
Excellent attention to detail, with a focus on accuracy, relevancy, and quality.
Collaborative team player with a willingness to contribute ideas.
Ability to think both practically and strategically about data sources and applications, demonstrating initiative, creativity, and flexibility.
A minimum of three years of experience in a data-oriented role such as a Data Engineer, Database Administrator, ETL Developer, or a related field.
Undergraduate degree in a mathematically based subject (e.g., Information Systems, Economics, Psychology, Computer Sciences), or equivalent work experience.
Project experience, including working as part of a team and meeting deadlines, and some experience of leading project tasks or workstreams.
Desirable Skills We’d Love You To Have
An interest in, or experience with, publishing, reading, or the contemporary book market.
Experience with database migration and/or consultancy.
Experience with the following technologies would be advantageous: Tableau Desktop, Snowflake, Microsoft SQL Server, Matillion, Git or GitHub.
Practical experience working with social media data.
Strong communication skills, including stakeholder engagement and the ability to present and interpret data for non-data audiences.
Experience working in Agile or sprint-based delivery environments, particularly in data or analytics projects.
Proficiency with the Microsoft suite, especially Excel (including formulas, functions, pivots, and macros/VBA).
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.
Closing date: 21 April 2025
Salary start from: £42,000
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 ...
About the Company
At Pan Macmillan we publish a broad and vibrant range of books for audiences of all ages from dazzling bestsellers to influential prize-winners; books to inspire lifelong readers and listeners to enduring classics for generations to come. The fourth largest UK publisher, we pride ourselves on publishing successfully and sustainably and are committed to working together to positively impact culture and society at large. Our brilliant authors and illustrators include: Dapo Adeola, Tomi Adeyemi, Kate and Kay Allinson, Pam Ayre... Know more
Related Jobs
- Company Name
- DataAnnotation
- Job Title
- Analyst - AI Trainer
- Job Description
- We are looking for an analyst to join our team to train AI models. You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of each model. Find out more about the daily tasks, overall responsibilities, and required experience for this opportunity by scrolling down now. In this role you will need to hold an expert level of mathematical reasoning- a completed or in progress Masters/PhD is preferred but not required. Other related fields include, but are not limited to: Data Science, Applied Math and/or Computer Science. Benefits This is a full-time or part-time REMOTE position You’ll be able to choose which projects you want to work on You can work on your own schedule Projects are paid hourly starting at $40+ USD per hour, with bonuses on high-quality and high-volume work Responsibilities Give AI chatbots diverse and complex mathematics problems and evaluate their outputs Evaluate the quality produced by AI models for correctness and performance Qualifications Fluency in English (native or bilingual level) Detail-oriented Proficient in data science, arithmetic, algebra, geometry, calculus, probability, statistics, and inductive/ deductive reasoning A current, in progress, or completed Masters and/or PhD is preferred but not required Note: Payment is made via PayPal. We will never ask for any money from you. PayPal will handle any currency conversions from USD. #INDUKMA Job Types: Full-time, Part-time Pay: From £30.36 per hour Work Location: Remote
- Company Name
- Ubique Systems
- Job Title
- Azure Database Administrator
- Job Description
- • Design, implement, and maintain database systems to ensure high availability, performance, and security. • Manage and optimize databases on Azure, mainly Postgres, Cosmos DB and SQL. • Develop and maintain data integration workflows using Azure Data Factory. • Monitor database performance and troubleshoot issues to ensure optimal operation. • Implement and manage database security measures to protect sensitive data. • Collaborate with development teams to design and optimize database schemas and queries. • Utilize Azure DevOps for continuous integration and deployment of database changes. • Ensure database backups, recovery, and disaster recovery plans are in place and tested regularly. • Provide technical support and guidance to other team members on database-related issues. • Stay up-to-date with the latest database technologies and best practices.
- Company Name
- DATAHEAD
- Job Title
- Junior Azure Data & AI Engineer
- Job Description
- Junior Azure Data, ML & GenAI Ops Engineer (Contractor) £200–£250 per day | 3-month initial contract | Outide IR35 Remote/Hybrid (UK-based) Recruiting via: DATAHEAD We are recruiting on behalf of a leading international media business - an ambitious and fast-growing organisation with a strong track record of innovation and operational excellence. The business is investing heavily in its technology and digital capabilities, creating new opportunities to drive data-driven and AI-led transformation across multiple sectors. They are known for fostering a collaborative and high-performing environment, consistently recognised as a great place to work. About the Role We are seeking a Junior Azure Data, ML & GenAI Ops Engineer to join their dynamic technology team on a contract basis. You will play a key role in supporting the development, deployment, and management of next-generation digital products and AI-driven solutions, ensuring scalability, security, and efficiency. This is a fantastic opportunity to work at the intersection of data engineering, MLOps, and generative AI, alongside an experienced and supportive team. Key Responsibilities Data Engineering: Build, optimise, and maintain robust data pipelines and APIs using Azure Data Factory, Azure Databricks, and Azure API Management. Data Storage Solutions: Design and manage cloud storage solutions, ensuring scalability and accessibility across various data types (Azure Storage, Azure SQL). Cloud Infrastructure Management: Assist in maintaining and securing Azure environments, ensuring data integrity and controlled access. AI & GenAI Integration: Embed Large Language Models (LLMs) and Large Multimodal Models (LMMs) into business workflows, enabling practical applications such as classification, knowledge extraction, and recommendation engines. Continuous Improvement: Stay updated on emerging cloud technologies, MLOps practices, and generative AI advancements to continually enhance infrastructure and capability. Skills and Requirements Some level of exposure or a couple of years working with Azure services (Azure Data Factory, Azure Storage/ADLS, Azure SQL, Azure Databricks, AzureML). Solid programming skills, ideally in Python, and a strong grasp of data formats like JSON. Practical experience working with generative AI models and integrating LLMs into operational solutions. Understanding of MLOps practices and familiarity with Azure DevOps. Experience with ML frameworks such as LangChain, PyTorch, and TensorFlow, plus exposure to data versioning and model management tools. Strong written and verbal communication skills to work collaboratively with a high-performing team and deliver clear documentation. Desirable Qualifications Microsoft Certified: Azure Data Engineer Associate Microsoft Certified: Azure AI Engineer Associate Please Apply!
- Company Name
- Squire Patton Boggs
- Job Title
- In-House Data Privacy Lawyer (5+ PQE) - 6-month FTC
- Job Description
- Description We are seeking a Data Privacy Lawyer to join our in-house data protection compliance team on a 6-month fixed-term contract. Our Firm Squire Patton Boggs is one of the world's strongest integrated law firms, committed to providing insight at the point where law, business and government meet. We deliver commercially focused business solutions to a diverse mix of clients, from long-established leading corporations to emerging businesses, start-up visionaries and sovereign nations. With over 1,500 lawyers spanning more than 40 offices across four continents, the firm is renowned for its local connections and global influence, delivering comprehensive legal services across North America, Europe, the Middle East, Asia Pacific, and Latin America. In the UK, we have offices in Birmingham, Manchester, Leeds and London. The firm is committed to promoting a collaborative and supportive working environment. Embedded by local champions in each of our UK offices, our well-regarded family and carer, wellbeing and workplace culture and development programmes provide a variety of flexible working options to support individuals' life journeys, helping our people pursue their personal and professional goals. Our Team Our in-house Privacy team advises on all internal legal matters, with primary responsibility for the UK and EU, but increasingly on a global basis. Squire Patton Boggs is one of the world's strongest integrated legal practices and our Data Protection, Cybersecurity & Digital Assets Practice Group has been named one of the top 25 GDR Elite for the past two years. Our Opportunity Role The principal role of the In-House Data Privacy Lawyer is to advise and support the Data Protection Officer and the Office of General Counsel on data protection (DP), cybersecurity and e-privacy compliance across the global firm. You will be involved with: advising on issues arising under the UK and EU General Data Protection Regulations (UK and EU GDPR), including complex international data transfers that are inherent to a global law firm; supporting DP and security due diligence assessments on third party vendors, including contract reviews, and contributing to data protection impact assessments; providing pragmatic advice/legal guidance on HR-related DP issues, including Workplace Culture and Development programs; advising on training and awareness programs, and building tools and resources to support good data governance and the firm's DP obligations under the GDPR and other privacy regulations, across all business functions and legal practice areas; identifying and addressing privacy compliance gaps as part of the annual policy review cycle; supporting the firm's employees involved in DP compliance across all business functions and practice groups with pragmatic and commercially aware advice/guidance; working with the firm's global privacy legal team to incorporate compliance requirements in other jurisdictions, including CCPA, China PIPL, into the firm's compliance regime; participating in regular discussions with the global privacy legal team and the global privacy steering committee; providing advice/guidance in relation to e-privacy compliance in the marketing area; and supporting the firm's response to data subject requests and other DP-related compliance initiatives. Candidates should expect excellent quality of work in a culture that encourages leadership and involvement with the business. The successful candidate can be based in any of our UK locations, with options to work flexibly and/or remotely if required. You We are looking for a qualified solicitor (5+ PQE) with experience advising on, and managing, data protection and privacy matters. You must demonstrate a strong commitment to a specialisation in data privacy matters, have the drive and ability to deliver high-quality work and be pro-active in supporting a strong privacy-orientated culture. We are looking for an enthusiastic individual with a professional approach, good people skills, solid commercial awareness, and the ability to work as a team player across all levels and business functions. You will be coming either from an in-house privacy role or from a reputable law firm. What You Need To Know If you are interested in finding out more about this role, please visit our careers site at www.squirepattonboggs.com/en/careers. We are unable to process applications sent directly by email. Please complete an online application. We are an inclusive employer and aim to ensure our workforce is representative of our society. We welcome applications regardless of age, neurodiversity, disability, family or parental status, race, religion, ethnicity, sexual orientation, or gender identity and expression or other legally protected characteristics. We will make reasonable adjustments and adaptions to our recruitment process to ensure it is inclusive for anyone who wishes to apply.