Data Integration Business Analyst (Full-Time, Remote, North Carolina Based)

The Data Integration Business Analyst elicits, analyzes, and documents business and technical requirements for enterprise data exchange and integration initiatives. This role translates requirements into integration specifications and test plans, supports the design and validation of ETL, API, and file-based interfaces, and ensures interoperability, data quality, and compliance (e.g., HIPAA) across internal systems and external partners.

This position is fulltime remote. Selected candidate must reside in North Carolina. Some travel for onsite meetings to the Home office at Morrisville may be required.

Responsibilities & Duties

Elicit & Document Integration Requirements

• Lead discovery to capture business goals, data requirements, and SLAs for data exchanges
• Produce source-to-target mappings (STMs), transformation rules, and interface control documents (ICDs)
• Clarify acceptance criteria and success metrics for each integration

Analyze & Profile Data

• Perform data profiling and gap analysis on source/target systems (e.g., HL7 v2/FHIR, X12/EDI 837/835, NCPDP, CMS-1500/UB-04, flat files, APIs)
• Identify data-quality issues; define validation rules and reconciliation processes
• Recommend code-set crosswalks and normalization approaches

Translate Requirements into Technical Specifications

• Develop detailed functional/technical specs for ETL (e.g., SSIS), APIs, and MFT/SFTP exchanges
• Partner with data engineers and application developers to align on patterns, standards, and reuse
• Support solution design reviews for scalability, security, and maintainability

Plan & Execute Testing

• Create test plans, test cases, and data sets for unit, system, and user acceptance testing (UAT)
• Coordinate UAT with business stakeholders; triage defects and manage retests
• Validate performance and throughput against SLAs

Support Implementation & Operations

• Assist with go-live readiness (runbooks, SOPs, cutover/backout plans)
• Monitor initial production runs, perform data reconciliations, and resolve issues
• Participate in incident response and root-cause analysis; document lessons learned

Maintain Documentation & Knowledge Base

• Maintain current interface inventories, data dictionaries, and lineage/flow diagrams
• Author and update end-user and technical documentation according to department standards

Communication & Collaboration

• Communicate complex topics to technical and non-technical audiences
• Collaborate with internal teams and external vendors to ensure alignment and timely delivery
• Contribute to data governance and interoperability standards

Continuous Improvement

• Recommend process improvements, reusable templates, and automation for mapping, testing, and monitoring
• Track and report integration KPIs (e.g., timeliness, error rates, data completeness)

Minimum Requirements

Education And Experience

Vocational or Technical Training in computer science, information systems, business administration, or a related field; and five (7) years of experience in data integration/interoperability, ETL, or data engineering; 

Or

Associate’s degree in computer science, information systems, business administration, or a related field; and six (6) years of experience in data integration/interoperability, ETL, or data engineering;

Or

Bachelor’s degree in computer science, information systems, business administration, or a related field; and four (4) years of experience in data integration/interoperability, ETL, or data engineering.

Additional Required Experience:

Hands-on experience gathering requirements and producing source-to-target mappings and interface specifications.

Experience with data integration concepts and tools (e.g., ETL/ELT, SSIS), APIs (REST/JSON), and secure file transfer (SFTP/MFT).

Experience validating healthcare or payer/provider data sets and applying HIPAA privacy/security considerations.

Demonstrated ability to write SQL for data profiling, validation, and reconciliation.

Preferred:

Experience in a healthcare setting (payer, provider, HIE, HISPs) designing/supporting data exchanges (e.g., 837, 835, NCPDP, CMS-1500/UB-04, HL7 v2/FHIR).

• Experience with API management, Git/TFS/DevOps, and CI/CD practices.
• Experience coordinating UAT and production cutovers for integrations.
• Knowledge, Skills, & Abilities
• Knowledge of and experience with SQL, preferably T-SQL 
• ETL/ELT concepts; SSIS or similar
• Data mapping, STMs, ICDs
• APIs (REST/JSON), basic .NET or equivalent familiarity
• Healthcare data formats (HL7 v2/FHIR, X12/EDI 837/835, NCPDP)
• DW/star schema awareness; data lineage
• SDLC, requirements management, and testing practices
• Communication, facilitation, and documentation
• Ability to work independently and in a team setting

Employment for this position is contingent upon a satisfactory background check and credit check, which will be performed after acceptance of an offer of employment and prior to the employee's start date. 

Salary Range

$91,884-$119,450/Annually

Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity. 

An excellent fringe benefit package accompanies the salary, which includes:  

• Medical, Dental, Vision, Life, Long Term Disability
• Generous retirement savings plan
• Flexible work schedules including hybrid/remote options
• Paid time off including vacation, sick leave, holiday, management leave
• Dress flexibility