Sep 18, 2019

Data Engineering Internship (Undergraduate)

  • Professional Diversity Network
  • New York, NY, USA
Full-Time Engineering

Job Description

CVS Health

Job Description
Data Engineering Internship (Undergraduate)

Start date: June 1st, 2020
End Date: August 7th, 2020

Aetna, a CVS Health company, is the nation's premier health innovation company helping people on their path to better health. We are building a new health care model that is easier to use, less expensive, and puts the consumer at the center of their care.

Who we are
Aetna's Analytics & Behavior Change team supports the entire organization by embedding deep analytic insights into key decision processes and focusing on our biggest, most complex problems. We use advanced analytics tools, modeling and machine learning to generate insights by leveraging data within a cutting-edge petabyte-scale Hadoop environment. We're focused on creating new opportunities that drive change in areas such as member behavior change, digital health, provider efficiency, clinical products/programs, and health care fraud detection and prevention.
Our goal is to make health care simpler, more affordable, and convenient. We are inspired to make a difference by connecting people to the information they need and helping our members feel the joy of achieving their best health in their own way. Our opportunities in Data Science and Data Engineering are designed to enhance your personal and professional growth and build the skills that will lead you to success. Aetna Analytics has the feel of a fresh startup within a 165 year old company, and we're looking for people who like solving tough challenges and are motivated by a desire to drive change.

What you will do
* Participate in the design, build and management of large scale data structures and pipelines to support analytical needs.
* Assist in the development of large scale data structures and pipelines to organize, collect, and standardize data that helps generate insights and addresses reporting needs
* Apply understanding of key business drivers to accomplish work
* Use expertise judgment and precedents to contribute to the resolution of moderately complex problems
* Leads portions of initiatives of limited scope, with guidance and direction
* Write ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing
* Collaborate with client teams to transform data and integrate algorithms and models into automated processes
* Use knowledge in Hadoop architecture, HDFS commands, and experience designing & optimizing queries to build data pipelines
* Use programming skills in Python, Java, or any of the major languages to build robust data pipelines and dynamic systems
* Build data marts and data models to support clients and other internal customers
* Integrate data from a variety of sources, assuring it adheres to data quality and accessibility standards

Required Qualifications
* Knowledge in Java, Python, Hive, Cassandra, Pig, MySQL, NoSQL, or similar applications
* Experience with bash shell scripts, UNIX utilities, and UNIX Commands.
* Knowledge of large scale ML/DL based predictive analytics applications and building high volume data pipelines
* Experience building data transformation and processing solutions
* The ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources
* The ability to understand complex systems and solve challenging analytical problems

Preferred Qualifications
* Knowledge in Hadoop architecture, HDFS commands, and experience designing & optimizing queries against data in the HDFS environment
* Strong collaboration and communication skills within and across teams
* A passion to help transform health care

* You should currently be pursuing a Bachelor's degree with an anticipated graduation date between December 2020 and August 2021
* Preferred/relevant majors include Computer Science/Engineering, Electrical Engineering, Information Systems, Mathematics, Physics
* 3.3+ cumulative GPA

Business Overview
It's a new day in health care.

Combining CVS Health and Aetna was a transformative moment for our company and our industry, establishing CVS Health as the nation's premier health innovation company. Through our health services, insurance plans and community pharmacists, we're pioneering a bold new approach to total health. As a CVS Health colleague, you'll be at the center of it all.

We offer a diverse work experience that empowers colleagues for career success. In addition to skill and experience, we also seek to attract and retain colleagues whose beliefs and behaviors are in alignment with our core values of collaboration, innovation, caring, integrity and accountability.

CVS Health is an equal opportunity/affirmative action employer. Gender/Ethnicity/Disability/Protected Veteran - we highly value and are committed to all forms of diversity in the workplace. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities. We comply with the laws and regulations set forth in the following EEO is the Law Poster: EEO IS THE LAW and EEO IS THE LAW SUPPLEMENT. We provide reasonable accommodations to qualified individuals with disabilities. If you require assistance to apply for this job, please contact our Advice and Counsel Reasonable Accommodations team. Please note that we only accept applications for employment via this site.

If technical issues are preventing you from applying to a position, contact Kenexa Helpdesk at 1-855-338-5609 or For technical issues with the Virtual Job Tryout assessment, contact the Shaker Help Desk at 1-877-987-5352.rj6-Fz22E-I.K



Apply Now