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.
#J-18808-Ljbffr