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.

The Senior Data Engineer designs, develops 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

• 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.

Direct Reports: 0

General Description of Indirect Reports (2 and 3-downs): 0

• 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).
• Postgre
  
  SQL, 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.

N/A

• 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.