Data Engineer at CVS Health in Wellesley Hills, MA

Summary: CVS Health is building a world of health around every individual, and they are seeking a Data Engineer to help pave the way in the healthcare industry. This role involves designing, developing, and maintaining data pipelines to handle large datasets, ensuring data-driven business decisions are supported effectively. 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 Required Qualifications: - 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 - Bachelor's Degree or equivalent work experience in Computer Science, Information Systems, Data Engineering, Data Analytics, Machine Learning, or related field required Preferred Qualifications: - 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 Required Skills: SQL, Python, Data Warehousing, ETL/ELT, BigQuery Important Skills: GCP, Data Pipelines, CI/CD, Kubernetes Nice-to-Have Skills: Kafka, Data Visualization, API Development, Agile Methodologies, Communication Skills Benefits: Affordable medical plan options, 401(k) plan (including matching company contributions), Employee stock purchase plan, No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching, Paid time off, Flexible work schedules, Family leave, Dependent care resources, Colleague assistance programs, Tuition assistance, Retiree medical access