TITLE:                       Senior ETL Developer

JOB ID:                      426412

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

DUTIES:

Responsible for designing overall data storage, data files, and reporting structures for company’s internal customer business, regulatory, and product performance needs. Responsible for all phases of solution delivery from initial requirements analysis, solution estimation, coordination of development, testing and delivery to production while applying knowledge of the Personal and Commercial lines of insurance. Use Informatica ETL Software to design, load, and query dimensional and relational data models in data warehouse environments. Read PL/SQL for ETL relating to data warehousing and integration. Read and create entity relationship (ER) diagrams and illustrating process flows. Use Oracle for database modeling. Work with Guidewire Policy Center and DataHub. Translate requirements from the mapping specs into technical code. Collaborate with ETL, Database Administration, Business Intelligence and Data Modeling teams to prioritize and coordinate work in various stages. 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. Provide documented project and task updates to all concerned parties in a timely manner. Remote work available up to 50%; must work at Donegal Mutual Insurance Company’s office in Marietta, PA at least 50%.

EDUCATION/REQUIREMENTS:

Bachelor’s degree (or foreign equivalent) in Computer Science, Business Systems, or related industry fields, 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 50%; must work at Donegal Mutual Insurance Company’s office in Marietta, PA at least 50%. Please apply at https://www.donegalgroup.com/careers. Job ID 426412

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 21 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 Donegal, 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

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 position not requiring an onsite expectation at one of our offices, the ideal candidate must live within our Donegal footprint. Current approved states 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)