Medicare Stars Data Engineer

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.
 
Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.

Position Summary

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.

Aetna's Medicare Stars Data Intelligence Team is growing and expanding. This is exciting opportunity to join a high performing, collaborative team as a Data Engineer. Aetna’s Medicare 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. We’re focused on creating new opportunities that drive change in areas such as Medicare Stars, Service Operations, Patient Safety, population health management and member experience.

The Data Engineer will participate in the design, build and management of large-scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows and 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. They apply understanding of key business drivers to accomplish their own work and uses expertise, judgement, and precedents to contribute to the resolution of moderately complex problems. They may leads portions of initiatives of limited scope, with guidance and direction. Primarily develops 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 programming skills in .Net, C#,SSIS, Python or any of the major languages to build robust data pipelines and dynamic systems. 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.
 

Required Qualifications

- Strong collaboration and communication skills within and across teams.

- 2 or more years of progressively complex related experience.

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

- Ability to understand complex systems and solve challenging analytical problems.

- Experience with MSSQL Server, SSIS, Microsoft .Net Framework, ASP, C#, Visual Studio, & SQL or similar.

- Some Knowledge of Cloud architecture including GCP and MS Azure

- Experience designing & optimizing queries against data in Relational databases and Big Data environments.

- Experience building data transformation and processing solutions.

- Strong knowledge of large-scale search applications and building high volume data pipelines.

Preferred Qualifications

You should:

• Have a passion to help transform health care

• Have strong Interest in Health Care

• 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

• Have an interest in obtaining full-time position within CVS Health

• Prior Database modeling experience preferred

Education
Bachelor's degree or equivalent work experience in Computer Science, HealthCare Informatics, Computer Engineering, Inf