Data Analyst l

At American Equity Investment Life Holding Company ® we offer leading annuity products that help empower our clients to fulfill their needs and wants in retirement. Our success comes from hiring high-energy individuals who embody the beliefs that drive our unique culture. We currently fund over half a million retirements nationwide, and have been headquartered in West Des Moines, Iowa, for over twenty-five years with satellite offices in Charlotte, NC and New York, NY.

General Purpose Of The Job

The Data Analyst, as a member of the Data Management team, supports enterprise-wide data lake and warehouse development activities. They partner with individual business units to define business needs, gather data requirements and facilitate data onboarding following best practices and standards. This contributor is a strong collaborator and responsible for partner assignments related to data integration, reporting and analysis. They proactively identify, recommends and participates in the development of streamlined data integration strategies, designs, solutions and processes that enable the business to quickly extract insights from a centralized data lake and warehouse.

As part of AEL’s Early Talent Program, you’ll have the opportunity to grow your career through structured mentorship, professional development, and networking experiences. Our cohort-based approach fosters connection, collaboration, and exposure to various areas of the business, ensuring a well-rounded start to your career.

Essential Duties And Responsibilities

• Researches, analyzes, validates and documents business data requirements for integrating business data sources into the enterprise data lake and warehouse.
• Facilitates meetings with technical and non-technical staff to clarify business requirements and acquire business approval for all data requirements.
• Conducts data profiling and other analyses to determine the efficacy of available data sources.
• Facilitates the identification of potential gaps in available data and collaborates with business, data management and IT to determine best means for acquiring the data needed.
• Transforms non-functional and functional data requirements into executable technical specifications leveraged by data architecture and ETL resources in data lake and warehouse development.
• Collaborates with data management resources on the creation and maintenance of the content in the data lake and warehouse.
• Maintains moderate knowledge of data lake and warehouse data structure design, definitions, capabilities, SQL, processes and data integrity constraints.
• Ensures adherence to data management and data governance policies and standards.
• Performs other related duties as assigned.
  
  

Supervisory Responsibilities

Direct Reports:

None

General Description Of Indirect Reports (2 And 3-downs)

None

Education And/Or Experience

Bachelor’s degree in Computer Science, MIS, Mathematics, Information Management or related field of study; or equivalent combination of education and/or experience.

Certificates, Licenses, Professional Designations

N/A

Knowledge, Skills And Abilities

• Minimal data model knowledge. (relational, dimensional, historical data support, etc.)
• Basic knowledge of RDBMS and data warehouse front-end tools.
• Basic level development experience working with SQL scripting.
• Strong analytical skills, research capabilities and problem-solving skills.
• Ability to work cooperatively and successfully with employees, customers, and other outside third parties.
• Strong customer service orientation and ability to build strong relationships across the Business.
• Excellent communication skills and ability to present findings to key stakeholders.
• Mathematical skills and strong attention to detail.
• Strong organizational and planning skills.
• Proficient in the use of Microsoft Office Suite.
• Ability to write reports, business correspondence, and procedure manuals.
• Ability to effectively present information and respond to questions.
• Ability to read, analyze, and interpret general business periodicals, professional journals and technical/operational procedures.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Ability to successfully handle pressure and meet deadlines in a fast-paced work environment.
  
  

____

This description covers the major purpose and essential functions of the job. It is not intended to give all details or a step-by-step account of the way each task is to be performed. Employees may receive other job related instructions and be required to perform other job related work requested by their manager. All requirements are subject to possible modification to provide reasonable accommodation to qualified individuals with disabilities.