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
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
Information Technology
The Data Analyst will develop briefs, maintain analytics views, update SQL procedures, provide insights, and improve processes for effective decision-making.
Top Skills:
ExcelGitMS OfficePower BIPythonRSQL
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
