Senior ETL Developer

Marietta, PA

Full Time

Information Technology

Mid Level

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 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 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

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)

Apply for this position

Required*

Apply with

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Cover Letter

Are you willing to relocate?*

What's your highest level of education completed?*

Desired salary*

Are you currently authorized for unrestricted work in the U.S. on a full-time basis?*

Will you now or in the future require sponsorship for employment visa status?*

Are any members of your family employed by us? If so, please list name and relationship.*

Are you a current employee at Donegal Insurance Group?*

If not a current employee, have you ever worked for Donegal Insurance Group in the past?

If yes, please list previous position and dates of employment?

Human Check*

Submit Application