Aetna Sr Data Engineer in Chicago, Illinois

Req ID: 42879BR


The person hired for this role will be have primary responsibility for designing and overseeing development of ETL processes and development for a new, wide-ranging healthcare informatics platform. In concert with a multi-disciplinary team of software developers, data architects, UX designers and business SMEs, the ETL Lead will ensure thorough and comprehensive data management and semantic development for a complex, multi-functional analytics software platform being developed both for the Aetna enterprise and as a “Next Generation solution in the marketplace. Healthcare data and analytics experience is highly desirable as is experience working with the wide range of data inputs available to a major, vertically integrated, national healthcare payer. Knowledge/experience with Hadoop, Hive, BigIntegrate, DataSphere, Aginity, and BI applications highly desirable. This position has room for growth in the future .


5 or more years of progressively complex related experience.

Has strong knowledge of large scale search applications and building high volume data pipelines.

Experience building data transformation and processing solutions.

Knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.


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

Telework Specifications:

Hartford, Wellesley, NYC


Knowledge in Java, Python, Hive, Cassandra, Pig, MySQL or NoSQL or similar.

Experience with bash shell scripts, UNIX utilities & UNIX Commands.

Ability to understand complex systems and solve challenging analytical problems.

Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources.

Strong collaboration and communication skills within and across teams.

Strong problem solving skills and critical thinking ability.

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

Job Function: Information Technology