Data Engineering Intern

The Department

Life Technology Solutions (LTS) is a practice within Milliman, one of the largest actuarial consulting firms in the world. Our system, Integrate, is a market-leading application used throughout the life insurance industry for activities such as financial modelling and reporting, business planning and reporting, and insurance product pricing.

Our professional services team sits within LTS and primarily consists of actuarial consultants with strong technical capabilities. The Developers within our team provide more advanced technical capabilities in areas less actuarial in nature, strengthen collaboration and coordination with development, and provide a bridge between professional services and development.

The Role

As a Data Engineering Intern, you will work closely with our team to support the design, development, and optimization of data pipelines and infrastructure. In this role, you'll be provided with a hands-on experience with modern data technologies and methodologies in a collaborative, growth-oriented environment.

Your Responsibilities:

• Assist in building, maintaining, and optimizing ETL (Extract, Transform, Load) processes and data pipelines.
• Support the integration of data from multiple sources (structured and unstructured) into centralized data stores.
• Collaborate with data engineers and actuaries to ensure data quality, consistency, and reliability.
• Help with the documentation of data processes, workflows, and best practices.
• Participate in troubleshooting and resolving data-related issues.
• Contribute to the design and implementation of database schemas and data models with the support of your team.
• Run exploratory data analysis to validate pipeline outputs and provide actionable insights.
• Learn and work with Azure cloud data platforms and big data tools as applicable.
• Adhere to data governance and security standards.

Time Commitment: This internship is a full-time seasonal position that requires significant time commitment and is not typically completed at the same time as college coursework. Our interns are available to work during standard business hours (8:30a - 5p, Monday - Friday) and work extended full-time hours (at least 37.5+ hours per week).

What an Internship with Milliman Can Offer You:

• The opportunity to work on real projects that deliver value for our clients.
• Mentorship from experienced professionals in your field.
• Hybrid work arrangement (3 days per week in the office) providing you with the opportunity for in-person connection with your colleagues and larger intern cohort.
• Professional development opportunities, including weekly Intern Sessions to help you learn more about the work of our firm.
• Our downtown Chicago office offers easy access to public transportation, a variety of dining options, and numerous cultural attractions giving you the chance to be immersed in the city.
• Our intern program serves as our talent pipeline for post-grad hiring, with interns making up the majority of the new hire additions to our team.

Job Knowledge, Experience Skills

Job Knowledge Required

• Pursuing abachelor'sor master's degree in computer science, data science, or finance, statistics, or mathematics with a computer science minor.
• Experience with Python or R (preferred)
• Experience developing and debugging a program
• Experience with PowerBI reporting or the desire to develop this skill
• Experience with SQL (preferred)

Experience and Soft Skills Required

• Strong verbal and written communication skills.
• A desire to contribute to the success of our projects and deliver value for our clients.
• Ability to complete project deliverables, meet deadlines, and ensure compliance with quality procedures.
• Excellent project management skills, including communication and time management skills.
• Self-motivated individual with a sense of intellectual curiosity and a results-oriented work ethic.
• Ability to work in a team environment and ask the right questions to learn about the work and your involvement in it.
• Interest in a software engineering career demonstrated by previous internships, professional experience, and/or projects.

Location

Candidates hired into this role will be required to work in-person in the Milliman office in Chicago, IL on a weekly basis, but flexible work arrangements will be considered.

Compensation

The salary range for this role is $23 - $46 per hour depending on a combination of factors, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, location, etc.

Benefits

We offer competitive benefits which include the following based on plan eligibility:

• Employee Assistance Program (EAP) - Confidential support for personal and work-related challenges.
• 401(k) Plan - When an employee reaches 1,000 hours worked within 12 consecutive months, they become eligible for a 401(k) plan that includes a company matching program and profit-sharing contributions.
• Paid Time Off (PTO) - Begins accruing on the first day of work; Interns, Temporary, and Seasonal Employees will earn PTO each pay period, based on 1 hour for every 30 hours worked.
• Transportation - Pre-tax savings for eligible transit and parking expenses.

Equal Opportunity

All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, national origin, disability, or status as a protected veteran.