Senior Data SAP Engineer
EY · Boston, MA · 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 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 and a wide range of paid time off options.
- 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.