Medicare STARS Data Intelligence Corporate Intern - Summer 2024

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