Note: The job is a remote job and is open to candidates in USA. EY is a globally connected powerhouse of diverse teams, and they are seeking a Senior Data SAP Engineer. The role involves architecting, developing, and optimizing data warehouse and lakehouse solutions using the Snowflake platform and integrating it into SAP 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 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
Skills
- 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
- Excellent communication and collaboration skills to work with global SAP and data teams
- 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
- Certifications like SnowPro Core Certification or relevant cloud certifications are desirable
- Willingness to work in distributed teams and coordinate across time zones
Benefits
- Medical and dental coverage
- Pension and 401(k) plans
- A wide range of paid time off options
- Hybrid model with expectation to work together in person 40-60% of the time over the course of an engagement, project or year
- Flexible vacation policy
- Time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being
Company Overview
Company H1B Sponsorship