Data Orchestration Systems Analyst

ZipRecruiter; London; On-site; GBP 45,000 - 70,000; Full time

Job summary

A leading entertainment company seeks an Orchestration and Data Movement Service Systems Analyst to ensure efficient data handling across their systems. The role involves designing workflows, managing data orchestration, and supporting data-driven decisions. Competitive salary and numerous benefits including holidays and discounts offered.

Benefits

Pension

Life Assurance

Discretionary company bonus

33 days holiday including bank holidays

Merlin Magic Pass for free admission to attractions

25% discount in retail shops and restaurants

40% discount on LEGO

Qualifications

• 3–5 years of experience in data integration or orchestration.
• Solid experience with orchestration and automation tools.
• Strong knowledge of scripting for automation and data transformation.

Responsibilities

• Design, implement, and manage data orchestration workflows.
• Develop automated pipelines for data integration and delivery.
• Monitor and troubleshoot data movement processes.

Skills

Data integration

Orchestration

Automation

Scripting (Python, Bash, PowerShell)

Database management

Data governance

Tools

Apache Airflow

MuleSoft

Informatica Cloud

Azure Data Factory

Job description

Job Description

Join the Merlin Entertainments Digital & Data Team – where technology, data, and digital innovation meet magic!

At Merlin Entertainments, we're transforming the entertainment and hospitality industries through superb digital experiences.

Our Digital & Data function is connecting our global technology estate, delivering digital experiences to enchant more than 60 million guests in over 20 countries, and supporting every aspect of our business.

We’re on a mission to turn traditional theme park and hotel experiences into unforgettable moments that captivate guests worldwide.

Working with us means you could be pushing rollercoasters to new heights, safeguarding sea life through optimised infrastructure, creating captivating mobile app and in-park interactions, improving global operations, or directly supporting guests by keeping attractions running smoothly.

If you're a hands-on, passionate professional ready to modernise technology, data, and digital products while crafting memorable guest experiences, we'd love to hear from you!

The Orchestration and Data Movement Service Systems Analyst is responsible for ensuring the efficient and seamless movement of data across systems, applications, and environments, with a focus on orchestration.

This role plays a key part in designing, implementing, and maintaining automated workflows that facilitate data integration, processing, and delivery. The Analyst will ensure that data movement processes are efficient, secure, and compliant with organisational standards while collaborating with cross-functional teams to optimise data flows and support data-driven decision-making.

What we'd like to see from you:

• 3–5 years of experience in data integration, orchestration, or automation roles
• Solid experience with orchestration tools (e.g., Apache Airflow, MuleSoft, Dell Boomi, Informatica Cloud).
• Familiarity with cloud data platforms (e.g., AWS, Microsoft Azure, Google Cloud Platform) and related data movement technologies, including AWS Lambda and Azure Functions.
• Strong knowledge of scripting (e.g., Python, Bash, PowerShell) for automation and data transformation.
• Proficient in working with databases, data warehouses, and data lakes (e.g., SQL, NoSQL, Hadoop, Redshift).
• Familiarity with APIs and web services for integrating external systems and applications into orchestration workflows.
• Hands-on experience with data transformation and ETL (Extract, Transform, Load) processes.
• Strong understanding of data governance, privacy, and security principles.

What you'll be doing:

Orchestration and Workflow Management

• Design, implement, and manage end-to-end data orchestration workflows that automate data movement across systems and applications.
• Develop and maintain automated pipelines for data integration, transformation, and delivery, ensuring accuracy and timeliness of data transfer.
• Optimise and scale orchestration systems to handle large volumes of data and complex workflows.
• Monitor and troubleshoot orchestration workflows, ensuring data flows are uninterrupted, efficient, and error-free.
• Continuously assess orchestration technologies and methods to improve performance and reliability.

Data Movement and Integration

• Oversee data movement processes across diverse platforms, such as cloud-based services, on-premises systems, databases, and third-party applications.
• Develop and manage ETL/ELT workflows using tools like Python, SQL, Azure Data Factory, or similar technologies to process large-scale data efficiently.
• Ensure that data integration and movement solutions adhere to business requirements, security protocols, and compliance standards.
• Develop and implement data transformation procedures to ensure data consistency, integrity, and accuracy.
• Implement strategies for data synchronisation between systems and ensure that data is updated and available across environments in real-time or batch.

We’re growing fast and alongside a fun and friendly environment, we offer a fabulous package and amazing prospects – ideal if you’re already fantastic and want to become even better (our magic can help here). Benefits include Pension, Life Assurance, discretionary company bonus, 33 days’ holiday including bank holidays, a Merlin Magic Pass which gives you and your friends and family free admission to all of our attractions worldwide, an Enjoy the Ride pass which entitles you and 5 loved ones unlimited entry into your regional attractions, 25% discount in our retail shops and restaurants and 40% discount on LEGO, plus lots more!

If you have any questions or if you require any assistance, because of a or medical condition, please contact us by email at [e-mail] and one of the team will get back to you as soon as possible.