Job Title
Data Integration Specialist and EDI Developer
Job Type
Full-time
Category
Information Technology
Location
FAIRFAX - , VA 22030 US (Primary)
Education
Bachelor's Degree
Travel
0 - 10%
Job Description
You build and run the EDI and secure file exchanges between the Stockpile's Oracle systems and the third-party warehouses that hold the stock, and you make sure a transaction is validated, reconciled and explained before it changes an inventory balance. Full time, W-2, based in Fairfax, Virginia with some telework, starting October 2026.
What you will do- Implement and support X12 EDI transaction sets with 3PL warehouse partners (850, 855, 856, 940, 943, 944, 945, 947, 997 and related), across 004010 and 005010 as partners require, over AS2 and SFTP.
- Onboard trading partners: mapping, envelopes, acknowledgments, test cycles and certification.
- Build data quality validation into EDI processing: schema and business rule checks, quarantine, reconciliation and exception management with clear reporting.
- Reconcile inventory positions between Oracle and warehouse systems; investigate and resolve discrepancies with the data quality team.
- Monitor the interfaces, handle failures inside the service levels, and document every map and partner setup.
What you need- 5 or more years of EDI and data integration development, including X12 supply chain transaction sets and AS2 or SFTP transport.
- Data quality validation in EDI processing, and reconciliation and exception management.
- Mapping and transformation tools (an EDI translator, Oracle Integration Cloud or similar).
- SQL and the ability to trace a transaction end to end.
- U.S. citizenship and the ability to obtain an HHS Tier 2 public trust determination.
What sets a candidate apart- Oracle E-Business Suite inventory and order interfaces.
- Warehouse management system integrations (Manhattan, Blue Yonder, SAP EWM or similar).
- Healthcare, pharmaceutical or regulated supply chains.
- Oracle Integration Cloud.
BenefitsPay is discussed with you directly when we speak. These are the benefits every full-time SPN employee receives.
- Medical and prescription coverage, dental and vision, with employer-subsidized premiums for employees and dependents
- 401(k) with employer match
- Group life insurance at no cost to you
- Short-term and long-term disability
- Paid time off, 11 federal holidays, paid sick leave, bereavement leave
- Parental leave
- Certification reimbursement (Oracle, OCI, AWS/Azure, PMP, ITIL, Security+, CISSP and others), an annual training budget and tuition assistance
Terms, and how to apply- Full time, W-2, salaried (exempt), employed by SPN Solutions
- Target start: October 2026
- Hybrid: based at SPN's office in Fairfax, Virginia, with some telework; occasional days at the customer's Atlanta, Georgia campus when the work requires it
- Core hours 9:00 a.m. to 3:30 p.m. Eastern, Monday to Friday, with flexible start between 6:00 and 9:00 a.m. Eastern; federal holidays off
- You must be a U.S. citizen and obtain and keep an HHS Tier 2 (moderate risk) public trust determination; no security clearance is required
- You complete HHS security, privacy and records management training before access, and cGMP training shortly after you start
- Work is done on customer-furnished or SPN-furnished equipment under HHS security rules
Apply through the link with your resume; it takes a few minutes and no cover letter is needed. A recruiter reads every application and answers within two business days. The process is short: one conversation with a recruiter, one technical conversation with the team, then a decision.
Keywords: EDI Developer, Data Integration Specialist, X12, 850, 856, 940, 945, 997, AS2, SFTP, trading partner onboarding, reconciliation, exception management, 3PL, warehouse management, Oracle Integration Cloud, Oracle EBS, supply chain, public trust, Fairfax VA, Northern Virginia, hybrid
