Cloud Data Engineer - Advisor

Job Description
CVS Health has a rich set of healthcare data of more than 150 million individuals and provides the best foundation for any ambitious data engineer to work on billions of records of healthcare data. The Data Engineering Advisor will lead the design of highly scalable and extensible data platforms including but not limited to RDBMS / Big Data / Cloud, which enables industrializing collection, storage, modeling, and analysis of massive data sets from heterogeneous channels.
The Data Engineer Advisor will collaborate with key internal and external stakeholders to analyze and synthesize healthcare related data to meet insights, build reporting dashboards and descriptive/predictive/prescriptive analytic requirements. You will work on data engineering solutions to leverage best practices and industry leading tools and technologies to profile data, develop efficient ingestion, and build semantic data layers by sourcing data from PBM, Specialty, Retail and HealthCare business.
You will conduct proof of concept work on Teradata and/or GCP to design data solutions to explore data, understand the grain and relationship of the data entities, and attributes to implement robust analytic and reporting solutions. You need to have a thorough understanding of how to operationalize and automate the data pipelines on Teradata and/or Big Data environments on on-prem/Cloud environments. You will be primarily be responsible for designing conformed, aggregated, and semantic data layers, and manipulating large datasets to support insights and analytics using SQL, BTEQ, SAS, and similar tools.

Required Qualifications
• 3 Years of Experience with SQL, including Analytical SQL functions
• 1 Year of Experience working with Python
• Experience as a Data Engineer within the cloud environment
• Experience with BI Data visualization in Tableau

COVID Requirements
COVID-19 Vaccination Requirement
CVS Health requires its Colleagues in certain positions to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, pregnancy, or religious belief that prevents them from being vaccinated.
  • If you are vaccinated, you are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status within the first 30 days of your employment. For the two COVID-19 shot regimen, you will be required to provide proof of your second COVID-19 shot within the first 60 days of your employment. Failure to provide timely proof of your COVID-19 vaccination status will result in the termination of your employment with CVS Health.
  • If you are unable to be fully vaccinated due to disability, medical condition, pregnancy, or religious belief, you will be required to apply for a reasonable accommodation within the first 30 days of your employment in order to remain employed with CVS Health. As a part of this process, you will be required to provide information or documentation about the reason you cannot be vaccinated. If your request for an accommodation is not approved, then your employment may be terminated.

Preferred Qualifications
•Traditional relational data warehouse technologies, such as Oracle, Teradata, or DB2
• One of the following programming languages: PySpark, Scala, or Java
• Presenting to audiences including technical, non-technical, and senior leaders
• Managing cross functional initiatives and communicating effectively and confidently with business partners, project team members, and senior management
• Previous healthcare experience and domain knowledge
• Experience working with data and understanding of analytics and how it is leveraged within the healthcare/retail industry

Education
• Bachelor's Degree in Computer Science, Engineering, Statistics, Physics, Math, or related fields; or Advanced Degree
• Preferred: Master's Degree with coursework focused on advanced algorithms, mathematics in computing, data structures, or related field

Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.

We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. 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.