Senior Data Engineer – Insurance Data Platform

CCMSI is a leading Third Party Administrator that partners with global clients to address complex risk management challenges. They are seeking a Senior Data Engineer to design and maintain data pipelines that facilitate the movement of insurance data into analytics platforms, ensuring data accuracy and reliability for decision-making and reporting.

Responsibilities:

• Design, build, and maintain ELT/ETL pipelines moving data from our claims administration system (iCE), policy admin, medical bill review, banking, and third-party vendor feeds into our cloud data warehouse
• Own the data models for core insurance objects — claims, policies, coverages, reserves, payments, recoveries, exposures, units, and loss development triangles — and make sure they hold up under actuarial scrutiny
• Build and maintain integrations with external vendors and partners — medical bill review (MBR), pharmacy benefit managers (PBM), bureau reporting (NCCI, state bureaus, ISO), excess carriers, and client BI environments
• Develop and support the data feeds that drive client loss runs, board reports, and self-insured trust deliverables
• Build and maintain data quality monitoring, anomaly detection, and reconciliation processes
• Partner with the actuarial and analytics teams on loss development, IBNR, and trending data structures — including the triangle data that feeds reserve studies
• Support state and federal regulatory reporting data needs (EDI claims reporting, Medicare Section 111)

Requirements:

• 5+ years working with insurance data in a carrier, TPA, MGA, broker, or insurance-tech environment
• Deep working knowledge of claims data structures — claimants, coverages, reserves (indemnity, medical, expense), payments, recoveries, financial transactions, and the relationship between policy and claim
• Experience with at least one major claims administration system
• Familiarity with workers' compensation and/or general liability claims data specifically — jurisdictional rules, body parts, ICD/CPT codes, NCCI class codes, etc
• Comfortable with insurance financial concepts: paid vs incurred, case reserves vs IBNR, loss development, reinsurance recoveries, deductibles, SIRs, and aggregate stop-loss
• 8+ years total professional data engineering experience
• Expert SQL — window functions, recursive CTEs, query tuning, execution plans
• Strong Python for data work (pandas, PySpark, SQLAlchemy, plus general-purpose Python — APIs, testing, packaging)
• Production experience with at least one modern cloud data warehouse (Snowflake, Databricks, BigQuery, Synapse, or Redshift)
• Solid experience with an orchestration tool
• Comfortable with one or more ELT tools
• Experience with cloud infrastructure — Azure preferred. IaC experience (Terraform/Bicep/CloudFormation) a plus
• Git, CI/CD, code review as a normal part of how you work
• Bachelor's degree in CS, MIS, math, statistics, or equivalent experience
• Clear written and verbal communication
• You can work independently in a remote-first environment without anyone hovering
• Direct experience with TPA platforms
• Experience with EDI claims reporting (IAIABC formats), Medicare Section 111 reporting, or state-specific filings
• Exposure to actuarial reserving software and the data structures they consume
• Experience with medical bill review data and PPO/network logic
• Streaming/event experience — Kafka, Kinesis, Event Hubs, Debezium
• ML/feature-engineering experience supporting predictive models (claim severity, litigation propensity, fraud, return-to-work)
• Experience with HIPAA, SOC 2, or similar compliance regimes — claims data is regulated, and you should be comfortable working inside those guardrails
• Prior TPA, self-insured group, or public entity pool experience