Business Intelligence Analyst I

AtAmerican Equity Investment Life Holding Company, we think of ourselves asThe Financial Dignity Company. Our policyholders work with independent agents, banks and broker-dealers through our wholly-owned operating subsidiaries, to choose one of our leading annuity products best suited for their personal needs to create financial dignity in retirement. We remain steadfast in our commitment to quality products, excellent customer service, integrity, safety and delivering on our promises to our policyholders. Our success comes from hiring people who embody the beliefs that drive our unique, energetic, fast-paced and caring culture of collaboration, ownership and innovation.

We currently fund over half a million retirements nationwide, and have been headquartered in West Des Moines, Iowa, for over twenty-five years, withsatellite offices slated to open in 2022 in Charlotte, NC, and New York, NY. We are a NYSE-listed company and maintain an "excellent" rating from AM Best. Our companyhas over $57 billion in assets, 26,000 active agents and over 800 employees.

GENERAL PURPOSE OF THE JOB:

The Business Intelligence Analyst supports Operations data analytics and reporting activities, including responsibility for defining business data needs, gathering requirements and building streamlined data visualization solutions following best practices and standards. The incumbent collaborates with business partners on data integration, reporting and analysis, proactively identifying, recommending and developing streamlined business intelligence and analytics strategies, systems and processes that enable the business to quickly extract insights from their data.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Supports business enablement of accurate and timely reporting and data analytics.
• As subject matter expert, performs design and development of effective, dynamic, and interactive data visualizations, including business dashboards and reports that meet cross-functional needs of the business and enables critical data-drive decisions.
• Establishes and communicates standards and best practices for data visualization and dashboarding.
• Transforms business partner data requests into accurate data that is timely and relevant to the business need.
• Executes complex data related analytical projects that drive business decisions and efficiencies.
• Researches, analyzes, validates and documents business requirements based on business need for dashboarding, project ROI, and ad hoc requests.
• Proactively improves the quality of data and frequency of company reporting; recommends process improvements regarding same.
• Ensures adherence to data management and data governance policies and standards.
• Effectively partners with IT, Distribution and other AEL departments to deliver impactful reporting that ties back to key corporate objectives.
• Analyzes qualitative and quantitative data, reports and dashboard information to identify trends or anomalies, draw conclusions and make applicable recommendations.
• Remains current on trends, developments and best practices relative to business and data intelligence.
• Performs other related work 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 a quantitative field such as statistics, computer science, business administration, or related field of study; plus, two (2) years of progressively responsible related experience; or equivalent combination of education and/or experience.
• Experience in SQL, SAS, R, Python, or other programming languages.
• Experience building dynamic and interactive dashboards and reports using BI tools like Tableau, MicroStrategy, Microsoft BI.
• Experience with Salesforce reporting capabilities and dashboard creation
• Experience streamlining and automating manual data processes.
• Experience compiling data from disparate sources.

CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS:

N/A

KNOWLEDGE, SKILLS AND ABILITIES:

• Strong Excel skills including preparing and using pivot tables, slicers, charts and graphs.
• Strong analytical skills and research capabilities.
• 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.