SAP BRIM Data Analyst

Role: SAP BRIM Data AnalystLocation: Middletown, PA (Remote)Duration: 6+ MonthType: Contract

Note:The resource shall attend on site meetings at one of the PTC Middletown PA locations based on the schedule set by the PTC.

Job Description:

Understand source data and query legacy data to analyze source data using strong SQL and PL-SQL skillsMerge data from multiple data sources to be loaded into the target systemsCollaborate with Microsoft Dynamics Specialist to develop overall target system data dictionaryTransform 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, and Materials Management), Convergent Mediation, and Convergent ChargingAnalyze legacy system data structures and extract structured and unstructured data from legacy data sourcesPerform source to target mapping to map data fields from legacy systems to SAP BRIM data structuresDefine, develop, and maintain business rules and cross-referencing tablesTransform data using ETL (Extract, Transform, Load) tools, including SAP BODS, ADMM, MS SQL-SCleanse and validate data to ensure accuracy and consistencyImplement Data Masking or Data hashing so no PII data is included in lower environmentsPlan and oversee detailed schedule and progress against milestonesPerform 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 migrationValidate data integrity and resolve any discrepanciesPerform high-volume data reconciliation for technical verification and business validationWork closely with functional consultants, business analysts, and technical teamsParticipate in data migration workshops and provide expertiseDocument data migration processes, mappings, and validation rulesCreate data migration run books for future referenceDevelop 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.Training / Experience Desired or Required:

Tolling experience is preferredExperience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backend is highly desired5 years' experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloud required with 8+ years desiredExperience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions in highly desiredExperience 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) required5 years of using BODS for transformation and loading data into SAP is required and with ability to load into non SAP systems high desirableStrong expert level PL-SQL, SQL skills requiredEquivalent 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.Engagement Requirements:

Candidate's location is preferred to be within the Continental United States.Successfully complete ePATCH background check and Clear Checks National Criminal Background Check prior to engagement start.Overtime requests always need to have prior approval of Project Principal with the rightful reasons for overtime.This position is primarily remote; however, this position will require reporting to the Commission's headquarters during key phases of the project - Solution Confirmation, Program Increment Cycles (PI), Showbacks, System Integration Test Cycles (SITs), User Acceptance Test (UAT), Go-Live, Immediately Post- Go-Live (Hypercare). Any absence from sessions requires prior approval from Project Principal.The resource shall attend on site meetings at one of the PTC Middletown PA locations for 1 week per month based on the schedule set by the PTC.Any assigned PTC Equipment must be picked up in-person, by the resource, at the PTC's Middletown, PA office. Travel costs associated with picking up this equipment will not be reimbursed.Travel expenses submitted for reimbursement must adhere to federal GSA guidelines governing hotel, mileage, and meals per diem rates, and must include appropriate expense documentation (receipts). GSA Guidelines are available at: https://www.gsa.gov/travel/plan-book/per diemrates? Gsaredirect=portalcontent104877.No additional compensation for any travel required, if the resource is based within a 3-hour commuting distance. The rate is inclusive of any travel costs.Required Skills:

Experience as an SAP BRIM Data Specialist/Engineer/Analyst in SAP S/4 HANA hosted in Azure cloudExperience on at least 2 full-cycle SAP S/4HANA implementation migrating extremely high volume of data requiredUsing BODS for transformation and loading data into SAPStrong expert level PL-SQL, SQL skillsProficient in the Microsoft Office 365 suite of business software including Teams, Word, Excel, and PowerPointProficient in Microsoft ADO Testing Module.ITIL / ITSM practices and methodologies.Tolling experienceExperience in migrating data in systems leveraging Microsoft Dynamics as the CRM engine integrated with SAP S/4 HANA as the backendExperience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions