NTT DATA North America ยท 11 hours ago
VBA Developer - SAP Ariba Expertise Required
NTT DATA North America is a recognized leader in IT and business services, and they are seeking a VBA Developer to automate data processes within their 'Pull PO' workflow. The role involves developing a VBA-based tool for data automation and ensuring seamless integration between various ERP systems to enhance data accuracy in shipping notifications.
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, and 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.
H1B Sponsorship
NTT DATA North America has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (106)
2024 (182)
2023 (257)
2022 (871)
2021 (809)
2020 (1266)
Funding
Current Stage
Late StageRecent News
2025-12-05
Company data provided by crunchbase