Data Analyst

Position Overview

At AmeriLife – a leader in annuity, life, and health insurance solutions for over 50 years – we are seeking a detail-oriented CDF Inventory & Documentation Specialist with strong analytical skills. You will support carrier data feed processes by maintaining accurate data inventory records, performing data validations and analyses, assisting with mapping updates, and troubleshooting data file issues. This is a 10-week internship opportunity supporting our Enterprise Data team.

Key Responsibilities

• Track and document raw carrier data sources, including frequency, intake methods, column structures, and usage attributes.
• Utilize SQL and Excel to analyze carrier data feeds, assess trends, and generate reports to support business decision-making.
• Maintain field dictionaries, list dictionaries, data source guides, and consolidation mapping documentation for transparency.
• Assist with product, carrier, and affiliate mapping to ensure accuracy and compliance.
• Review automated validations to uphold data integrity and identify inconsistencies.
• Evaluate and prepare carrier data feeds for business use, confirming data availability and completeness across products, carriers, and sales groups.
• Identify and troubleshoot file errors, discrepancies, and modifications in carrier data feeds.
• Draft consolidation and delivery requirements for quality control checks prior to code implementation.

Required Qualifications

• Proficiency in SQL and Excel for data querying, analysis, and reporting.
• Ability to work collaboratively with both 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 the health/life insurance and annuity industry is a plus.