Principal Data Engineer

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary: Caremark LLC, a CVS Health company, is hiring for the following role in Hartford, CT: Principal Data Engineer to develop large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs. Collaborate with data science team to transform data and integrate algorithms and models into automated processes. Build data marts and data models to support Data Science and other internal customers. Integrate data from a variety of sources, assuring that they adhere to data quality and accessibility standards. Analyze current information technology environments to identify and assess critical capabilities and recommend solutions. Build high-performance data processing frameworks leveraging cloud and/or on-premise data platform. Design and build large-scale data structures, pipelines, and efficient Extract/Load/Transform (ETL) workflows. Write ETL (Extract / Transform / Load) processes, design database systems, and develop tools for real- time and offline analytic processing. Transform data and integrate algorithms and models into automated processes. Analyze and synthesize data to meet the insights, reporting dashboard, and descriptive/predictive/prescriptive analytic requirements. Design conformed, aggregated, and semantic data layers, and manipulating large datasets to support insights and analytics using SQL, BTEQ, SAS, and similar tools, as applicable. Data management in building data layers in Sandbox or a production environment for reporting and analytical use cases. Work on "big data" platforms, including Hadoop (Azure or GCP preferred) and Spark, as applicable. Design data models and solutions for analytical and reporting use cases. Use knowledge in Hadoop architecture, HDFS commands, and experience as applicable, designing and optimizing queries to build data pipelines. Use strong programming skills in Python, Java, and/or any of the major languages to build robust data pipelines and dynamic systems. Experiment with available software tools and advise on new tools in order to determine optimal solution given the requirements dictated by the model/use case. Support modeling/diagramming and build design specifications for data objects and surrounding data processing logic. Collaborate with business solution strategists and support new data source onboarding process through data discovery, profiling, and mapping. Participate in proof of concepts to build the data layers and concepts to derive analytical insights. Leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources. Telecommuting available. Multiple positions.

Requirements: Master’s degree (or foreign equivalent) in Computer Science, Computer Information Systems, Data Science, Statistics, Mathematics, Analytics, or a related field and two (2) years of experience in the job offered or related occupation. Requires two (2) years of experience in each of the following :
• Cloud migration technologies: Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP);
• Messaging platform: Kafka;
• Containerization runtime platform;
• Solution Architecture, design, and end-to-end delivery of projects;
• Domain support for healthcare or retail organization;
• Build Proof of Value (PoV) and MVP using AI: Generative AI, AutoML, or Virtual AI Databases;
• Provide guidance on Large Language Model (LLM) selection and use of Minimum Viable Products (MVPs);
• Conduct Data Quality assessments, define Data Governance processes through Data Quality and MLOps; and
• Establish data architectures and best practices.

Pay Range: $144200.00/year to $288400.00/year.

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls.  The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.  This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.  This position also includes an award target in the company’s equity award program. 

In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities.  The Company offers a full range of medical, dental, and vision benefits.  Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees.  The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners.  As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies. 

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.

This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.

Additional details about available benefits are provided during the application process and on Benefits Moments.

This job does not have an application deadline, as CVS Health accepts applications on an ongoing basis.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.