Data Engineer Intern at American Equity in West Des Moines, Iowa, United States

Job description

• At American Equity we offer leading annuity products that help empower our clients to fulfill their needs and wants in retirement. Our success comes from hiring high-energy individuals who embody the beliefs that drive our unique culture. We currently fund over half a million retirements nationwide, and have been headquartered in West Des Moines, Iowa, for over twenty-five years with satellite offices New York, NY.
• The Data Engineer Intern gains hands-on experience with data transformation, data warehouse concepts, and pipeline development tools while contributing to real project deliverables. The intern uses SQL, technical tools, and emerging data technologies to help build maintainable solutions that meet business and technical requirements. This role offers exposure to how data moves through an organization, from raw source information through transformation and into trusted business-ready outputs.
• The American Equity Launchpad Internship Program is designed to identify, develop, and empower the next generation of talent. Through meaningful project work, mentorship, professional development, and networking opportunities, interns gain real-world experience while building the skills and connections needed to launch their careers.
• The Launchpad Internship Program is a 10–12 week, in-person experience based in our downtown Des Moines office. Interns gain hands-on experience, collaborate with professionals across the organization, and contribute to work that drives meaningful business outcomes.
• · Contribute to meaningful projects that deliver real business impact.
• · Receive dedicated mentorship from leaders and colleagues across the organization.
• · Participate in an Intern Hack-a-thon focused on solving real business challenges and presenting innovative solutions to company leaders.
• · Develop professional skills through learning sessions, leadership presentations, and networking opportunities.
• · Engage in community service projects, Des Moines Intern Connections events, and social activities with fellow interns.
• · Receive competitive compensation, including a housing stipend and recognition opportunities.

Responsibilities

• · Shadows team members to learn the essential duties and functions of the Data Engineer role.
• · Gains foundational knowledge of tooling, mapping design, coding, and debugging through mentorship and hands-on assignments.
• · Builds a working understanding of how data moves from raw source information through transformation and into target systems.
• · Assists in documenting data pipeline processes, including steps needed to migrate pipeline and database objects between Development, UAT, and Production environments.
• · Builds strong working relationships and partners with cross-functional teams.
• · Learns and uses project management and collaboration tools to support daily work and project deliverables.
• · Participates in code reviews and team discussions to develop awareness of technical best practices.
• · Completes project and support tasks with guidance from mentor and department leader.
• · Collaborates with fellow interns across departments on a strategic, cross-functional initiative that drives meaningful business impact.
• · Performs other related work as assigned.

Requirements

• · Currently pursuing a bachelor’s degree in Management Information Systems, Computer Science, Computer Engineering, Information Technology, or a related field of study.
• · N/A
• Required
• · Python or object-oriented programming class exposure.
• · Current or upcoming coursework with database concepts.
• · Problem-solving and analytical skills.
• · Data analysis aptitude.
• · Effective verbal and written communication skills.
• · Ability to work cooperatively and successfully in a team environment.
• · Willingness to learn new tools and technologies.
• · SQL exposure through coursework, personal projects, or work experience.
• · Exposure to Snowflake, Postgres, or SQL Server databases.
• · Python experience beyond introductory coursework.
• · Git or source control familiarity.
• · AWS cloud platform exposure.
• · Basic understanding of data modeling concepts, including relational or dimensional models.
• · Familiarity with ETL/ELT concepts.
• · Awareness of data quality and governance concepts.

Skills

Required

• Problem-solving and analytical skills
• Data analysis aptitude

Preferred

• Git or source control familiarity
• AWS cloud platform exposure
• Familiarity with ETL/ELT concepts