Data Engineering Internship - Summer 2027

Auto-Owners Insurance; Town of Lansing (NY); On-site; USD 28,000 - 41,000; Full time

Job summary

Auto-Owners Insurance seeks a Data Engineering intern to analyze data processes, develop plans, and design data quality, reporting, and governance solutions for this summer. The position is in Lansing, Michigan, in person, with full-time hours Monday through Friday.

You will work with stakeholders to define requirements, build data assets, and support regulatory data requests while learning data engineering practices and mentoring colleagues.

Qualifications

• Pursuing a bachelor's degree in a quantitative field with at least two years of coursework completed.
• Successful completion of actuarial exams or related courses preferred.
• Ability to apply mathematical, statistical, and programming concepts to analyze insurance processes.
• Strong writing, collaboration and presentation skills.
• Exhibit initiative, motivation, organization and leadership.

Responsibilities

• Identify business requirements and expected outcomes with stakeholders.
• Create, evaluate, and summarize data assets for internal/external use.
• Evaluate regulatory data requests accurately and timely.
• Understand data sources and lineage across company systems.
• Build, maintain, and document code for data transformation and analysis.
• Create data extracts and analyses to support reporting needs.
• Assess data source reliability and promote data quality.
• Assist with training and mentoring of associates.
• Support peer review and quality control processes.

Skills

Analytical reasoning

Problem solving

Teaching mentoring

Project leadership

Collaboration and presentation

Initiative and organization

Education

Bachelor's in Statistics

Bachelor's in Computer Science

Bachelor's in Data Mining

Bachelor's in Mathematics

Bachelor's in Physics

Bachelor's in Operations Research

Job description

A career at Auto-Owners is challenging and rewarding. Our group of caring associates create financial security by helping individuals and businesses make a new start when a loss occurs.

Job Description

Auto-Owners Insurance, a top-rated insurance carrier, is seeking a motivated Data Engineering intern to join our team this summer. The positionanalyzes data processes and the needs of users and stakeholders; develops project plans; and designs, implements, and manages data quality, data reporting, and governance solutions. The position requires the person to:

• Work with project stakeholders to identify business requirements and expected outcomes.
• Create, evaluate, and summarize data assets in a form acceptable for use within the Company or outside the Company, including use by government bureaus, agencies, and others.
• Evaluate and complete regulatory data requests in an accurate and timely manner.
• Understand data sources and the data lineage of various computer systems in the Company.
• Build, maintain, and document code used to transform, aggregate, and analyze data.
• Create and enhance data extracts and analyses to support data reporting functions and inquiries.
• Evaluate the reliability of sources of data, investigate data integrity, identify data problems, and provide technical expertise for ensuring data quality, while promoting understanding within the Division.
• Assist with training and mentoring of other associates.
• Contribute to and promote the peer review process, verify work completed by others, and develop other quality control measures

This internship has full-time hours (Monday through Friday) and is in person in Lansing, Michigan. Interns choose their start and end dates. Most join in mid-May and stay until mid-August.

Desired Skills & Experience

• Student must be working toward a bachelor's in statistics, computer science, data mining, machine learning, mathematics, physics, operations research, or a related quantitative discipline, and have at least two years of coursework completed. Master's students are also considered if graduation is August 2027 or later.
• Successful completion of actuarial exams or other Company approved courses is preferred. These requirements may be waived or changed, at Company discretion, based on prior education and/or experience.
• Ability to apply mathematical, statistical, and programming concepts and procedures to analyze and solve complex insurance processes.
• Demonstrate strong analytical reasoning, problem solving, technical writing, and collaboration and presentation skills.
• Exhibit high level of initiative, motivation, organization, and leadership.
• Ability to lead projects and coordinate among diverse stakeholders.
• Ability to mentor by sharing knowledge and challenging others to grow their skill sets.
• Ability to work effectively with others at all levels.

Equal Employment Opportunity

Auto-Owners Insurance is an equal opportunity employer. The Company hires, transfers, and promotes on the basis of ability, without consideration of disability, age, sex, race, color, religion, height, weight, marital status, sexual orientation, gender identity or national origin, or any factor contrary to federal, state or local law.

Please note that the ability to work in the U.S. without current or future sponsorship is a requirement.

#LI-DNI #IN-DNI