Senior Data Engineer

Role Description

The Senior Data Engineer has a firm grasp of insurance data and serves as the owner and designer of data pipelines which moves claims, policy, billing, medical, and financial data from our core administration systems into our analytics platform, and from there into client-facing reporting, internal dashboards, and ML models. This is a builder role which architects, writes code, mentors junior engineers, and partners directly with claims operations, actuarial, finance, and CCMSI’s client services teams to transform operational data into usable format for decision making. Accuracy, scalability, and reliability are critical—this data supports client reporting, regulatory filings, and financial decision-making.

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.
• Support state and federal regulatory reporting data needs (EDI claims reporting, Medicare Section 111).

Qualifications

• 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.
• 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).
• 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.
• 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.
• Ability to work independently in a remote-first environment.

Preferred Experience

• 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.
• Experience with HIPAA, SOC 2, or similar compliance regimes.
• Prior TPA, self-insured group, or public entity pool experience.

What Success Looks Like

• First 90 Days: 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.
• First 6 Months: 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.
• First Year: 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.

Benefits

• 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).
• Internal training and advancement opportunities.
• A supportive, team-based work environment.