EY - GDS Consulting - AI And DATA - Snowflake Architect - Manager
at EY
Location:
Employment Type: full_time
Job Description
<p><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px">At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. </span></span></p><p> </p><p> </p><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>EY- GDS - Data and Analytics –Snowflake Architect Manager – Cloud</strong></span></p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.</span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>The opportunity</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">We’re looking for a candidate with 10+ years with strong architect expertise into Cloud Data Engineering Platforms and delivery lead</span></p><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Roles & Responsibilities</strong></span></p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Snowflake Security & Integration</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in configuring Snowflake Security integration services like OAuth, SAML.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Expertise in configuring Snowflake API, Storage, and Notification integration services.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong knowledge of Snowflake RBAC management, user management, and role management.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Data Masking & Access Control</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in configuring Dynamic Masking Policies and Tag-Based Masking Policies.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Database & Warehouse Management</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in creating and managing databases, schemas, and Snowflake warehouses.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Data Migration & ETL</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Expertise in migrating SQL queries/DDLs from Oracle, MySQL, MS SQL, Cassandra to Snowflake SQL.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in automating file loading from AWS S3/Azure Blob using Snowpipe and Snowflake ingestion best practices.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong background in transforming semi-structured data using Snowflake Stored Procedures.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in loading structured and semi-structured data into Snowflake from AWS S3/Azure Blob.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Data Pipelines & Frameworks</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in developing pipelines using a metadata-driven framework.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands-on experience in database design & data modeling using Erwin tool.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Data Governance & Validation</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Implemented data validation, error handling, auditing, and reconciliation mechanisms.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Performance Optimization & Reporting</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in optimizing Snowflake performance for efficient querying and storage.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Ability to generate reports (CSV, JSON, XML) using Snowflake tasks and streams and ETL tools.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Data Integration & Scheduling</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in integrating and scheduling end-to-end data ingestion, profiling, and transformation flows in Snowflake.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands-on experience with Snowflake Data Sharing (inbound and outbound).</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Advanced Snowflake Features</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in creating and managing External Tables, Iceberg Tables, Dynamic Tables, UDFs, UDTFs, and Procedures.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Implemented functionality for ServiceNow request generation in failure cases.</span></li></ul><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Cloud & Orchestration Tools</strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands-on experience with AWS (S3, SQS, SNS, EC2, RDS, IAM) and Azure (Blob Storage, IAM).</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in workflow orchestration using Apache Airflow.</span></li></ul><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Skills and attributes for success</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Use an issue-based approach to deliver growth, market, and portfolio strategy engagements for corporates</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint.</span></li></ul><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>To qualify for the role, you must have</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">BE/BTech/MCA with 10+ years of IT development experience</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Expertise on design, architecting, developing, and implementing data engineering solutions on any of the public cloud platform – Snowflake</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Hands on experience with Data Governance/Catalogue Tools such as EDC, IBM IGC, ASG, Alation, TMM etc</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Working knowledge on Data Governance Framework and compliance regulations such as BCBS, GDPR, HIPPA, ACCORD etc</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in producing Data Lineage Reports, Data Dictionaries, Business Glossary and Identifying the KBEs and CDE through Data Analysis</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">5+ years of experience on data lineage, data governance, data modelling, data integration solutions</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Strong exposure to real time data processing</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Should be able to handle customers on any situations</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Knowledge of Data Architecture, Data Modelling and adopting best practices and policies in the Data Management space</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience in databases, data warehousing and high-performance computing environments.</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Experience on Presales, RFP’s, customer presentations, etc.,</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Nice to have Insurance and Finance domain experience</span></li></ul><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>Ideally, you’ll also have</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Client management skills</span></li></ul><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>What we look for</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">People with technical experience and enthusiasm to learn new things in this fast-moving environment</span></li></ul><p> </p><p> </p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong>What working at EY offers</strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong> </strong></span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">At EY, we’re dedicated to helping our clients, from start-ups to Fortune 500 companies — and the work we do with them is as varied as they are.</span></p><p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:</span></p><p> </p><ul><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Support, coaching and feedback from some of the most engaging colleagues around</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Opportunities to develop new skills and progress your career</span></li><li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">The freedom and flexibility to handle your role in a way that’s right for you</span></li></ul><p> </p><p> </p><p><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"><b>EY | Building a better working world </b></span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. </span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. </span></span></p><p><br><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-size:11.0px"> <br>Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today. </span></span></p>