Data Analyst

Our Company

Explore how you can contribute at AmeriLife.

For over 50 years, AmeriLife has been a leader in the development, marketing and distribution of annuity, life and health insurance solutions for those planning for and living in retirement.

Associates get satisfaction from knowing they provide agents, marketers and carrier partners the support needed to succeed in a rapidly evolving industry.

Job Summary

We are looking for a detail-oriented CDF Inventory & Documentation Specialist with strong analytical skills to support the use and processes of carrier data feeds. This role involves maintaining accurate data inventory records, performing data validations and analyses, assisting with mapping updates, and troubleshooting data file issues to ensure seamless business operations. This is a 10-week internship opportunity supporting our Enterprise Data team.

Job Description

Key Responsibilities:

• Inventory Management: Track and document raw carrier data sources, including frequency, intake methods, column structures, and usage attributes.
• Data Analysis & Reporting: Utilize SQL and Excel to analyze carrier data feeds, assess trends, and support the generation of reports that support business decision-making.
• Documentation Support: Maintain field dictionaries, list dictionaries, data source guides, and consolidation mapping documentation for business use and transparency.
• Mapping Updates: Assist with product, carrier, and affiliate mapping to ensure accuracy and compliance.
• Data Validation & Audits: Review automated validations to uphold data integrity and identify inconsistencies.
• Carrier Data Preparation: Assist in evaluating and preparing carrier data feeds for business use, ensuring proper formatting and completeness. Confirming data availability and completeness across business products, carriers and sales groups.
• Issue Investigation: Identify and troubleshoot file errors, discrepancies, and modifications in carrier data feeds.
• Requirement Writing & Quality Checks: Draft consolidation requirements and delivery requirements for quality control checks before code implementation.

Qualifications:

• Proficiency in SQL and Excel for data querying, analysis, and reporting.
• Ability to work collaboratively with technical and business teams.
• Experience in data management, inventory tracking, or documentation development.
• Strong analytical and problem-solving skills.
• Experience with Alteryx is a plus but not required.
• Strong communication and documentation skills.
• Familiarity with health/life insurance and annuity industry is a plus.