Data Engineer

CVS Health is dedicated to shaping a more connected and compassionate health experience. They are seeking a Data Engineer to engage with complex healthcare data, designing and maintaining data pipelines to support data-driven business decisions and contribute to innovative data products. Responsibilities Build and optimize analytical data models in BigQuery. Implement partitioning, clustering, and materialized views for performance and cost efficiency. Ensure compliance with data governance, access controls, and IAM best practices Develop integrations with external systems (APIs, flat files etc.) using GCP-native or hybrid approaches. Utilize tools like Dataflow or custom Python/Java services on Cloud Functions or Cloud Run to handle transformations and ingestion logic Build automated CI/CD pipeline using Cloud Build, GitHub Actions, or Jenkins for deploying data pipeline code and workflows. Set up observability using Cloud Monitoring, Cloud Logging, and Error Reporting to ensure pipeline reliability Skills 1+ years of experience with SQL, NoSQL 1+ years of experience with Python (or a comparable scripting language) 1+ years of experience with Data warehouses (such as data modeling and technical architectures) and infrastructure components 1+ years of experience with ETL/ELT, and building high-volume data pipelines 1+ years of experience with reporting/analytic tools 1+ years of experience with query optimization, data structures, transformation, metadata, dependency, and workload management 1+ years of experience with Big data and cloud architecture 1+ years of hands-on experience building modern data pipelines within a major cloud platform (GCP) 1+ years of experience with deployment/scaling of apps on containerized environment (i.e. Kubernetes, AKS) 1+ years of experience with real-time and streaming technology (i.e. Kafka, Spark Streaming) 1+ year(s) of soliciting complex requirements and managing relationships with key stakeholders Experience with complex systems and solving challenging analytical problems Strong collaboration and communication skills within and across teams Knowledge of data visualization and reporting Experience in designing and building data engineering solutions in cloud environments (preferably GCP) Experience with Git, CI/CD pipeline, and other DevOps principles/best practices Experience with bash shell scripts, UNIX utilities & UNIX Commands Understanding of software development methodologies including waterfall and agile Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources Knowledge of API development Experience with schema design and dimensional data modeling Google Professional Data Engineer Certification Knowledge of microservices and SOA Formal SAFe and/or agile experience. Previous healthcare experience and domain knowledge Experience designing, building, and maintaining data processing systems Experience architecting and building data warehouse and data lakes Benefits Medical, dental, and vision coverage Paid time off Retirement savings options Wellness programs Other resources Company Overview CVS Health is a health solutions company that provides an integrated healthcare services to its members. It was founded in 1963, and is headquartered in Woonsocket, Rhode Island, USA, with a workforce of 10001+ employees. Its website is Company H1B Sponsorship CVS Health has a track record of offering H1B sponsorships, with 1 in 2022. Please note that this does not guarantee sponsorship for this specific role.