Data Integration Specialist and EDI Developer

SPN Solutions Inc.; Fairfax (VA); Hybrid; USD 100,000 - 150,000; Full time

Benefits offered by this job

Medical and prescription coverage

401(k) with employer match

Group life insurance

Disability insurance

Paid time off & holidays

Certification reimbursement

Job summary

SPN Solutions Inc. in Fairfax, VA is hiring a Data Integration Specialist and EDI Developer. This full-time role focuses on building and running EDI exchanges between Oracle systems and third-party warehouses, ensuring validation, reconciliation, and clear explanations before inventory changes.

You will onboard trading partners, implement data quality checks, and maintain comprehensive documentation. Some telework is available, with core hours aligned to Eastern time.

Qualifications

• 5+ years in EDI and data integration with X12 sets.
• Experience with AS2 or SFTP transport and trading partner onboarding.
• SQL tracing and end-to-end transaction validation required.
• Experience with Oracle E-Business Suite inventory interfaces preferred.
• Knowledge of data quality checks and reconciliation processes.

Responsibilities

• Build and run EDI exchanges between Oracle systems and warehouses.
• Onboard partners: mapping, envelopes, test cycles and certification.
• Implement data quality validation, reconciliation and exception reporting.
• Reconcile inventory positions across Oracle and warehouse systems.
• Monitor interfaces, document maps and partner setups.

Skills

EDI development

X12 transactions

AS2/SFTP

SQL tracing

data quality validation

mapping & transformation

Education

Bachelor's Degree

Tools

EDI translator

Oracle EBS

Oracle Integration Cloud

Manhattan WMS

Blue Yonder WMS

SAP EWM

Job description

Data Integration Specialist and EDI Developer - (148)

Share this job as a link in your status update to LinkedIn.

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.

Why this job exists

SPN Solutions has won a new contract to operate and modernize the information systems behind the Strategic National Stockpile, part of HHS's Administration for Strategic Preparedness and Response (ASPR). The Stockpile holds the nation's reserve of medicines and medical supplies for public health emergencies. When a hurricane, an outbreak or another emergency calls for those supplies, the systems this team runs are how the country knows what it has, where it is and how fast it can move. The platform is Oracle E-Business Suite, and the program is moving it to Oracle Cloud while raising the quality of the inventory data and tightening the integration with the warehouse partners that hold the stock. You would join at the start, on a new team, with real work to own from the first week.

Why people take this job

• A mission you can explain at the dinner table: the nation's emergency medical supplies
• Hybrid in Fairfax, Virginia with some telework, sensible core hours and federal holidays off
• A modern Oracle stack and a real cloud migration, not a maintenance backwater
• A new team being built now: early hires shape how the work is done and grow with it
• Certifications and training paid for, with time set aside to earn them
• A company small enough that the people who run it know your name and answer your messages

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.

Pay 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

• 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

SPN Solutions is an Equal Opportunity Employer. All qualified applicants are considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. SPN participates in E-Verify.

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