Cloud Data Engineer - Senior Consultant

Job DescriptionCVS Health 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. Data Engineering is one of the foundational pillars driving CVS Health into a data centric company. You will be part of a large group of highly accomplished data engineers to help build innovative solutions and manage data using the latest tools and technology. Whether you are a cloud engineer, big data expert, or data warehouse practitioner, you will have ample opportunity to contribute, grow and achieve your best working for Fortune 5’s largest healthcare company.What you will do: 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 – Big Data, Senior Consultant will support the building and architecture of next-generation Big Data Machine Learning framework developed on a group of core Hadoop technologies. You will support and work on the design 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 Senior Consultant, Data Engineer Big Data will collaborate with key internal and external stakeholders to analyze and synthesize the healthcare related data to meet the insights, reporting dashboard, 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 support proof of concept work on Teradata, Azure, 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 understand SAFe agile framework, DevOps, and how to operationalize and automate the data pipelines on Teradata and/or Big Data environments on on-prem/Cloud environments. You will be primarily 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 QualificationsBachelor’s Degree in Computer Science, Engineering, Statistics, Physics, Math, or related field with 3+ years of professional or business analytics experience; or Master’s Degree with 1+ year of experience in: 1-2 years of experience on “Big data” platforms such as Hadoop, hive and Spark, Sqoop and NoSQL Minimum 1 year of experience as a Cloud data engineer preferably on GCP platform with working experience on Bigquery, Dataproc and Cloud Composer. Other Cloud platforms like AWS, Azure are welcome as well. 1-2 tears of experience in traditional data warehouse technologies, such as Oracle, Teradata, or DB2 1-2 years programing experience in one of the following languages: PySpark, Scala, or Java 1-2 years working experience in SQL, including Analytical SQL functions Should be able to translate analytical business problems into Procedural construct with SQL, Python and SparkCOVID RequirementsCOVID-19 Vaccination RequirementCVS 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 QualificationsCloud Engineer with good Database background and Language expertise in SQL, PythonEducationBachelor’s Degree in Computer Science, Engineering, Statistics, Physics, Math, or related field; or Advanced DegreeBusiness OverviewAt Aetna, a CVS Health company, 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 are committed to maintaining a diverse and inclusive workplace. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, gender, gender identity, age, disability or protected veteran status. 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.