2018 Client Systems Integration Intern

Houston TX
February 22 2018
Insurance, Securities

Functional Area:

TH - Other

Estimated Travel Percentage (%): No Travel

Relocation Provided: No

American General Life Insurance Company

This position functions in the role of data analysis/scrubbing and conversion of participant data. Provides analytical and technical support on complex issues and participates in the design and implementation of special projects. Analyzes and recommends improvements to departmental processes and applications.

Data Conversion:

  • Complete External Conversions through the use of MS Office products and proprietary platforms
  • Ensures cases are completed in accordance with required timelines
  • Resolves complex obstacles encountered during the conversion process effectively
  • Ensure all data changes or rules are agreed upon and accurately documented


  • Complete report request as received through the use of SQL Navigator or other required mediums
  • Probe clients to ensure requested information will meet their needs and make recommendations when necessary
  • Able to quality review reports produced for appropriate content and accuracy

Technical Solutions:

  • Understand customers processes and functions to provide viable solutions to increase efficiency
  • Discern the proper medium to provide proper automation (ie. Excel, Access, SharePoint, etc.).

Predictive Analytics:

  • Understand customers processes and functions to develop key performance indicators
  • Monitor data to perform trend analysis through collection/mining
  • Create dashboards to track progress and make recommendations on KPI's going forward

Key Qualifications:

  • Minimum grade point average of 3.0 (unofficial transcript required upon application)
  • 2 years of college level education and on track to graduate with within 18 months
  • Strong analytic skills; ability to analyze large volumes of data while recognizing inconsistencies and/or erroneous information
  • Demonstrated skills in planning and organizing complex assignments; self-starter that is results oriented
  • Strong MS Access skills, with ability to build tables, forms, queries, reports and dashboards
  • Strong MS Excel skills such as, building functions, pivot tables, and macros
  • Organized, with the ability to complete multiple tasks under various deadlines
  • Strong communication (written and verbal) and interpersonal skills

It has been and will continue to be the policy of American International Group, Inc., its subsidiaries and affiliates to be an Equal Opportunity Employer. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.

At AIG, we believe that diversity and inclusion are critical to our future and our mission - creating a foundation for a creative workplace that leads to innovation, growth, and profitability. Through a wide variety of programs and initiatives, we invest in each employee, seeking to ensure that our people are not only respected as individuals, but also truly valued for their unique perspectives

Similar jobs

Similar jobs