The role involves maintaining data inventory, performing analysis using SQL and Excel, and troubleshooting carrier data feed issues.
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.
Top Skills
Alteryx
Excel
SQL
Similar Jobs
Cloud • Insurance • Professional Services • Analytics • Cybersecurity
The Sr. Product Manager develops product strategies for complex data products, ensuring customer needs align with business goals, collaborating across functions, and managing Agile processes.
Top Skills:
Agile MethodologiesDesign ThinkingSafe
Healthtech
The Business Analyst I performs analysis to support business initiatives, identifies problems, and recommends solutions while participating in user acceptance testing.
Top Skills:
AccessExcel
Food
Lead transformative Gen AI projects, design AI solutions, mentor data scientists, and drive strategic insights within Mars Snacking division.
Top Skills:
Generative AiGoogle TechnologiesMicrosoft TechnologiesMl Ops
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
