Sr. EDI Engineer & Data Architect

Intellivo • Memphis, TN

4d • Remote

About The Position

This role owns the front door of data intake and everything immediately behind it, combining EDI engineering and data architecture. The intake half focuses on movement and fidelity: onboarding trading partners, interpreting companion guides and file specs, and parsing and validating incoming data (X12 EDI transactions, flat files, and other structured or unstructured data files) to prevent silent drops, duplication, or mistranslation. The data architecture half focuses on shaping raw transactions and files into member, provider, claim, and payment models for business querying. The role involves extensive use of SQL, the Microsoft Fabric and Azure data stack, and AI tools for tasks like mapping acceleration, extracting structure from unstructured data, and anomaly detection. As a small company, this position sets the data standard. This is a remote position, with a preference for candidates in or around Memphis, TN.

Requirements

• 8+ years in data engineering, EDI engineering, or data architecture, with substantial time spent on healthcare claims data.
• Deep hands-on experience with HIPAA X12 5010 transactions, particularly 837 and 835, including acknowledgment and error handling.
• Experience with an EDI translation or integration platform, or with maintaining custom parsers and mapping logic.
• Hands-on experience onboarding data partners and working the clearinghouse side of the pipe.
• Expert SQL skills, including complex joins, window functions, stored procedures, and performance tuning on large tables.
• Strong data modeling background, including dimensional modeling and modern lakehouse or medallion layering.
• Experience with Microsoft Fabric and the Azure data stack, such as Data Factory, Synapse, Data Lake, and Delta or Parquet formats.
• Working knowledge of healthcare code sets and claims reference data.
• Practical, day-to-day use of AI tools in engineering work, with judgment about where they help and where they should not be trusted.
• Proficiency in Python or a comparable language for data work.
• Precision: Ability to hold both transaction-level detail and the architecture it rolls up into.
• Solid engineering habits: version control, testing, code review, reproducibility, and documentation.
• Comfort working with imperfect, inconsistent, real-world data from many different senders.
• Clear communication of data issues, tradeoffs, and root cause for both technical and business audiences.
• Self-starter with a track record of achievement who will roll up sleeves to tackle hard projects.

Nice To Haves

• Knowledge of healthcare and insurance data is strongly preferred.
• Microsoft Fabric or Azure data certification (e.g., DP-600 or DP-203) preferred.
• Healthcare data or HIPAA-related certification a plus.
• Experience with subrogation, third-party liability, coordination of benefits, or payment integrity data.
• Experience with member and provider matching, entity resolution, or master data management.
• Experience building semantic models and supporting business intelligence consumers.
• Experience in a SOC 2, HITRUST, or similarly audited environment.
• Experience with NCPDP pharmacy transactions.

Responsibilities

• Own the intake, parsing, translation, and validation of incoming data files, including X12 healthcare transactions (837 institutional, professional, and dental, 835 remittance, 834 enrollment, 270/271 eligibility, and 276/277 claim status, along with 999 and TA1 acknowledgment handling), as well as flat files (fixed-width, delimited, CSV) and other unstructured or semi-structured data sources (PDFs, scanned documents, attachments) received from trading partners and vendors.
• Onboard and maintain data partners and clearinghouses end to end: companion guide interpretation, mapping, connectivity, test and certification cycles, and production cutover.
• Design and maintain the claims data architecture from raw landing through curated, query-ready models, with clear layering, naming, and ownership.
• Model claims, member, provider, and payment data, including standard code sets such as ICD-10, CPT and HCPCS, NPI, revenue codes, and adjustment and remark codes.
• Write and tune complex, high-performance SQL against large claims data sets, including query optimization, indexing, and execution plan analysis when things run slow.
• Build and operate data pipelines in Microsoft Fabric and the Azure data stack: ingestion, transformation, orchestration, scheduling, alerting, and monitoring.
• Establish data quality and reconciliation controls: file-level and claim-level balancing, duplicate detection, rejection handling, and clean reprocessing paths when something needs to be run again.
• Handle inputs that are not neatly formatted, including flat files, spreadsheets, and document-based submissions, and bring them into the same governed model.
• Apply AI tools where they genuinely shorten the work: drafting and testing new partner mappings, extracting structure from unstructured files and attachments, detecting anomalies, and accelerating development and documentation.
• Spot opportunities in the data while organizing chaos and cutting through noise, and surface what the data can support that no one has asked for yet.
• Define data contracts, lineage, retention, and documentation so the pipeline is understandable by someone other than its author.
• Protect PHI throughout: access controls, minimum necessary, encryption in transit and at rest, and auditability.
• Set data engineering standards and raise the technical bar for how data work gets done here.

Benefits

• Comprehensive medical, dental, and vision insurance
• 401(k) retirement savings plan with employer match
• Paid time off and paid holidays
• Company-paid life insurance and short-term and long-term disability coverage
• Employee Assistance Program with counseling, financial coaching, legal resources, career coaching, and wellness support
• Health Savings Account with company contributions for eligible employees
• Wellness, healthcare advocacy, and pet benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Senior