SAP BRIM Data Analyst :: Middletown, PA (Hybrid) - ARK Solutions, Inc.
Middletown, PA 17057
About the Job
Ark Solutions Inc is looking for SAP BRIM Data Analyst!
Position: SAP BRIM Data Analyst
Location: Middletown, PA (Hybrid)
Duration: 7+ Months and possibility of extension
Description:
Day-to-day Responsibilities:
Training / Experience Desired or Required:
Position: SAP BRIM Data Analyst
Location: Middletown, PA (Hybrid)
Duration: 7+ Months and possibility of extension
Description:
Day-to-day 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
- 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.
- Work independently to accomplish the tasks and duties assigned.
- Adhere to and follow all PTC standards, policies, and procedures.
- Utilize various software and/or technology tools to perform job duties.
- Perform tasks and other duties as assigned.
Training / Experience Desired or Required:
- 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
- 5 years’ experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud required with 8+ years desired
- Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions in highly desired
- 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 and with ability to load into non SAP systems high desirable
- Strong expert level PL-SQL, SQL skills required
- Equivalent combination of education and/or experience may be accepted.
- Proficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPoint, plus proficient in Microsoft ADO Testing Module.
- Additional beneficial skills include:
- Enterprise Business Solutions, specifically SAP projects.
- ITIL / ITSM practices and methodologies.
| Skills | Required / Desired | Experience |
| Experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud | Required | 5 Years |
| Experience on at least 2 full-cycle SAP S/4HANA implementation migrating extremely high volume of data required | Required | |
| Using BODS for transformation and loading data into SAP | Required | 5 Years |
| Strong expert level PL-SQL, SQL skills | Required | |
| Proficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPoint | Required | |
| Proficient in Microsoft ADO Testing Module. | Required | |
| ITIL / ITSM practices and methodologies. | Desired | |
| Tolling experience | Desired | |
| Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend | Desired | |
| Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions | Desired |
Source : ARK Solutions, Inc.
