At EY, the business problem is to build a modern, scalable data platform that integrates SAP data with cloud-native services from Microsoft, Nvidia, Databricks, AWS, and Google, and to enable the SAP BDC team to migrate and analyze enterprise SAP data.
Requirements
- 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, role-based access control (RBAC), and compliance in Snowflake.
- Knowledge of data modeling principles for enterprise data warehouses.
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 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.
Other
- BS/MS in Computer Science, Data Engineering, Information Systems, or a related field.
- 9+ years in data warehousing and cloud data platforms with 5+ years of hands-on Snowflake experience.
- Experience working on SAP migration or BDC data projects is preferred.
- Agile and DevOps experience with automation and pipeline deployment.
- Willingness to work in distributed teams and coordinate across time zones.
