Data Engineer

Goodville Mutual Casualty Company

$95K — $115K *
Finance & Insurance
15+ years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 5 years' experience in data engineering specifically for Property & Casualty insurance companies.
  • 5 years' experience as an ETL developer in the Property & Casualty insurance sector.
  • Proficiency in ETL/data integration and distributed data processing tools like SSIS and PySpark.
  • Strong skills in cloud-based data orchestration and asynchronous messaging using Azure tools.

Responsibilities

  • Lead initiatives to optimize data workflows and enhance database performance.
  • Develop and maintain robust ETL pipelines aligned with business requirements.
  • Ensure data infrastructure is scalable and efficient.
  • Conduct regular performance tuning of databases and ETL processes.
  • Coordinate travel to various organizational offices for project oversight.

Benefits

  • Flexible work environment with a mix of in-office and remote work days.
  • Opportunity for professional development through exposure to multiple states.
  • Involvement with cutting-edge data engineering technologies.
  • Collaboration with a focused team in the Property & Casualty insurance field.
Full Job Description
Job Type Full-time 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. Applicants for this position should submit resume using the URL in the link below or by mail to the attention of Mary Geist, 625 W Main St, New Holland, PA 17557.

Similar Jobs

More Jobs at Goodville Mutual Casualty Company

  • Software Developer II
    $70K — $95K *
    New Holland, PA 17557 (Lancaster County)
    Finance & Insurance
    In-Person
  • Director of Compliance
    $100K — $130K *
    New Holland, PA 17557 (Lancaster County)
    Finance & Insurance
    In-Person
  • Director of Compliance
    $90K — $120K *
    Napoleon, OH 43545 (Henry County)
    Finance & Insurance
    In-Person

More Finance & Insurance Jobs

Find similar Data Engineer jobs: