Healthcare Claims Data Engineer
Description
Company Description: ClaimInformatics, Inc. provides independent payment integrity and fiduciary compliance services for self-funded health plans, their third-party administrators (TPAs), and advisors. The company delivers conflict-free oversight of healthcare claims and governing contracts, helping plan sponsors protect plan assets and document prudent processes required under ERISA. ClaimInformatics reviews every claim against authoritative coding and payment standards, as well as key contracts such as ASO, SPD, PBM, and stop-loss agreements. Organizations may engage ClaimInformatics for full-service claims review or license its platform to run payment integrity in-house, with a core commitment to healthcare claims transparency. Based in Bloomfield, CT, the company has identified significant claim errors and maintains a 100% claims review rate without sampling.
Role Description: Healthcare Claims Data Engineer is a full-time, remote role responsible for designing, building, and maintaining data pipelines that support claims analysis and payment integrity operations. This role will work with healthcare claims data from multiple sources, implementing ETL processes to ingest, transform, and validate large datasets for downstream analytics and reporting. The Data Engineer will develop and optimize data models and data warehouse structures that ensure accuracy, performance, and scalability for internal teams and client-facing platforms. Day-to-day responsibilities include collaborating with analysts and product teams to understand data requirements, improving data quality and integrity, and implementing best practices for data governance, security, and documentation. The role also involves troubleshooting data issues, monitoring data workflows, and contributing to enhancements of ClaimInformatics’ claims transparency platform.
Qualifications
- Data engineering and ETL: Design, build, and maintain robust data pipelines and workflows that integrate, cleanse, and transform data from diverse healthcare and claims systems. Hands-on experience with Python/PySpark, Scala, and Java, including cloud partitioning, dropDuplicates semantics, and techniques for avoiding full scans.
- Data modeling and warehousing: Structure healthcare claims data for efficient storage and retrieval using AWS Glue, PySpark/Spark, Athena, S3, Lambda, Iceberg (or an equivalent table format), and PostgreSQL.
- Data analytics: Support claims analysis, quality checks, performance tuning, and insight generation.
- Healthcare claims domain: Experience with US-based healthcare claims data, including familiarity with coding and payment standards, is highly beneficial. Working knowledge of claim file formats and record layouts, including 837 electronic data interchange (EDI) files, the UB-04 hospital claim form, and the CMS-1500 professional claim form. Strong understanding of medical terminology, International Classification of Diseases, 10th Revision (ICD-10) diagnosis codes, Current Procedural Terminology (CPT) and Healthcare Common Procedure Coding System (HCPCS) codes, revenue codes, and commercial and Medicare billing and coding guidelines.
- Software hygiene: Git, PR reviews, pytest/unit testing, and migrations applied manually across environments.
- Technical foundation: Proficiency with SQL and at least one programming language commonly used in data engineering (e.g., Python, Scala, or Java). Experience with modern data platforms and tools (e.g., cloud data warehouses, ETL frameworks, workflow orchestration tools) is preferred.
- Education: Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
- Working style and communication: Strong attention to detail, commitment to data accuracy, and ability to work independently in a remote, collaborative environment. Proficient English speaker who can clearly articulate findings, caveats, and ticket comments to non-technical stakeholders, such as analysts and clients.
Skills
Sign in to read and join the discussion.