Data Architect Intern

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’re headquartered in the U.S. and have been owned by the farmers we insure for over 125 years.
Farmers Mutual Hail (located in West Des Moines, IA) is currently looking for a qualified undergraduate to join our 2027 Summer Internship Program. This is a paid internship starting Monday, May 17 through Friday, August 6, working up to 40 hours per week for the summer, with the potential to turn into a full-time, permanent position in the future.
We are looking for currently-enrolled college students who are close to the West Des Moines area, as this is not a remote internship.
REQUIREMENTS:
Education: Must be a currently-enrolled sophomore, junior or senior at an undergraduate college or university, majoring in Computer Science, Data Science, MIS or related technical field (May 2027 graduates will not be eligible).
Skills: Exposure to SQL or PL/SQL a plus. Exposure to data structures or database management is a plus.
RESPONSIBILITIES:
Follows all established principles, standards, and processes that guide data decisions for the enterprise.
Implements data model changes as needed to support user and application requirements, generates database definition language scripts, and implements database changes using the provided toolset with a focus on data integrity, efficiency, and quality.
Produces and runs data scripts to load data, correct data issues, and extracts data as directed.
Communicates with Product Owners, Scrum Masters, Lead Developers, and the business community as needed to clarify requirements, report work progress, and resolve issues.
Accomplishes other tasks and duties as assigned.
WORK ENVIRONMENT:
Office environment with individual workspace provided.
Casual dress.
On-site fitness center and cafeteria.
Employee appreciation events.
Opportunity to participate in company-wide activities.
This position is not eligible for sponsorship for work authorization by Farmers Mutual Hail Insurance Company, SI. 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.