Data Engineer - Python/SQL

The Senior Client Integration Data Engineer plays a crucial role in onboarding new clients by optimizing data imports, extracts, and automation processes. This position requires expertise in healthcare data exchange standards, including HL7 (ADT, ORU, SIU), X12 (270/271, 837/835), NCPDP, and FHIR, as well as EPIC, Cerner, and MediTech systems and data formats.

Proficiency in SQL, RDBMS, Python, or C#, along with experience in cloud-based ETL tools (e.g., Databricks, Azure Data Functions, EasyMorph), is essential. The ideal candidate has 8+ years of experience in healthcare data engineering with a strong understanding of data security and compliance (HIPAA, HITRUST).

Key Responsibilities :

- Act as an SME and liaison between Client Implementation and Data Engineering for data ingestion and extraction.

- Analyze and document existing client configurations and data exchange requirements.

- Design and build scalable, standardized imports and extracts to replace legacy data feeds.

- Conduct gap analyses between client-provided data specifications and Aspirions standards.

- Assist clients in aligning with Aspirions data specifications and maintain a repository of standardized responses and best practices.

- Configure Aspirion platforms for new client data integration and ensure compatibility.

- Implement automated testing and validation processes to ensure data exchange stability and integrity.

- Identify, troubleshoot, and resolve data issues during UAT, QA, and post-go-live Hypercare support.

- Escalate unresolved issues, standardization needs, and deviations from data specifications.

- Develop and maintain clean, efficient code in Python or C# while leveraging cloud platforms (Azure, AWS, or Google Cloud) for automation.

- Ensure compliance with HIPAA, HITRUST, and other data security standards, including data encryption, access control, and audit logging.

- Collaborate with cross-functional teams using Agile methodologies, CI/CD pipelines, and version control (Git) to streamline data integration workflows.

- Continuously optimize data processing workflows for improved efficiency and performance.

Required Skills & Qualifications :

- Bachelors degree in Computer Science, Software Engineering, Data Science, or a related technical field.

- 0 to 5 years of experience in data engineering within the healthcare industry.

- Strong experience in ETL, data integration, and healthcare data formats.

- Proficiency in programming and database technologies : SQL, Azure Data Factory, Databricks, EasyMorph, Python, or C#.

- Experience with healthcare revenue cycle data : Expertise in HL7, X12, FHIR, NCPDP, and healthcare data interoperability.

- Experience with EPIC, Cerner, and MediTech systems and data formats.

- Cloud expertise : Hands-on experience with Azure, AWS, or GCP for data management and automation.

- Understanding of modern software design patterns : Microservices architecture, RESTful API development.

- Hands-on experience with development tools : Git, automated testing, DevOps methodologies.

- Strong analytical and problem-solving skills : Ability to troubleshoot and optimize data processes.

- Excellent communication skills : Ability to collaborate across teams and with stakeholders.

- Self-motivated and adaptable : Ability to thrive in a fast-paced, dynamic environment.