Goodville Mutual Casualty Company ยท 3 months ago
Senior ETL Developer I
New Holland,PA,US
Full-time
Onsite
Senior Level
5+ years expGoodville Mutual Casualty Company is seeking a Senior ETL Developer I responsible for designing, testing, and maintaining ETL processes that integrate data into their insurance data warehouse. The role involves collaborating with stakeholders to understand business requirements and developing technical solutions to support business intelligence and reporting needs.
Insurance
Responsibilities
Design and develop ETL workflows to extract data from various internal and external sources, transform it according to business rules, and load it into Insurance focused data repositories, ensuring data integrity and quality
Develop mapping requirements, documenting data movement and transformation rules
Design, architect, and implement data marts for Personal, Commercial, and Farm insurance data
Collaborate with business users, IT, and other stakeholders to understand business requirements, develop architectural requirements and translate them into technical solutions
Develop and maintain technical documentation for ETL processes, data models, and other related artifacts
Optimize ETL processes for performance and scalability
Participate in code reviews and contribute to best practices for ETL development
Troubleshoot and resolve ETL-related issues and defects
Support the IT team with other duties as assigned
Perform other duties as assigned by supervisor
Qualification
Required
Bachelor's or Master's degree in Computer Science, Information Systems, or a related field required
5+ years of experience in ETL development using Informatica PowerCenter, SQL Server Integration Services, Python, or equivalent required
Strong SQL skills and proficiency in relational databases such as Oracle, SQL Server, or MySQL required
Experience with data integration technologies such as REST, SOAP, XML, and JSON required
Strong communication and collaboration skills required
Some cloud exposure, preferably Azure and/or Snowflake required
Ability to self-manage and stay on track with commitments; resourceful in solving problems and removing impediments required
Ability to think creatively, champion new ideas, and challenge the status quo required
Ability to work flexible hours, travel to all organization offices (including in Pennsylvania, Ohio, and South Dakota) and travel to vendor work sites required
Ability to work in an office environment with moderate noise level, remain in a stationary position and operate a computer a majority of the time required
Ability to move throughout the office to access work materials and to move work materials weighing up to ten pounds daily required
Ability to perform the essential functions of the job with or without reasonable accommodation required
Preferred
3+ years of experience in Property & Casualty insurance
Familiarity with agile software development methodologies
Company
Goodville Mutual Casualty Company
Goodville Mutual was founded in 1926 by a small group of Mennonite aware of the growing need for automobile insurance in Lancaster County, Pennsylvania.
51-200 employees
H1B Sponsorship
Goodville Mutual Casualty Company has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
Funding
Current Stage
Growth StageRecent News
2023-10-12
FinTech Global
2023-01-17
Company data provided by crunchbase