Data Migration Developers x 2
Salary: £45,000 - £50,000 + company benefits
Location - Hybrid (2-3 days per week in one of the following offices Bristol, Leicester or Plymouth)
Full time/permanent vacancy
You must be a sole British Nationals and be able to obtain BPSS/SC and NPPV clearance.

JOB PURPOSE

• Working with the Business Object Data Services (BODS) Extract, Transform, Load (ETL) toolset to design, develop and support end-to-end data migration processes associated with both SAP and non SAP based programs.
• Design and implement data quality and data cleansing requirements and methodologies.
• Manage support, tools, and maintenance of integration processes.
• Interact and collaborate with other data team members and business analysts.
• Maintain and Support Corporate ETL & Data Migration Solutions in both SAP & Microsoft platforms.
• Understanding of SAP data structures & tables and loading data to SAP using LSMW and BODS directly.

KEY TASKS

• Design and develop SAP BODS jobs for data conversion and data integration to and from SAP and other sources.
• Maintain and enhance the existing toolset to ensure delivery of maximum value as the project evolves.
• Prepare Excel spreadsheets (Data Collection Workbooks) using SAP load formats (iDoc/BAPI/ABAP Programs) as load templates for data analysts to populate.
• Identify and suggest existing or new emerging standards and best practices.
• Manage and monitor job schedules and provide fix for any failed schedules/jobs.
• Data cleansing, modeling (physical and logical), profiling, enterprise data architecting, data quality and data governance
• Collaborate with technical team to maintain BODS server architecture, data governance and end-end processes.
• Performance tuning of BODS ETL and data models.
• Use the local repository metadata to generate reports for input into program and management reporting cycles.
• Move the projects from DEV to SIT, SIT to UAT and UAT to PRD.
• Schedule transformation jobs in Management Console to produce data load files in text format for loading via LSMW or directly into SAP tables and structures.
• Use Business Objects Data Integrator (BODI) to create projects, batch jobs, workflows and dataflows.