Senior Data Engineer - Snowflake SME

Overview

Senior Data Engineer - Snowflake SME role n to apply for this opportunity to architect, develop, and optimize data warehouse and lakehouse solutions using the Snowflake platform, with integration into SAP BDC and related SAP data platforms.

At EY, we’re committed to shaping your future with confidence and helping you succeed in a globally connected, diverse team environment.

As a Snowflake Subject Matter Expert (SME), you will be responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using Snowflake and integrating into SAP BDC. Your expertise will enable the SAP BDC team to build a modern, scalable data platform that integrates SAP data with cloud-native services from Microsoft, Nvidia, Databricks, AWS, and Google. You will collaborate with data architects, engineers, and business teams to ensure data ingestion, storage, and access solutions on Snowflake meet performance, security, and compliance requirements supporting enterprise SAP data migration and analytics.

• 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 Databricks.
• Integrate Snowflake with SAP data sources and other data platform components, including Databricks, Azure Data Factory, and cloud storage.
• 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 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.

• 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 (ADF, Airflow).
• Understanding of data security, 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.

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

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.

The compensation ranges provided comply with United States pay transparency laws; other geographies will follow local salary guidelines. EY focuses on developing future-focused skills and offers a flexible environment with a diverse and inclusive culture of globally connected teams.

• Comprehensive compensation and benefits based on performance, including medical and dental coverage, pension and 401(k), and paid time off options.
• Hybrid model: most client-serving work is expected in person 40-60% of the time.
• Flexible vacation policy and time off for holidays, personal/family care, and other leaves.

EY provides equal employment opportunities regardless of race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or other legally protected basis. EY is committed to reasonable accommodation for qualified individuals with disabilities. For accommodation requests, contact EY Talent Shared Services at 1-800-EY-HELP3 or

EY | Building a better working world. Enabled by data, AI, and advanced technology, EY teams help clients shape the future with confidence and develop answers for today and tomorrow. EY operates in more than 150 countries and territories.