Data Engineer

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.

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.