Data Architect Intern at Farmers Mutual Hail Insurance

About The Role

&lt;div class=&quot;content-intro&quot;&gt;&lt;p&gt;&lt;span style=&quot;font-family: arial, helvetica, sans-serif;&quot;&gt;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.&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Farmers Mutual Hail (located in West Des Moines, IA) is currently looking for a qualified undergraduate to join our 2027 Summer Internship Program.&amp;nbsp;&amp;nbsp;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.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;We are looking for currently-enrolled college students who are close to the West Des Moines area, as this is not a remote internship.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;strong&gt;&lt;u&gt;REQUIREMENTS:&lt;/u&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;strong&gt;Education:&amp;nbsp;&lt;/strong&gt;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 (&lt;strong&gt;May 2027 graduates will not be eligible&lt;/strong&gt;).&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;strong&gt;Skills: &lt;/strong&gt;Exposure to SQL or PL/SQL a plus.&amp;nbsp;Exposure to data structures or database management is a plus.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;strong&gt;&lt;u&gt;RESPONSIBILITIES:&lt;/u&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Follows all established principles, standards, and processes that guide data decisions for the enterprise.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;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.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Produces and runs data scripts to load data, correct data issues, and extracts data as directed.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Communicates with Product Owners, Scrum Masters, Lead Developers, and the business community as needed to clarify requirements, report work progress, and resolve issues.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Accomplishes other tasks and duties as assigned.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;strong&gt;&lt;u&gt;WORK ENVIRONMENT:&lt;/u&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Office environment with individual workspace provided.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Casual dress.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;On-site fitness center and cafeteria.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Employee appreciation events.&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;color: rgb(0, 101, 164);&quot;&gt;&lt;span style=&quot;color: rgb(0, 101, 164);&quot;&gt;Opportunity to participate in company-wide activities.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div class=&quot;content-conclusion&quot;&gt;&lt;p&gt;&lt;span style=&quot;text-decoration: underline; color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif;&quot;&gt;&lt;em&gt;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.&lt;/em&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style=&quot;font-family: arial, helvetica, sans-serif;&quot;&gt;&lt;em&gt;Farmers Mutual Hail Insurance Company does not discriminate in employment (EOE). All qualified applicants are encouraged to apply.&lt;/em&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;