Data Engineer

We're looking for a Data Engineer to design, build, and maintain reliable data pipelines and platforms that power analytics, reporting, and data products across a Property & Casualty (P&C) auto insurance business. You'll partner with actuarial, underwriting, claims, product, finance teams to deliver trusted, well-governed data that supports retention, loss modeling, fraud detection, customer experience.

Essential Job Functions:

• Build and maintain scalable batch and streaming data pipelines (ingestion, transformation, validation, and delivery).
• Integrate data from core insurance systems (policy administration, billing, claims, Contact management system).
• Model and curate analytical datasets (e.g., policy, quote, exposure, premium, loss, claim, payment, reserve, subrogation, salvage).
• Implement data quality checks, anomaly detection, and reconciliation for critical metrics
• Develop and maintain a data lake/warehouse (schema design, partitioning, performance tuning, cost optimization).
• Collaborate with governance, security, and compliance teams to implement access controls, PII handling, retention, and auditability.
• Operate data workflows in production: monitoring, alerting, incident response, SLAs, and root-cause analysis.
• Contribute to engineering best practices: CI/CD, infrastructure-as-code, testing, code reviews, and documentation.
• Perform other duties as assigned.

Experience/Qualifications:

• Bachelor's degree in computer science or technology related is preferred.
• 3+ years of experience in data engineering, Machine learning, with strong SQL skills and experience building dimensional or analytical models.
• Proficiency in at least one programming language: Python, Scala, or Java.
• Experience with modern data warehouses/lakehouses (e.g., Snowflake, BigQuery, Redshift, Databricks, Spark).
• Familiarity with data quality/testing (e.g., dbt tests, Great Expectations) and observability/monitoring patterns.
• Understanding of data security fundamentals (PII, encryption, role-based access control).

Preferred

• Experience in insurance, financial services, or other regulated industries
• Knowledge of P&C auto insurance concepts: underwriting, rating/pricing, claims lifecycle, reserves, exposure, reinsurance is a plus
• Knowledge with event/streaming systems (Kafka, Kinesis, Pub/Sub) and CDC tools (Debezium, Fivetran/HVR, etc.).
• Exposure to MLOps/data needs for fraud detection, pricing, or claims severity models is a plus.

Benefits

• Comprehensive health benefits including medical, dental and vision coverage
• Generous paid time off (PTO days, sick days, and holidays)
• Flexible spending options with FSA & HSA plans
• Life and AD&D insurance
• 401(k) with company match
• Voluntary benefits such as legal services, pet insurance, and identity & fraud protection
• 24/7 Employee Assistance Program (EAP) for employees and their families
• Health & wellness perks including gym discounts, wellness reimbursements, and reward programs
• Fun, engaging in-office events that support our culture

Physical Actions/Environment: Required job duties consist of prompt and regular attendance, ability to frequently move about the office to coordinate work with others; standing, sitting and typing for extended periods; and lifting and/or carrying up to 5 lbs. Ability to frequently communicate with others in-person, on the phone/virtually, and in writing. Ability to read, understand, process and evaluate large amounts of technical information and make related, informed decisions.

Salary: $100,000 - $120,000 annually based on experience

Schedule: We offer flexible work hours between 8:00 AM and 5:00 PM, with options like 8-4, 8:30-4:30, or 9-5. We do our best to support individual preferences, though schedules may be adjusted as needed to ensure strong coverage and teamwork.

We also offer a hybrid schedule: team members work onsite four days a week and can work remotely one day a week.

Location: Princeton, NJ

Disclaimer: This job description reflects management's assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned. This job description may be subject to change at any time.