SAP BRIM Data Analyst-Engineer

Candidates can be located anywhere within the USA, and the rates need to be all-inclusive including travel costs for the on-site requirements.

Note: Hybrid work environment is expected to be 1-week per month on-site in Middletown PA, varying with project needs.

Position Summary

We are seeking an SAP BRIM Data Analyst and an SAP BRIM Data Engineer to add to our team assisting the Pennsylvania Turnpike Commission (PTC) Information Technology (IT) Department. The PTC is engaging in an exciting and innovative technology solution to support their customer engagements; the solution is called the Unified Back Office Solution (UBOS). UBOS is an advanced back-office system that, when developed and deployed, will allow customers to engage with the PTC to address all their business needs, via a multitude of channels (web, mobile app, chatbot, chat, IVR, phone, social media, etc.). PTC is dedicated to transforming the customer engagement businesses through innovative technology and strategic insights. Their team is composed of passionate professionals committed to excellence and continuous improvement, and the team is growing.

• 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 an 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 schedules and progress against milestones.
• Perform delta loads for extremely 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.
  
  

Required Skills And Experience

• 5 Years: Experience as an SAP BRIM Data Analyst / Engineer in SAP S/4 HANA hosted in Azure cloud is required
• Strong expert level PL-SQL, SQL skills are required
• Experience on at least 2 full-cycle SAP S/4HANA implementations migrating extremely high volume of data is required
• 5 Years: Experience using BODS for transformation and loading data into SAP is required, and the ability to load into non-SAP systems is high desirable
• 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
• Experience migrating closed transactions to recreate historic customer information in SAP S/4 HANA so customers can dispute closed transactions in highly desired
• Tolling experience is preferred