Description

Nature of Job

As a Senior ETL Developer, you will be responsible for designing, developing, 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.

The ideal candidate will have a solid understanding of ETL tools and knowledge of Personal and Commercial insurance data models. You should be able to work independently and collaboratively with team members to deliver high-quality solutions that meet business requirements.

Duties and 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.

Requirements

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• 5 years of experience in ETL development using Informatica PowerCenter, SQL Server Integration Services, Python, or equivalent. 
• 3 years of experience in P&C insurance. 
• Strong SQL skills and proficiency in relational databases such as Oracle, SQL Server, or MySQL
• Experience with data integration technologies such as REST, SOAP, XML, and JSON
• Strong communication and collaboration skills
• Familiarity with agile software development methodologies
• Some cloud exposure, preferably Azure and/or Snowflake.
• Ability to self-manage and stay on track with commitments; resourceful in solving problems and removing impediments.
• Ability to think creatively, champion new ideas, and challenge the status quo.
• Commitment to company values and customer service.
• Ability to perform the essential functions of the job with or without reasonable accommodation.