Data Migration Specialist
Other Support Jobs ⫽ Administrators
London
Permanent, Full time
Job description
Are you passionate about data and looking to make a significant impact at the world's largest trade book publisher?
Join our dynamic Integration team as a Data Migration Specialist. In this newly created role, you'll be at the forefront of implementing a robust data migration framework and managing data migrations to support our business and project teams. Whether through scripts, tools, or innovative programs, your expertise will help us seamlessly transition data and drive our mission forward.
Key responsibilities:
Collaborate with the Integration Team to align data migration activities with overall integration strategies and objectives.
Develop and implement a comprehensive data migration strategy to ensure seamless transitions.
Create standardised packages to extract, transform and load data from legacy systems, preferably using Azure Data Factory.
Support future requirements for accessing legacy data.
Manage and execute smaller data migrations for our Technology teams.
Provide guidance, training and support to additional migration resources to ensure project success.
Document specifications, business processes, methodologies and standards to ensure consistency and quality across Technology.
Implement data quality checks and validation processes to ensure the accuracy, security and integrity of migrated data.
Build a data migration asset register, validations and reconciliation processes.
Identify opportunities for process improvements and implement changes to enhance efficiency and effectiveness in data migration activities.
Work closely with various functional, business leads and testing teams.
Communicate effectively with key stakeholders, including project managers and application owners, to ensure alignment and transparency.
You will be:
Proficient in ETL using SQL, Azure Data Factory, Synapse Pipelines and Stored Procedures.
Skilled in creating data validation tools, templates and documentation.
Proficient in ERP implementation, including at least two full life cycle implementations in a Data Analyst role.
Experienced in legacy data migration.
Proficient in SQL and SSIS.
Knowledgeable in Data Governance principles with a strong background in Data Quality Assurance.
Experienced with reporting tools such as Management Reports, Business Documents and Power BI.
Proficient with integration tools to move data, such as AIS and SAP BTP.
A strong collaborator with the ability to work effectively with Architects, Development Leads and Project Teams.
An excellent verbal and written communicator, comfortable to problem-solve.
Highly analytical with excellent attention to detail.
About Technology
Following the successful completion of our recent technology, data and process merger, our Technology division is charging ahead with our strategic plan to amplify the voices of our organisation. This includes leveraging the potential of Cloud solutions, continuously enhancing our security measures, revitalising legacy applications, and enhancing our interactions with strategic partners and suppliers. Our Technology Division spans across two vibrant office locations in London and Colchester, where approximately 200 colleagues are dedicated to empowering our mission - we make books for everyone, because a book can change anyone.
We are also on a journey to create a workplace that is truly inclusive, empowering and equitable for all. Our recent successes have seen a significant increase in our division's engagement and sense of belonging. We are committed to fostering an environment where every voice is valued and every individual has the opportunity to make a meaningful impact.
Our approach to hybrid working:
While our offices are places for you to connect, collaborate and celebrate with colleagues, having flexibility about where you work is just as important for doing your best work and for your wellbeing. So, we don't have a one-size-fits-all approach when it comes to how we work across Penguin Random House UK.
For this role, there are regular meetings and activities that you will need to attend in person mainly at our offices in London. Outside of these moments, you can choose to work remotely. We are happy to discuss this arranging further with you during the recruitment process.
Application deadline: Please apply with your CV by 11:59 PM on Sunday 29th September.
What you can expect from us:
Salary: £60,000 - £70,000 dependent on how your skills and experience align to the role, plus bonus and benefits.
Our people are the heart of our business, and we work hard to support a culture of responsibility and recognition. Our benefits include:
Financial - income protection, life assurance, childcare allowance
Wellbeing - healthcare cash plan, critical illness cover, health checks
Lifestyle - enhanced parental leave, tech scheme, free and discounted books
For our full benefits list please visit: https://www.penguinrandomhousecareers.co.uk/what-we-offer
You can read about our recruitment process at https://www.penguinrandomhousecareers.co.uk/how-we-hire/
As a Disability Confident Committed organisation, we're part of the offer an interview scheme. This is where disabled applicants who meet the essential criteria for the role can opt in to get to the next recruitment stage. There may be some situations where volume of applicants means we can't take all eligible candidates to interview.
We encourage you to tell us about any reasonable adjustments you may need by emailing PRHCareersUK@penguinrandomhouse.co.uk. Remember, you only need to share what you are comfortable to for us to support your request.
Please note, we are not able to accept agency CVs for this role. Any CVs sent speculatively will not be eligible for a fee.
Company: Penguin Books Limited
Country: United Kingdom
State/Region: London
City: London
Postal Code: SW11 7BW
Job ID: 273776
Application url
This job is located on a third party website
Opens in new window - Please mention as the source of data when applying for this job