Description: This Sr. Data Engineer role will be working with a group of Data Scientists and Data Engineers developing a Next Best Action recommendation system. They will be responsible for creating and managing data pipelines that support core system functionality and reporting. They will work within the team's Agile processes to create a high-quality systems and processes, and they will collaborate with other teams to achieve the best possible results.
Develops large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs.
Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.
Collaborates with data science team to transform data and integrate algorithms and models into automated processes.
Uses knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries to build data pipelines.
Uses strong programming skills in Python, Java or any of the major languages to build robust data pipelines and dynamic systems.
Builds data marts and data models to support Data Science and other internal customers.
Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.
Analyzes current information technology environments to identify and assess critical capabilities and recommend solutions.
Experiments with available tools and advises on new tools in order to determine optimal solution given the requirements dictated by the model/use case.
7+ years writing SQL queries, understanding logic of existing queries, and developing relational databases.
5+ year with languages used for data engineering (Java, R, Python, H2O, etc.)
5+ years with Linux via CLI and Shell Scripting
3+ years of experience data engineering on Hadoop (HDFS, Hive, Pig, HBase, etc.)
#LI-DT1 Potential Telework Position: No Percent of Travel Required: 0 - 10% EEO Statement: Aetna is an Equal Opportunity, Affirmative Action Employer Benefit Eligibility: Benefit eligibility may vary by position. Click here to review the benefits associated with this position. Candidate Privacy Information: Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.