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, headquartered in Des Moines, Iowa, for over thirty years with satellite offices in Charlotte, NC and New York, NY.
GENERAL PURPOSE OF THE JOB:
The Senior Data Engineer designs, developments and implements data architectures and processes, particularly related to building and maintaining a centralized data platform. The Senior Data Engineer also defines and builds the data pipelines that extract, collect, ingest, normalize and centralize data from various data sources.
**Position sits in Des Moines and will work an onsite schedule**
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Designs and implements automation of processes to optimize data delivery.
- Creates and maintains data pipeline architecture.
- Assembles large, complex data sets that meet business requirements.
- Builds the infrastructure required for extraction, transformation and loading of data from a variety of data sources.
- Designs, implements and maintains data warehouse.
- Develops new and maintains existing transformation processes.
- Designs and implements data replication, Extract, Transform, Load (ETL) processes related to loading data into warehouse.
- Completes data mappings.
- Creates processes for obtaining, normalizing and cleansing data.
- Joins weekly production support rotation.
- Provides data validation and investigation when issues arise.
- Collaborates with other teams - business and data analysts, QA team, deployment teams, and attends CAB meetings, when needed.
- Performs other related work as assigned.
SUPERVISORY RESPONSIBILITIES:
Direct Reports: 0
General Description of Indirect Reports (2 and 3-downs): 0
EDUCATION AND/OR EXPERIENCE:
- Bachelor's degree in Computer Science, MIS, Mathematics, Information Management or related field of study; plus a minimum of 4 years of progressively responsible related experience; or equivalent combination of education and/or experience.
- Experience working with ETL processes and frameworks.
- SQL experience required.
- Snowflake (required).
- Git (required).
- Python (basic).
- PostgreSQL, MS SQL Server (working knowledge).
- Experience with and advanced knowledge of data management policies, procedures and practices including data warehouse and data mart concepts.
- Experience with and working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools.
- Experience working with data reporting tools.
CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS: N/A
KNOWLEDGE, SKILLS AND ABILITIES:
- Technologically adept.
- Strong analytical and problem-solving skills.
- Strong SQL skills.
- Experience with cloud data warehouses.
- Ability to independently investigate and resolve data issues.
- Comfort with production support responsibilities and P1 escalations.
- Ability to effectively develop and manage relationships.
- Strong customer service orientation.
- Effective verbal and written communication skills with ability to effectively present information and respond to questions.
- Ability to work cooperatively and successfully with employees, customers, and other outside third parties.
- Strong organizational and planning skills.
- 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.
- Minimal to no travel is required in this position.
____
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.
#LI-PL1