Data Engineer — ETL Pipelines & Cloud, Hybrid (Remote)

Socket.dev; New Holland (Lancaster County); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Goodville Mutual Casualty Company is seeking a Data Engineer to lead optimization of data workflows, improve database performance, and develop robust ETL pipelines. The role will ensure scalable data infrastructure aligned with business needs and travel between offices as required.

The candidate should have extensive experience in data engineering for Property & Casualty insurers, including ETL development, relational databases, and cloud-based data orchestration.

Qualifications

• 60 months of data engineering experience in a Property & Casualty insurer.
• 60 months of ETL developer experience in a Property & Casualty insurer.
• Experience with ETL/data integration tools and distributed processing.
• Experience with relational databases and performance tuning.

Responsibilities

• Lead efforts to optimize data workflows and pipelines.
• Enhance database performance and scalability of data infra.
• Develop robust ETL pipelines aligned with business needs.

Skills

ETL development

SQL

Python scripting

Cloud data orchestration

REST/SOAP/XML/JSON

Education

Bachelor's degree in Computer Science / related field

Tools

SSIS

PySpark / PySQL

ADF

Azure Service Bus

Azure Functions

SQL Server

DB2

Fabric Lakehouse

Job description

Goodville Mutual Casualty Company is seeking a Data Engineer to lead optimization of data workflows, improve database performance, and develop robust ETL pipelines. The role will ensure scalable data infrastructure aligned with business needs and travel between offices as required.

The candidate should have extensive experience in data engineering for Property & Casualty insurers, including ETL development, relational databases, and cloud-based data orchestration.