Consultant - SAP ADM (DSP)

Job Title: Consultant - SAP ADM (DSP)

Grade - C2

Introduction to role

Join a world-leading pharmaceutical company headquartered in the United Kingdom and operating in over 100 countries. We are seeking a DSP (Data Stewardship Platform) Consultant with extensive knowledge in DSP and SAP Data integration, particularly in SAP PP/QM/PM Data Objects.

Accountabilities

• Data Analysis and Mapping: Assist in analyzing source data and mapping it to SAP target structures, ensuring all mappings meet business requirements
• Data Extraction, Transformation, and Loading (ETL): Support the ETL process by assisting in the development and execution of data transformation scripts and tools
• Testing and Validation: Participate in validating data before and after migration to ensure accuracy and completeness, assisting with reconciliation and error resolution
• Documentation: Help in documenting data migration processes, including data mapping, transformation rules, and migration results
• Collaboration: Work closely with business and technical teams to understand data requirements, identify gaps, and suggest improvements
• Issue Resolution: Assist in solving issues that arise during data migration, working towards effective solutions under the mentorship of senior consultants
• Continuous Learning: Stay updated with SAP data migration tools and methodologies to improve skills and contribute effectively to migration projects To work in shifts and flexible work schedules

Essential Skills/Experience

• Hands-on working knowledge on DSP covering dspMigrate, dspConduct, Collect, Assemble, Common, Integrate, dspCompose
• Designing appropriate data migration solutions including transformation routines
• Design and Build DSP staging area
• Load source files into staging area
• Design, Build and Test transformations
• Build data quality rules and scorecards
• Generate data in target templates for load
• Preload and post load validation of migration results, handle dropouts and advise on data cleansing requirements
• Strong SQL & PL SQL skills
• Good knowledge on SAP PP/QM/PM Master & Transactional objects
• Good Knowledge on Mass Data Uploads in SAP using LSMW and S/4 Data Migration Cockpit
• Good analytical skills to troubleshoot and resolve data migration issues effectively
• Strong attention to detail and problem-solving abilities
• Good communication and interpersonal skills

Desirable Skills/Experience

• Worked in a hybrid environment with a mix of internal and external resources across geographical locations
• Certification in DSP
• Awareness about SAP Activate, JIRA, SAP Solution Manager & Testing Tools

At AstraZeneca, we are problem-solvers who harness uncertainties to set the direction for our projects. By fusing our digital and data capabilities with strong business backing, we positively impact patients worldwide. Our collaborative environment empowers our diverse team of specialists to explore new ideas and continuously expand their knowledge. We leverage leading technologies to make informed decisions quickly, driving our business forward to create value and achieve better scientific outcomes.

Ready to make a difference? Apply now to join our dynamic team!

AstraZeneca embraces diversity and equality of opportunity. We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills. We believe that the more inclusive we are, the better our work will be. We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics. We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorisation and employment eligibility verification requirements.