SAP BRIM Analyst

Job Description -

SAP BRIM Analyst

Location: Middletown, PA Hybrid (Must report on-site for key phases of the project)

Duration: 1 year + extension

Need PA Candidates with DL

Experience: Candidates with state/federal experience and good communication skills

Position Summary:

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.

Must Have:

• 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.
• 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