Client: State of Pennsylvania Job Title: SAP BRIM Data Analyst Duration: 07 Months Start Date: ASAP Location: Middletown PA 17057 (Remote) Position Type: Contract Interview Type: In person or Webcam Interview Ceipal ID: SPASAP735VH Requirement ID: PTC SAP BRIM Data Analyst (750735)
Note: The resource shall attend on site meetings at one of the PTC Middletown PA locations based on the schedule set by the PTC.
Responsibilities:
Understand source data and query legacy data to analyze source data using strong SQL and PLSQL 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 crossreferencing tables
Transform data using ETL (Extract Transform Load) tools including SAP BODS ADMM MS SQLS
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 highvolume 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 by the PTC.
Required/Desired/Highly desired Skills:
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 fullcycle 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 PLSQL 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. (Highly desired)
Tolling experience (Highly desired)
Experience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend (Highly desired)
Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions (Highly desired)
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR CA DE FL GA IL KY MD ME MI NC NJ NY OH OR PA SC TX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.