Senior ETL Developer

Company Overview

Donegal Insurance Group is a regional property-casualty insurance company doing business in 23 states, headquartered in Marietta, PA, with 4 regional offices located in Athens, GA, Grand Rapids, MI, Albuquerque, NM, and Glen Allen, VA.

Donegal offers a broad range of personal and commercial insurance products sold exclusively through our network of independent agents. We are committed to the independent agency system and proud of the company's heritage, which spans over 130 years. Donegal's strong financial foundation and successful operating strategies have earned the company a rating of 'A' (Excellent) by the A.M. Best Company, the nation's leading insurance rating organization.

TITLE:                       Senior ETL Developer

JOB ID:                      426067

LOCATION:              Donegal Mutual Insurance Company, 1195 River Rd, Marietta PA 17547

DUTIES:

Design overall data storage, data files, and reporting structures for our internal customer business, consistent
with regulatory and product performance requirements. Complete the ETL (“extract, transform, load”) process by loading business data into the data warehousing environment, testing it for performance, and troubleshooting it before it goes into production. Prioritize and coordinate work in various stages across a pool of ETL developers. Responsible for all phases of solution delivery from initial requirements analysis, solution estimation, coordination of development, testing and delivery, to production. Translate requirements from the mapping specifications into technical code. Create, implement, maintain, and extend
common reusable data integration components. Monitor and promote data integration best practices across all work- streams. Ensure all data integration processes are documented and recoverable as it pertains to disaster recovery. Provide technical mentoring to peers, collaborate and be approachable to the team. Provide documented project and task updates to all concerned parties in a timely manner.

EDUCATION/REQUIREMENTS:

Bachelor’s degree (or foreign equivalent) in Computer Science or related industry field, plus 4 years of experience using Informatica ETL Software to design, load, and query dimensional and relational data models in data warehouse environments. Experience must include the following: 3 years of experience using PL/SQL for ETL relating to data warehousing and integration; reading and creating entity relationship (ER) diagrams and illustrating process flows; and using Oracle for database modeling. And 2 years of experience working with Guidewire Policy Center or DataHub; and working in either the Personal or Commercial line of the insurance industry. Remote work available up to 2 days per week; must work at Donegal Mutual Insurance Company’s office in Marietta, PA at least 3 days per week. Please apply at https://www.donegalgroup.com/careers. Job ID 426067.

To apply, please submit your resume and online application

Competitive Benefits Package

Donegal Insurance Group offers a comprehensive benefits package for all full-time, permanent positions including:

• Medical, Dental, and Vision Coverage: Available to you and your dependents. Coverage begins the first of the month after start date.
• 401(k) with the first 3% matched at 100%: the next 6% is matched at 50%
• Paid Time Off: Paid vacation, sick days, paid holidays, & bereavement days
• Career Development: Including college partnership discounts and industry designation(s) reimbursements

Additional benefits include company-paid basic life insurance; short & long-term disability insurance; employee stock purchase plan; and employee assistance program (EAP). Learn more about our full benefit offerings by visiting our Benefits page.

Who We Are

Donegal Insurance Group provides commercial and personal insurance products through a network of independent agents in 23 states and across several regions of the U.S. In Texas, Colorado, Utah, New Mexico and Arizona, business is conducted under the Mountain States Insurance Group name; and in Michigan, business is conducted under the Michigan Insurance name.

Headquartered in Lancaster County, Pennsylvania, along with four (4) regional offices located in: Athens, GA, Grand Rapids, MI, Albuquerque, NM, and Glen Allen, VA, our steady growth and successes have allowed us to establish a culture of which we're proud. Check out our Glassdoor profile where our rating speaks for itself:

By joining the Donegal family, you would be joining a team of dedicated, hard-working employees, all with a common goal of providing peace of mind to our policyholders and being There when it matters most.™.

Work Arrangement

Donegal Insurance Group has a variety of positions that are either onsite, hybrid, or remote. With each department and position being different, the work arrangement for a specific position will be reviewed with candidates during a initial phone screening. For a fully remote position, the ideal candidate must live within our Donegal footprint (Current approved states for remote work are: AL, AZ, CT, DE, FL, GA, IA, IL, IN, MD, MI, MN, MO, NC, ND, NE, NH, NJ, NM, NY, OH, PA, SC, SD, TN, TX, UT, VA, WI, and, WV. Please note, this list is subject to change without notice.)

E-Verify

Donegal Insurance Group participates in E-Verify in the following states: Alabama, Arizona, Florida, Georgia, Louisiana, Mississippi, Nebraska, North Carolina, South Carolina, Tennessee, and Utah. If you reside in one of the listed states, please review the "Notice of E-Verify Participation" and the "Right to Work Poster" on the links below:

• Notice of E-Verify Participation Poster (English and Spanish)
• Right to Work Poster (English and Spanish)