Job Description
Data Integration Business Analyst (Full-Time, Remote, North Carolina Based) Join to apply for the Data Integration Business Analyst (Full-Time, Remote, North Carolina Based) role at Alliance Health.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) 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 associates 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 bachelors 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 up