Jobs · Information Technology · California

Senior Data SAP Engineer

EY · San Francisco, CA · 5 days ago
On-siteInformation Technology$87k–$163k/yrFull-time

About the role

The opportunity is to serve as a Snowflake Subject Matter Expert (SME) responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using the Snowflake platform and integrating into SAP Business Data Cloud (BDC).

Responsibilities

  • Design and implement Snowflake data warehouse and lakehouse architectures aligned with SAP data migration strategies.
  • Develop and optimize Snowflake SQL queries, stored procedures, and data transformation logic to support SAP workloads.
  • Manage Snowflake account configurations, resource monitors, virtual warehouses, and access controls.
  • Integrate Snowflake into SAP BDC, SAP Databricks, and other cloud ecosystems.
  • Implement best practices for data partitioning, clustering, and caching to optimize performance and cost-efficiency.
  • Participate in data ingestion automation, metadata management, and monitoring within Snowflake environments.
  • Collaborate with security teams to enforce data governance, encryption, and compliance policies in Snowflake.
  • Support Continuous Integration/Continuous Deployment (CI/CD) and automation of Snowflake deployment and pipeline orchestration.
  • Provide knowledge transfer and technical guidance to team members and clients.
  • Stay updated on Snowflake innovations and new features relevant to SAP data platforms.

Skills and attributes for success

  • Deep expertise in Snowflake data warehouse platform, including performance tuning and cost optimization.
  • Strong SQL skills and experience with Snowflake-specific features such as Time Travel, Zero Copy Cloning, Streams, and Tasks.
  • Experience with integration into SAP BTP, BDC, and HANA DB.
  • Familiarity with SAP data types, structures, and migration tools for seamless integration with Snowflake.
  • Experience with cloud ecosystems (Azure, AWS, GCP) and data orchestration tools (Azure Data Factory, Airflow).
  • Understanding of data security, role-based access control (RBAC), and compliance in Snowflake.
  • Knowledge of data modeling principles for enterprise data warehouses.
  • Excellent communication and collaboration skills to work with global SAP and data teams.

Other Requirements

  • Experience working on SAP migration or BDC data projects is preferred.
  • Agile and DevOps experience with automation and pipeline deployment.
  • Certifications like SnowPro Core Certification or relevant cloud certifications are desirable.
  • Willingness to work in distributed teams and coordinate across time zones.

Job Requirements

  • Education: BS/MS in Computer Science, Data Engineering, Information Systems, or a related field.
  • Experience: 9+ years in data warehousing and cloud data platforms with 5+ years of hands-on Snowflake experience.

What we offer you

  • Compensation and benefits package including medical and dental coverage, pension, and 401(k) plans, and a wide range of paid time off options.
  • A flexible vacation policy allowing you to decide how much vacation time you need based on your personal circumstances.
  • A hybrid model with most people in external, client-serving roles expected to work together in person 40-60% of the time over the course of an engagement, project, or year.

Similar jobs