SAP BRIM Data Engineer or Analyst (Hybrid)

DMS Vision•Frisco, PA

1d•Hybrid

About The Position

The SAP BRIM Data Engineer / Analyst will be responsible for understanding source data, querying legacy data, and analyzing it using strong SQL and PL-SQL skills. This role involves merging data from multiple sources for loading into target systems, collaborating with Microsoft Dynamics Specialists to develop a target system data dictionary, and transforming/loading data from legacy systems into SAP BRIM across various components. The analyst will also analyze legacy system data structures, extract data, perform source-to-target mapping, define and maintain business rules, and use ETL tools for data transformation. Data cleansing, validation, and implementation of data masking/hashing are key responsibilities. The role requires planning and overseeing the data migration schedule, performing delta loads for high-volume data, validating data integrity, and performing high-volume data reconciliation. Collaboration with functional consultants, business analysts, and technical teams, participation in data migration workshops, and documentation of processes are also essential. The position requires creating data migration runbooks for future reference.

Requirements

5 years' experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud required
Experience on at least 2 full-cycle SAP S/4HANA implementation migrating extremely high volume of data required (15+ million customer records, and 1+ Billion transactions) required
5 years of using BODS for transformation and loading data into SAP is required
Strong expert level PL-SQL, SQL skills required

Nice To Haves

Tolling experience is preferred
Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend is highly desired
8+ years desired experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud
Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions in highly desired
Ability to load data into non SAP systems high desirable

Responsibilities

Understand source data and query legacy data to analyze source data using strong SQL and PL-SQL skills
Merge data from multiple data sources to be loaded into the target systems
Collaborate with Microsoft Dynamics Specialist to develop overall target system data dictionary
Transform and load data from legacy systems into SAP BRIM across components in scope, including SAP S/4HANA (Subscription Order Management, Convergent Invoicing, Financial Contract Accounting, Banking, Sales & Distribution, Materials Management), Convergent Mediation, and Convergent Charging
Analyze legacy system data structures and extract structured and unstructured data from legacy data sources
Perform source to target mapping to map data fields from legacy systems to SAP BRIM data structures
Define, develop, and maintain business rules and cross-referencing tables
Transform data using ETL (Extract, Transform, Load) tools, including SAP BODS, ADMM, MS SQL-S
Cleanse and validate data to ensure accuracy and consistency
Implement Data Masking or Data hashing so no PII data is included in lower environments
Plan and oversee detailed schedule and progress against milestones
Perform delta loads for extreme high volume transformed data into SAP BRIM using standard migration tools in a timely and extremely efficient timeframe to minimize downtime for migration
Validate data integrity and resolve any discrepancies
Perform high-volume data reconciliation for technical verification and business validation
Work closely with functional consultants, business analysts, and technical teams
Participate in data migration workshops and provide expertise
Document data migration processes, mappings, and validation rules
Create data migration runbooks for future reference