NTT DATA North America · 2 weeks ago
VBA Developer - SAP Ariba Expertise Required
NTT DATA North America is a leader in IT and business services, and they are seeking a VBA Developer to automate processes related to SAP and Expandable systems. The role involves developing tools for data automation, ensuring data accuracy, and optimizing workflows to enhance operational efficiency.
ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
Responsibilities
ASN Data Automation: Develop a VBA-based tool to automatically intercept downloaded ASN files from Expandable and inject required serial/batch characteristics based on SAP-generated PO data
Multi-System Integration: Create scripts that interface with SAP, Expandable, and Ariba to ensure seamless data flow for serial-tracked items
Data Validation: Build logic to verify that batch numbers and serial characteristics in the ASN match the original SAP Purchase Order and Expandable Sales Order before final upload
Process Optimization: Transition the current 5-step manual process (Generating PO Expandable SO ASN Download Manual Update Ariba Load) into a streamlined, automated workflow
Error Handling: Implement robust error-trapping to flag discrepancies in batch characteristics or missing serial numbers during the file-update phase
Qualification
Required
7 years' experience with VBA: Advanced proficiency in Excel VBA, including FileSystemObject (FSO) for handling downloaded ASN files and XML/CSV manipulation
5 years experience working with SAP (GUI Scripting or BAPIs) and Expandable or similar manufacturing ERPs
3 years experience working with SAP Ariba upload templates and ASN requirements for supply chain collaboration
5 years experience with Data Management: Strong understanding of batch management and serial number tracking within a logistics or manufacturing environment
5 years experience with SQL/Database: Ability to query backend databases to retrieve characteristic values that may not be present in the initial ASN export
Preferred
Experience with SAP Ariba APIs or Power Automate for handling cloud-to-desktop file transfers
Knowledge of cXML or EDI formats often used in ASN transmissions
Benefits
Medical
Dental
Vision insurance
Flexible spending or health savings account
Life, and AD&D insurance
Short-and long-term disability coverage
Paid time off
Employee assistance
Participation in a 401k program with company match
Additional voluntary or legally required benefits
Company
NTT DATA North America
NTT DATA, Inc. is a trusted global innovator of business and technology services.
Funding
Current Stage
Late StageRecent News
2025-12-05
Company data provided by crunchbase