Data Engineer

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

Description

Goodville Mutual Casualty Company seeks a Data Engineer. Responsible for leading efforts in optimizing data workflows, enhancing database performance, and developing robust ETL pipelines. Also responsible for ensuring the data infrastructure is scalable, efficient, and aligned with business needs.

Requirements

Three (3) days in office at 625 W Main St, New Holland, PA 17557; Two (2) days remote from home office approved by HR team according to company remote policies. Ability to perform domestic, monthly travel to all organization offices (including in Pennsylvania, Ohio, and South Dakota) and vendor work sites. Must have bachelor’s degree in Computer Science, information Systems, or a related field. Must have 60 months' experience working in data engineering for a Property & Casualty insurance company; and 60 months' experience working as an ETL developer for a Property & Casualty insurance company. Must have expertise as shown by 60-months’ experience:

• (1) Using tools for ETL/data integration, distributed data processing, programmatic database interaction, such as SSIS, PySpark/PySQL, or equivalent;


• (2) Using cloud-based data orchestration, asynchronous messaging, and serverless computing for querying and manipulating structured data, and performing ETL / data integration, with tools such as SQL, SSIS, ADF, Azure Service Bus, Azure Functions, or equivalent;


• (3) Working with relational databases with tools such as SQL Server, DB2, Azure SQL, Fabric Lakehouse and performance tuning techniques, or equivalent;


• (4) Using system integration technologies (API technologies) such as REST, SOAP, XML, and JSON, scripting languages (e.g., Python, Shell), or equivalent, for automation and data manipulation required, and implementing event driven data flows, and ETL pipeline design and development.

Goodville Mutual Casualty Company is an Equal Opportunity Employer.