American Equity Business Intelligence Developer - Data Management Department in West Des Moines, Iowa
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.
General Description of Indirect Reports (2 and 3-downs):
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:
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.
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.