ETL Developer - Onsite at Farmers Mutual Hail Insurance Company of Iowa

ETL DEVELOPER - Onsite in West Des Moines, IA

At Farmers Mutual Hail (FMH), our mission is simple: protect the livelihoods and legacies of America’s farmers through the complete farm insurance solutions we offer. As America’s Crop Insurance Company™, we are headquartered in the U.S. and have been owned by the farmers we insure for over 125 years.

As an ETL Developer at FMH, you will be responsible for utilizing ETL tools/code against sources systems to extract, transform, and load (ETL) data to target systems and/or data warehouse.

BENEFITS:

Our employees appreciate our family-oriented culture, and we make sure their benefits reflect that. In addition to a competitive salary and bonuses, medical/dental/vision plan, 401(k) plan with a generous company match, you will be eligible for benefits such as:

• Hybrid work schedule (3 days in West Des Moines Home Office, 2 WFH), after training is complete.  THIS IS NOT A REMOTE POSITION.
• Paid Parental Leave and Caregiver Leave
• Employee appreciation events 
• Employee Assistance Program (EAP) for support when you and your family need it
• On-site cafeteria and fitness center

REQUIREMENTS:

• Experience: At least 1-3 or more years of software development experience, or equivalent combination of education and/or experience.
• Education: Bachelor’s degree in Computer Science, MIS or related field (Associate’s degree required).
• Skills: Experience with SQL syntax, data definition language, and data diagrams would be beneficial. Data modeling software experience helpful. Proficient in Microsoft Office Suite, especially Word and Excel. Experience in an Agile environment is helpful.

RESPONSIBILITIES:

• Implements business objectives and data requirements, then consults with other team members (Developers, Product Owners, End Users, and Management) to make sure data integrity, efficiency, and quality objectives are being met. 
• Collaborates with IT team members to design and manage data models for applications, metadata tables, and views, ensuring system data and reporting standards, security, along with performance, robustness, and reliability of the data is meeting best solution expectations. 
• Troubleshoots data performance issues and provides tuning analysis and engineering recommendations. 
• Transforms extracted data by cleaning, aggregating, mapping, and converting data to meet business requirements in a suitable format for analysis. 
• Loads transformed data into the warehouse, making it accessible for querying and analysis. 
• Develops data quality metrics to identify gaps and ensure compliance with company-wide standards. 
• Creates and runs scripts containing the appropriate data definition language.
• Periodically assumes release management duties as assigned, including database script preparation and testing, issue resolution, communication, source code management, and on-call responsibilities. 
• Monitors daily ETL performance for error handling and meeting service level agreements.

Does this sound like a good fit for you? Apply today through our website!

This position is not eligible for sponsorship for work authorization by Farmers Mutual Hail Insurance Company of Iowa. Therefore, if you will require sponsorship for work authorization now or in the future, we cannot consider your application at this time.

Farmers Mutual Hail Insurance Company does not discriminate in employment (EOE).  All qualified applicants are encouraged to apply. #LI-DNI