Senior ETL Developer I

Description

Summary: 

This position is responsible for designing, testing, and maintaining our Extract, Transform, Load (ETL) processes that integrate data from various sources into our insurance data warehouse. The position will also assist with modeling and analyzing Personal, Commercial, and Farm insurance data to support our business intelligence and reporting needs.  

Functions:

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

Requirements

• 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. 
• 3 years of experience in Property & Casualty insurance preferred. 
• 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.
• Familiarity with agile software development methodologies preferred.
• 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.