Data Migration Developers x 2

Westney Consulting Group; Plymouth; Hybrid; GBP 45,000 - 50,000; Full time

Job summary

A leading consulting group seeks a Data Migration Specialist skilled in BODS ETL to join their team. This hybrid position requires expertise in developing data migration processes for SAP and non-SAP solutions, alongside managing data quality and governance standards. As part of a small, dedicated team, you will contribute to challenging and stimulating projects, ensuring effective data migration and integration across systems. Applicants must be sole British Nationals eligible for BPSS/SC and NPPV clearance.

Qualifications

• Expertise in SAP Data Extraction process and BODS Jobs development.
• 3+ years experience in designing or delivering BODS ETL solutions.
• Experience in a complex organisation with proven technical contributions.

Responsibilities

• Design and develop SAP BODS jobs for data conversion and integration.
• Manage and monitor job schedules and provide fixes for failures.
• Collaborate with technical teams to maintain data governance.

Skills

Data Modeling

Data Architecture

SAP Data Extraction

ETL Specification Writing

Education

Bachelor's Degree in Information Systems

Tools

BODS ETL Toolset

SAP

Data Stage ETL

Job description

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.
  
  

Essential

• Data modeling and data architecture skills using BODS ETL toolset
• Expertise in SAP Data Extraction process BODS Jobs development.
• Evidence of working in a challenging and complex organisation and demonstrable experience of contributing to a technical change.
• Good experience of understanding and writing Data Stage ETL specifications and delivery of technical solutions to an agreed standard.
• Experience delivering solutions to an agreed standard using industry standard methodologies.
• Proven experience working in a small team delivering technical solutions to project requirements.
• Bachelor's Degree in an Information Systems Field or preferably at least 3 years plus experience designing and/or delivering BODS ETL solutions/programs.
  
  

Desirable

• Business Objects Data Services certifications (highly desirable).
• Experience in one or more SAP full lifecycle implementations using SAP BODS ETL toolset.
• Knowledge of Master Data Management and SAP MDM/MDG products.
• Experience in SAP functional areas such as Finance, Cost Controlling, Supply Chain, Contract Management and Plant Maintenance.
• Fusion People are committed to promoting equal opportunities to people regardless of age, gender, religion, belief, race, sexuality or disability. We operate as an employment agency and employment business. You'll find a wide selection of vacancies on our website.