Aetna Data Engineer in New York, New York

Req ID: 57100BR


The Date Engineer participates in the design, build and management of large scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows.

Fundamental Components:

Assists in the development of large scale data structures and pipelines to organize, collect and standardize data that

helps generate insights and addresses reporting needs.

Applies understanding of key business drivers to accomplish own work.

Uses expertise, judgment and precedents to contribute to the resolution of moderately complex problems.

Leads portions of initiatives of limited scope, with guidance and direction.

Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and

offline analytic processing.

Collaborates with client 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 programming skills in Python, Java or any of the major languages to build robust data pipelines and dynamic


Builds data marts and data models to support clients and other internal customers.

Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.


  • Experience with massively parallel processing systems like Spark, Scala or Hadoop

  • At least 3 years experience with big data and the Hadoop ecosystem (HDFS, SPARK, Hive, ORC, HBase) required

  • Hands-on experience in back-end programming, particularly Java and Scala

  • Expert, high-level coding skills such as SQL/PL-SQL and scripting languages(UNIX) required, Scala is a plus

  • Experience with source code control systems (GIT) and CI/CD process(Jenkins/Team City/Octopus)

  • Involvement in the design, prototyping and delivery of software solutions within the big data eco-system

  • Able to perform code reviews to ensure that code meets acceptance criteria

  • Familiar with Data Modelling/Mapping and implementing them in development

  • Familiarity with Star schema data models

  • Experience with Agile development methodologies and tools to iterate quickly on product changes, developing user stories and working through backlog, Improving data governance and quality, increasing the reliability of our data.

  • Able to work in a team environment

  • Professional communication skills both written and verbal.


Experience with JIRA a plus

AWS knowledge (S3/Redshift/Lambda/Data Pipeline)


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.


  • This is an office based job.

Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.

We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.

Together we will empower people to live healthier lives.

Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.

We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.

Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Aetna takes our candidates'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.

Job Function: Data & Analytics

Aetna is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veterans status.