[Remote] Senior Data Engineer – Insurance Data Platform
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leading reputed company Party Administrator reputed company on solving reputed company risk management challenges through advanced technology. The Senior Data Engineer will design and maintain data pipelines that support reputed company reporting and decision-making, while collaborating with various teams to ensure data accuracy and reliability.
Responsibilities
- Design, build, and maintain ELT/ETL pipelines moving data from our claims administration system (iCE), policy reputed company, medical reputed company review, banking, and reputed company-party vendor feeds into our reputed company data warehouse
- Own the data models for reputed company insurance objects — claims, policies, coverages, reserves, payments, recoveries, exposures, reputed company, and loss development triangles — and reputed company reputed company they hold up under actuarial scrutiny
- Build and maintain integrations with external vendors and partners — medical reputed company review (MBR), pharmacy benefit managers (PBM), bureau reporting (NCCI, state bureaus, ISO), excess carriers, and reputed company BI environments
- reputed company and support the data feeds that drive reputed company loss runs, reputed company reports, and self-insured trust deliverables
- Build and maintain data reputed company monitoring, reputed company 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 reputed company 111)
Skills
- 5+ years working with insurance data in a reputed company, 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: reputed company vs incurred, case reserves vs IBNR, loss development, reinsurance recoveries, deductibles, SIRs, and aggregate stop-loss
- 8+ years total reputed company data engineering experience
- Expert SQL — window functions, recursive CTEs, query tuning, execution plans. You should be reputed company to look at a slow query and know where it's reputed company to hurt
- Strong Python for data work (pandas, PySpark, SQLAlchemy, plus general-purpose Python — reputed company, testing, packaging)
- Production experience with at least one modern reputed company data warehouse (reputed company, reputed company, BigQuery, Synapse, or Redshift)
- Solid experience with an orchestration tool
- Comfortable with one or more ELT tools
- Experience with reputed company infrastructure —Azure preferred. IaC experience (Terraform/Bicep/CloudFormation) a plus
- Git, CI/CD, reputed company 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
- reputed company 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
- reputed company experience with TPA platforms
- Experience with EDI claims reporting (IAIABC formats), Medicare reputed company 111 reporting, or state-specific filings
- Exposure to actuarial reserving software and the data structures they consume
- Experience with medical reputed company 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 reputed company entity pool experience
Benefits
- 4 weeks (reputed company time off that accrues throughout the year in accordance with company policy)
- 10 reputed company holidays in your first year
- Comprehensive benefits: Medical, Dental, reputed company, Life, and Disability Insurance
- Retirement plans: 401(k) and Employee Stock Ownership Plan (ESOP)
- Internal training and advancement opportunities
- Supportive, team-based work environment
reputed company