Data Analytics Intern - Summer 2027 (Power BI/Excel)

Farm Bureau Financial Services; West Des Moines (IA); On-site; USD 23,000 - 32,000; Part time

Job summary

Farm Bureau Financial Services is offering a PC Data Analytics Intern position for Summer 2027 in West Des Moines, IA. You will build dashboards and reports using Power BI or Excel, and analyze data to support underwriting and claims teams.

The role emphasizes SQL querying, data validation, and documenting data rules, with an 80/10/10 internship structure to expose you to the organization and culture.

Qualifications

• Current undergraduate student in data analytics or a related field.
• Advanced knowledge of Excel required.
• Strong analytical thinking and problem-solving skills.
• Excellent written and verbal communication abilities.
• Availability to work full-time during Summer 2027.

Responsibilities

• Create and maintain dashboards, reports and visualizations using Power BI or Excel.
• Identify trends and opportunities for process improvement for underwriting and claims.
• Write and optimize SQL queries to extract data from enterprise databases.
• Perform data validation, cleansing and quality assurance for accurate reporting.
• Document data definitions, business rules and analytics methodologies.

Skills

Excel

Power BI

SQL

Analytical thinking

Communication

Education

Pursuing bachelor’s degree in data analytics or related field

Tools

Power BI

Excel

Job description

Farm Bureau Financial Services is offering a PC Data Analytics Intern position for Summer 2027 in West Des Moines, IA. You will build dashboards and reports using Power BI or Excel, and analyze data to support underwriting and claims teams.

The role emphasizes SQL querying, data validation, and documenting data rules, with an 80/10/10 internship structure to expose you to the organization and culture.