Summer Data Architect Intern – Build Data Solutions

Farmers Mutual Hail Insurance Company; West Des Moines (IA); On-site; USD 21,000 - 30,000; Full time

Job summary

Farmers Mutual Hail Insurance Company in West Des Moines, IA is seeking an undergraduate for its 2027 Summer Internship Program. This paid internship runs May 17 through August 6, up to 40 hours per week, with potential to transition to full-time later.

Candidates must be currently enrolled as sophomores, juniors, or seniors in CS, Data Science, MIS or related fields. SQL/PLSQL exposure and data-structures or database management background are a plus.

Qualifications

• Currently-enrolled sophomore, junior or senior at undergrad; May 2027 grads not eligible.
• Exposure to SQL or PL/SQL is 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 DDL scripts, and implements database changes with focus on data integrity, efficiency, and quality.
• Produces and runs data scripts to load data, correct data issues, and extract data as directed.
• Communicates with Product Owners, Scrum Masters, Lead Developers, and the business community as needed to clarify requirements, report progress, and resolve issues.
• Accomplishes other tasks and duties as assigned.

Skills

SQL

PL/SQL

Data structures

Database management

Education

Currently-enrolled sophomore/junior/senior

Majors: CS, Data Science, MIS

May 2027 graduates ineligible

Job description

Farmers Mutual Hail Insurance Company in West Des Moines, IA is seeking an undergraduate for its 2027 Summer Internship Program. This paid internship runs May 17 through August 6, up to 40 hours per week, with potential to transition to full-time later.

Candidates must be currently enrolled as sophomores, juniors, or seniors in CS, Data Science, MIS or related fields. SQL/PLSQL exposure and data-structures or database management background are a plus.