Senior Data Engineer

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