Senior Data Engineer

Senior Data EngineerWe'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.The Senior Data Engineer will design, build, and support data engineering solutions on Google Cloud Platform, with a focus on scalable data pipelines, database integration, and ETL processes that enable analytics, reporting, and downstream application consumption. The role is responsible for data ingestion and transformation using GCP-native services such as BigQuery, Spanner, and Dataflow, alongside integration with enterprise databases including Oracle, PostgreSQL, and SQL Server.The Senior Data Engineer will possess strong hands-on experience with GCP data and compute services, relational and distributed databases, ETL tooling, and Unix/Linux environments. This individual will contribute to the design, development, performance tuning, and operational support of data platforms, working closely with senior engineers and architects to deliver reliable, efficient, and well-monitored data solutions.Expectations for the Role:Design, develop, and maintain data pipelines using GCP services including BigQuery, Cloud Spanner, and Dataflow for batch and streaming data processingBuild and support ETL/ELT workflows that extract, transform, and load data across Oracle, Spanner, SQL Server, PostgreSQL, and other relational databasesDevelop and optimize BigQuery datasets, tables, partitioning, and clustering strategies to support efficient querying and reportingImplement and tune Dataflow pipelines for data transformation, enrichment, and movement between source systems and target data storesMonitor and manage Compute Engine VMs, including CPU utilization, resource allocation, and performance tuning across GCP workloadsSupport and troubleshoot other core GCP technologies such as Cloud Storage, Cloud Composer, Pub/Sub, and IAM as part of end-to-end data workflowsApply data warehousing concepts including dimensional modeling, star/snowflake schemas, slowly changing dimensions, and data mart designDevelop and support ETL workflows using tools such as Informatica, integrating with GCP and on-premise database systemsWork extensively in Unix/Linux environments including shell scripting, file system navigation, permissions management, and log/file handlingSchedule, monitor, and troubleshoot batch jobs using Control-M, ensuring timely and reliable execution of data pipelinesParticipate in Agile/JIRA-based development processes, including sprint planning, ticket tracking, status updates, and defect managementCollaborate with senior engineers and architects on performance tuning, query optimization, and database design across multiple platformsTroubleshoot data pipeline failures, performance bottlenecks, and data quality issues across the stackDocument technical designs, operational runbooks, and support procedures for the platforms being builtStay current with emerging AI/ML and GenAI tools and proactively apply them to improve productivity, automate repetitive tasks, and streamline development and data engineering workflowsRequired Qualifications:5+ years of experience in data engineering, software engineering, or database development3+ years of hands-on experience with Google Cloud Platform (GCP) products, especially BigQuery, Cloud Spanner, and DataflowStrong experience working with multiple database platforms, especially Oracle, Spanner, SQL, and PostgreSQLWorking knowledge of Google ETL technologies and other core GCP services (Compute Engine/VMs, Cloud Storage, Cloud Composer, Pub/Sub)Experience with performance tuning, including CPU utilization analysis and resource optimization on GCP compute resourcesSolid understanding of data warehousing concepts (dimensional modeling, fact/dimension tables, ETL design patterns)Experience with ETL tools such as Informatica for data integration and transformationStrong Unix/Linux experience, including shell scripting and file system handlingExperience with job scheduling tools such as Control-MStrong SQL development skills and ability to write/optimize complex queriesPreferred Qualifications:Good troubleshooting, communication, and collaboration skillsAwareness of AI/GenAI tools and techniques, with a willingness to continuously learn and upskill to adopt new technologies that improve engineering efficiencyExperience with additional databases such as MongoDB, MySQL, or CassandraExposure to Cloud Composer (Airflow) for workflow orchestrationExperience with Kafka, Pub/Sub, or event-driven data architecturesFamiliarity with Terraform or Infrastructure as Code practices.Experience with GKE/KubernetesExposure to CDC (Change Data Capture) tools and replication technologiesExperience in Agile/SAFe environments within large enterprisesHealthcare or retail industry experienceGCP certification (e.g., Professional Data Engineer) preferredFamiliarity with Agile methodologies and JIRA for project tracking and development workflowsEducation:Bachelor's degree or equivalent experience (High School Diploma and 4 years relevant experience)Business Overview: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. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected 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.Anticipated Weekly Hours: 40Time Type: Full timePay Range: The typical pay range for this role is: $83,430.00 - $222,480.00. 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.Great benefits for great peopleWe 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.