This program is a 10-week full-time opportunity that provides real work experience with a team in your business area. You will be aligned to projects to lead or contribute to while also participating in networking, development, and career exploration activities. Our Corporate Interns can apply for future full-time roles during the program and have an increased likelihood to receive an offer for a post-graduation role.
The Summer 2024 program will run June 3rd – August 9th, 2024. Virtual onboarding activities will also take place May 29th -31st, 2024. This is a hybrid position with 3 days (generally Tuesday, Wednesday, and Thursday) in one of the following office locations based on your preference: Hartford, CT & Chicago, IL. The other 2 days each week will be working remotely from home, office, or another location of your choice. No housing or housing stipend will be provided, but interns will be given the opportunity to connect with each other prior to the start of the program to coordinate housing if desired.
The hourly rate is $23/hr with 40 hours/ week, no work on July 4th (company holiday), and two days of paid leave.
About this business area:
Aetna’s Medicare Stars Data Intelligence team supports the entire Medicare organization by participating in the design, build, and management of large-scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows. The Data Intelligence team is focused on creating a framework for developing large scale data structures and pipelines to organize, collect, and standardize data that helps generate insights and addresses reporting needs focusing on complex business problems. We use advanced technology and tools, data modeling techniques, and ETL processes to enable data acquisition by leveraging big data within a cutting-edge environment.
You will gain valuable work experience and participate in:
Projects that contribute to the success of our business
Community service activities
Professional development workshops
Mentorship and networking opportunities
Interaction with senior leaders
And our corporate interns have an increased likelihood to receive an offer for a future role with CVS Health.
Examples of past internship projects include:
Develop ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.
Document and create Architectural models for current state and future state for innovation projects
Develop Ingress/Egress Process for publishing Strategic Data into our GCP Cloud Environment
Cloud Migration – Participate in developing the strategic Approach for migrating a component of our On-prem Architecture to Azure Cloud, potential for ADF development
Cloud Migration – GCP Ingress/Egress project opportunity
Data Migration – Develop new ETL for an existing legacy Data Pipe
Work visa sponsorship is not available for this role. This includes participation in Curricular Practical Training (CPT), Optional Practical Training (OPT), and F-1 Visa programs.
Required Qualifications
Meet educational requirements (see education section)
Have a willingness to relocate to Hartford, CT or Chicago, IL
Experience with Visual Studio, & SQL or similar
Knowledge of Cloud architecture including GCP and MS Azure
Preferred Qualifications
Experience with MSSQL Server, SSIS, Microsoft .Net Framework, ASP, C#,
Demonstrated leadership experience. Examples include: active roles in student or social organization activities, sports, or school or work-related projects
Strong written and verbal communication skills
Internship or work experience in related field such as business or healthcare
Have an interest in obtaining full-time position within CVS Health upon graduation
Be able to work in a fast-paced environment and meet tight deadlines
Possess strong analytical and problem resolution skills
Be able to communicate effectively with a diverse audience
Encourage teamwork and a positive environment to improve team effectiveness
Be resourceful and can quickly and successfully adapt to change
Knowledge of large-scale search applications and building high volume data pipelines
Database modeling experience
Education
Currently pursuing a Bachelor’s degree
Have an anticipated graduation date between September 2024 and August 2025
Have a major, minor or concentration relevant to the position such as Computer Science, Business information Systems, MIS, Computer Engineering any other data-driven field