Senior Data Engineer – Insurance Data Platform

 

 

• →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. You should be able to look at a slow query and know where it's going to hurt.
• 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. We care more about what you can do than where you went to school.
• Clear written and verbal communication. You'll be talking to actuaries, claims VPs, and clients — not just other engineers.
• 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.

 

 

 

• Gain a strong understanding of CCMSI’s core data systems and architecture

• Deliver at least one meaningful pipeline improvement or enhancement

• Build relationships with key stakeholders across claims, actuarial, and client services

 

• Own a critical portion of the data platform end-to-end

• Improve data reliability, quality, or performance for key pipelines

• Actively mentor junior team members

 

 

• Recognized as the go-to person on claims/policy data architecture across IT and the business.

 

• Delivered on a strategic initiative — modernization, real-time data, or a major new client integration — that you helped scope and lead

• 4 weeks (Paid time off that accrues throughout the year in accordance with company policy) + 10 paid holidays in your first year
• Comprehensive benefits: Medical, Dental, Vision, Life, and Disability Insurance
• Retirement plans: 401(k) and Employee Stock Ownership Plan (ESOP)
• Career growth: Internal training and advancement opportunities
• Culture: A supportive, team-based work environment

At CCMSI, we believe in doing what’s right—for our clients, our coworkers, and ourselves. We look for team members who:

 

• Lead with transparency We build trust by being open and listening intently in every interaction.
• Perform with integrity We choose the right path, even when it is hard.
• Chase excellence We set the bar high and measure our success. What gets measured gets done.
• Own the outcome Every employee is an owner, treating every claim, every decision, and every result as our own.
• Win together Our greatest victories come when our clients succeed. 

 

 

 

 

#CCMSICareers #EmployeeOwned #GreatPlaceToWorkCertified #ESOP #TPA #DataEngineering #InsuranceData #CloudData #Analytics #RemoteJobs #IND123 #LI-Remote