SAP BRIM Data Analyst

Remote (Onsite when needed)

Description:

DSI is searching for a SAP BRIM Data Analyst who will have the responsibilities listed below.

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 by the PTC.
  
  

Requirements:

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

Preferred Skills:

• Enterprise Business Solutions, specifically SAP projects.
• ITIL / ITSM practices and methodologies.
  
  

About Diversified Systems

Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion

DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.