About this role
<div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">At EY, we’re all in to shape your future with confidence. </span></p> <p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.</span></p> </div> <div> </div><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>The opportunity </strong><br></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br>As a Snowflake Subject Matter Expert (SME) you will be responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using the Snowflake platform and integrating into SAP BDC.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br>Your expertise will be crucial in enabling 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.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br>You will collaborate closely 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.</span></p> <p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Your key responsibilities </strong></span></p> <p> </p> <ul> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Design and implement Snowflake data warehouse and lakehouse architectures aligned with SAP data migration strategies.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Develop and optimize Snowflake SQL queries, stored procedures, and data transformation logic to support SAP workloads.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Manage Snowflake account configurations, resource monitors, virtual warehouses, and access controls.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Integrate Snowflake into SAP BDC, SAP Databricks and Databricks<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Integrate Snowflake with SAP data sources and other data platform components, including Databricks, Azure Data Factory, and cloud storage.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Implement best practices for data partitioning, clustering, and caching to optimize performance and cost-efficiency.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Participate in data ingestion automation, metadata management, and monitoring within Snowflake environments.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Collaborate with security teams to enforce data governance, encryption, and compliance policies in Snowflake.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Support CI/CD and automation of Snowflake deployment and pipeline orchestration.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Provide knowledge transfer and technical guidance to team members and clients.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Stay updated on Snowflake innovations and new features relevant to SAP data platforms.<br></span></li> </ul> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br><strong>Skills and attributes for success </strong><br></span></p> <p> </p> <ul> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Deep expertise in Snowflake data warehouse platform, including performance tuning and cost optimization.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong SQL skills and experience with Snowflake-specific features such as Time Travel, Zero Copy Cloning, Streams, and Tasks.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience with integration into SAP BTP, BDC and Hana DB<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Familiarity with SAP data types, structures, and migration tools for seamless integration with Snowflake.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience with cloud ecosystems (Azure, AWS, GCP) and data orchestration tools (ADF, Airflow).<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Understanding of data security, role-based access control (RBAC), and compliance in Snowflake.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of data modeling principles for enterprise data warehouses.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Excellent communication and collaboration skills to work with global SAP and data teams.<br></span></li> </ul> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br><strong>Other Requirements:</strong></span></p> <p> </p> <ul> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience working on SAP migration or BDC data projects is preferred.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Agile and DevOps experience with automation and pipeline deployment.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Certifications like SnowPro Core Certification or relevant cloud certifications are desirable.<br></span></li> <li style="font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Willingness to work in distributed teams and coordinate across time zones.<br></span></li> </ul> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br><strong>Job Requirements:</strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br><strong>Education:</strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br>BS/MS in Computer Science, Data Engineering, Information Systems, or a related field.</span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br><strong>Experience:</strong></span></p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><br>9+ years in data warehousing and cloud data platforms with 5+ years of hands-on Snowflake experience.</span></p><div> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><strong>What we offer you</strong></span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">The compensation ranges below are provided in order to comply with United States pay transparency laws. Other geographies will follow their local salary guidelines, which may not be a direct conversion of published US salary ranges. </span><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn <a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ey.com%2Fen_gl%2Fcareers&data=05%7C02%7Cdeborah.compagner%40ey.com%7C41999b589ae04d7f6b8a08dd04d62e9a%7C5b973f9977df4bebb27daa0c70b8482c%7C0%7C0%7C638672040144488329%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=Mb96MEoh9R3oQ1cGLr73tEDtKTSUYCyfOhCZ%2BmMHY9w%3D&reserved=0">more</a>.</span></p> <ul> <li style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $87,200 to $163,000. The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $104,600 to $185,300 . Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.</span></li> <li style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Join us in our team-led and leader-enabled hybrid model. Our expectation is 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.</span></li> <li style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted 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.</span></li> </ul> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><strong>Are you ready to shape your future with confidence? Apply today. </strong></span><br><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY accepts applications for this position on an on-going basis.<strong> </strong></span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">For those living in California, please click <a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ey.com%2Fen_us%2Flegal-and-privacy%2Ffair-chance-ordinance&data=05%7C02%7CKatie.Fusco%40ey.com%7Ca854c911111641604b1908dcbae61395%7C5b973f9977df4bebb27daa0c70b8482c%7C0%7C0%7C638590744554256267%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=OMroKPwn6YEFe32dLGrEivljaobbnMbqSwp4tFRvnfc%3D&reserved=0">here</a> for additional information.</span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.</span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><strong>EY | Building a better working world</strong></span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.</span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.</span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.</span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law. </span></p> <p> </p> <p><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at <a href="mailto:[email protected]">[email protected]</a>.</span></p> </div>