Senior Data SAP Engineer

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

• Comprehensive compensation and benefits package including medical and dental coverage, pension, and 401(k) plans.
• Flexible vacation policy allowing you to decide how much vacation time you need based on your personal circumstances.
• Hybrid work model with expectations for most people in external, client-serving roles to work together in person 40-60% of the time over the course of an engagement, project, or year.
• Additional benefits such as paid time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence.