Senior Data Engineer

American Equity•West Des Moines, IA

8d•Onsite

About The Position

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.

Requirements

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

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.