Job Description
Location: Middletown, PA - Local candidates preferred
Position Type: Remote, must report onsite for meetings and during key phases of project. Position Overview:
The SAP BRIM Consultant will manage data migration efforts, integrating legacy data into SAP S/4 HANA and Microsoft Dynamics systems with a focus on accuracy, performance, and compliance. This role requires hands-on expertise in data transformation, validation, high-volume data reconciliation, and ETL processes, as well as collaboration with functional and technical teams to ensure seamless, high-quality migration across critical project milestones.
Required Skills: - 5 years of experience as an SAP BRIM experience in SAP S/4 HANA hosted in Azure cloud
- Experience on at least 2 full-cycle SAP S/4HANA implementation migrating extremely high volume of data required
- 5 years of experience using BODS for transformation and loading data into SAP
- Strong expert level PL-SQL, SQL skills
- Proficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPoint
- Proficient in Microsoft ADO Testing Module.
Preferred Skills: - ITIL / ITSM practices and methodologies.
- Tolling experience
- Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend
- Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions
Duties: - 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
- Develop and maintain a productive working relationship with technology staff, business owners, project sponsors, vendors, and key clients.
- Lead and participate in project team activities for system work efforts related to enterprise systems.
Job Tags
Contract work, Work at office, Local area, Remote work,