Sr. EDI Engineer

Sr. EDI Engineer
Role Summary

Everything we do starts with claims data arriving correctly. This role owns that front door and everything immediately behind it.

It is two jobs that belong together. The intake half is about 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 — so that nothing is silently dropped, duplicated, or mistranslated on the way in. The engineering half is about what happens next: transforming raw transactions and files into reliable, query-ready data that the rest of the business can use with confidence.

You will live in SQL and you will be fluent in it, not just functional. You will work in the Microsoft Fabric and Azure data stack. We expect you to use AI tools as part of how you work, whether that is accelerating a new partner mapping, pulling structure out of an unstructured attachment, or flagging anomalies in a file that looks fine until it is not. We are a small company, so this seat sets the data engineering standard rather than inheriting one. This is a remote position; candidates in or around Memphis, TN are preferred.
Core 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.

- Build and maintain reliable, query-ready claims data pipelines and models from raw landing through curated data.

- Work with 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 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.

Experience

- 8+ years in data engineering or EDI engineering, 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.

- Han