Data Engineer

Goodville Mutual Casualty Company; New Holland, Northern (Lancaster County, KY); Hybrid; USD 110,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 build robust ETL pipelines. The role ensures a scalable data infrastructure aligned with business needs and requires extensive experience in P&C insurance data environments.

The position involves in-office work three days a week at 625 W Main St, New Holland, PA, with two remote days approved by HR. Domestic travel to various offices and vendor sites is required.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 60 months of data engineering experience in Property & Casualty insurance.
• 60 months of ETL development experience in Property & Casualty insurance.
• 60 months’ experience using ETL/data integration tools (SSIS, PySpark/PySQL or equivalent).
• 60 months’ experience with cloud-based data orchestration, messaging, and serverless computing (SQL, SSIS, ADF, Azure Service Bus, Azure Functions or equivalent).
• 60 months’ experience with relational databases (SQL Server, DB2, Azure SQL, Fabric Lakehouse) and performance tuning.
• 60 months’ experience with API technologies (REST, SOAP, XML, JSON) and scripting (Python, Shell) for automation.

Responsibilities

• Lead efforts to optimize data workflows and ETL pipelines.
• Enhance database performance and data infrastructure scalability.
• Align data architecture with business needs and strategy.
• Collaborate with cross-functional teams to deliver robust data solutions.

Skills

Data engineering

ETL development

SQL & databases

Cloud data orchestration

REST/SOAP integration

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

PySpark/PySQL

Azure Functions

Azure Service Bus

Azure SQL

SQL Server

DB2

Fabric Lakehouse

REST API

SOAP API

XML

JSON

Python

Shell

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.