Data Engineer Intern

American Equity
  • West Des Moines, IA
    4 days ago

    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 in Charlotte, NC and New York, NY.

    GENERAL PURPOSE OF THE JOB

    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.

    LAUNCHPAD INTERNSHIP PROGRAM

    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.

    Program Highlights

    •          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.

    ESSENTIAL DUTIES AND 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.

    EDUCATION AND/OR EXPERIENCE:

    •          Currently pursuing a bachelor's degree in Management Information Systems, Computer Science, Computer Engineering, Information Technology, or a related field of study.

    CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS:

    •          N/A

    KNOWLEDGE, SKILLS AND ABILITIES:

    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.

    Preferred

    •          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.

    DISCLAIMER:

    This description covers the major purpose and essential functions of the job. It is not intended to give all details or a step-by-step account of the way each task is to be performed. Employees may receive other job related instructions and be required to perform other job related work requested by their manager. All requirements are subject to possible modification to provide reasonable accommodation to qualified individuals with disabilities.

      #LI-PL1

    At American Equity, our core values-Empowered, Passion, Integrity, and Caring-are more than words. They guide how we support one another and how we serve our clients every day. To learn more about American Equity, our culture, and our values, visit the Careers site.

    Iowa Best Companies to Work for 2025 | Top Workplaces

    For more information about how your information is processed, please click on the Privacy tab at the bottom of the page and then click on the Applicant Privacy Policy.

    Numbers & Facts

    LocationWest Des Moines, IA

    Skills

    • Acceptance Testingunmatched
    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Annuitiesunmatched
    • Best Practicesunmatched
    • Candidate Sourcingunmatched
    • Cloud Computingunmatched
    • Code Reviewsunmatched
    • Communication Skillsunmatched
    • Community and Social Servicesunmatched
    • Computer Engineeringunmatched
    • Computer Scienceunmatched
    • Cross-Functionalunmatched
    • Data Analysisunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Programmingunmatched
    • Database Technologyunmatched
    • Debugging Skillsunmatched
    • Dimensional Modelingunmatched
    • Documentationunmatched
    • Emerging Technologyunmatched
    • Gitunmatched
    • Information Technology & Information Systemsunmatched
    • Leadershipunmatched
    • Machine Toolunmatched
    • Management of Information Systems/Technology (MIS)unmatched
    • Mentoringunmatched
    • Microsoft SQL Serverunmatched
    • Object Oriented Programming (OOP)unmatched
    • PostgreSQLunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Production Systemsunmatched
    • Programming Toolsunmatched
    • Project Management Softwareunmatched
    • Python Programming/Scripting Languageunmatched
    • SQL (Structured Query Language)unmatched
    • Snowflake Schemaunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder