Staff Salesforce Engineer at CVS Health in Galway

Job description

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 The Staff Engineer - Salesforce & Data Engineering reports to the Director of Growth and serves as a technical authority bridging Oak Street Health’s Salesforce CRM ecosystem with enterprise-grade cloud data platforms. This role is responsible for architecting, designing, and deploying scalable end-to-end data pipelines and custom programmatic Salesforce solutions that optimize workflows and drive operational efficiency across the organization. The Staff Engineer mentors engineering team members at all levels and serves as a primary SME for cloud data architecture, Salesforce data integration patterns, and engineering best practices. The key responsibilities for this role are as follows: Lead the architecture, design, and deployment of scalable Azure Databricks data pipelines using PySpark, Delta Live Tables, and Medallion Architecture (Bronze, Silver, Gold layers). Drive enterprise architecture and custom development across the Salesforce platform, including Lightning Web Components (LWC), Visualforce, Apex (Classes, Controllers, Triggers), and Salesforce Flows. Architect and maintain robust enterprise integrations and complex data sync patterns between Salesforce, Azure Data Lake Storage (ADLS), and cloud/on-prem environments. Modernize legacy infrastructure by migrating on-prem SQL pipelines into scalable, cloud-native Databricks solutions using configuration-driven framework patterns (YAML, JSON). Establish DevOps & CI/CD standards across both Salesforce and Data Engineering domains using Infrastructure as Code (IaC) and Pipeline as Code methodologies. Define platform strategy and collaborate with upstream/downstream teams, IT, and BI to drive data quality, eliminate technical debt, and resolve complex architectural bottlenecks. Set technical standards and mentor engineers through rigorous design and code reviews, ensuring platform performance, security, and governance standards are met across teams. Serve as the highest-tier escalation point for complex production issues, pipeline failures, and system performance optimizations. Lead Medicare and payer-focused data initiatives involving member, claims, and operational datasets while ensuring strict PHI/PII compliance and regulatory standards (HIPAA). Create and maintain enterprise-grade documentation for platform architecture, data models, integration standards, and operational procedures. Other duties as assigned. Required Qualifications 8+ years experience in Software Development, Cloud Technology, or Data Engineering building large-scale platforms. 5–7+ years of hands-on Data Engineering experience with Azure Databricks, Delta Lake, and Azure Data Lake Storage (ADLS). Advanced PySpark development experience, including DataFrames, transformations, joins, aggregations, and performance tuning. Experience developing and maintaining Delta Live Tables (DLT) pipelines. Strong SQL and relational database background (e.g., SOQL, SOSL, MySQL, SQL Server, Oracle) with experience supporting and migrating legacy SQL environments to modern Python/PySpark architectures. Minimum 3+ years working experience with Salesforce custom development (Apex, Visualforce, LWC, web services - SOAP/REST) and Flow automation. Strong understanding of Medallion Architecture (Bronze, Silver, Gold) and building ingestion, transformation, and curation pipelines across all layers. Experience with Infrastructure as Code (IaC), Pipeline as Code, YAML, JSON, and configuration-driven patterns. Experience automating CI/CD deployments using DevOps pipelines acr