Business Intelligence Developer

At American Equity 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 Business Intelligence (BI) Developer supports enterprise-wide 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:

• Works within a Center of Excellence (COE) model for supporting business enablement of accurate and timely reporting and data analytics.
• As subject matter expertise, performs technical design and development of effective, dynamic, and interactive data visualizations, including business dashboards and reports that meet cross-functional needs of the business.
• Establishes and communicates standards and best practices for data visualization and dashboarding.
• Designs and administers the enterprise BI platform, including responsibility for extracting data form various data sources and testing and maintenance.
• Coaches and trains business users on the BI platform.
• Transforms business partner data needs into deliverables, including but not limited to, data models, data mappings and data transformation rules.
• Leads and executes complex data related analytical projects that drive business decisions and efficiencies.
• Researches, analyzes, validates and documents business requirements for integrating business data sources into the enterprise data warehouse.
• Creates process/data flow maps of data links between systems, current processes, areas of opportunity to improve process flows and new systems or data to integrate.
• Creates and maintains streamlined, documented processes for productionizing reports.
• Proactively improves the quality of data and frequency of company reporting.
• Ensures adherence to data management and data governance policies and standards.
• 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, mathematics, computer science, MIS, information technology or related field of study; plus five (5) years of progressively responsible related experience; or equivalent combination of education and/or experience.

CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS

N/A

KNOWLEDGE, SKILLS AND ABILITIES:

• Strong analytical skills and research capabilities.
• Advanced experience in SQL, SAS, R, Python, or other programming languages.
• Advanced experience building dynamic and interactive dashboards and reports using BI tools like Tableau, MicroStrategy, Microsoft BI.
• Demonstrated experience streamlining and automating manual data processes.
• Demonstrated experience compiling data from disparate sources.
• 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.

For more information about how your information is processed, please click on the Privacy tab at the bottom of the page and then click on the Applicant Privacy Policy.