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.
Role Description and Responsibilities
The Staff Engineer - Salesforce & Data Engineering reports to Data Engineering Leadership and executive engineering management, 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 key responsibilities for this role are:
- 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.
What we're looking for
- 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 across both cloud data and Salesforce environments.
Benefits
- The opportunity to be part of a hyper-growth company focused on changing the future of healthcare.
- High levels of responsibility and opportunities for rapid advancement.
- Generous retirement options, paid vacation/sick time, as well as health, vision and dental benefits.
- Supportive and fun culture.
- HQ (the 'Treehouse') is located in the heart of Downtown, close to many public transit options and great restaurants.