EY - GDS Consulting - AI And DATA - Snowflake Architect - Manager

pspan style=font-family:Arial, Helvetica, sans-serifspan 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/pp /pp /pp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongEY- GDS - Data and Analytics –Snowflake Architect Manager – Cloud/strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif; part of our EY-GDS Damp;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/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongThe opportunity/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;’re looking for a candidate with 10+ years with strong architect expertise into Cloud Data Engineering Platforms and delivery lead/span/pp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongRoles amp; Responsibilities/strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongSnowflake Security amp; Integration/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in configuring Snowflake Security integration services like OAuth, SAML./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExpertise in configuring Snowflake API, Storage, and Notification integration services./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong knowledge of Snowflake RBAC management, user management, and role management./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Masking amp; Access Control/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in configuring Dynamic Masking Policies and Tag-Based Masking Policies./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongDatabase amp; Warehouse Management/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in creating and managing databases, schemas, and Snowflake warehouses./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Migration amp; ETL/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExpertise in migrating SQL queries/DDLs from Oracle, MySQL, MS SQL, Cassandra to Snowflake SQL./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in automating file loading from AWS S3/Azure Blob using Snowpipe and Snowflake ingestion best practices./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong background in transforming semi-structured data using Snowflake Stored Procedures./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in loading structured and semi-structured data into Snowflake from AWS S3/Azure Blob./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Pipelines amp; Frameworks/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in developing pipelines using a metadata-driven framework./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands-on experience in database design amp; data modeling using Erwin tool./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Governance amp; Validation/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptImplemented data validation, error handling, auditing, and reconciliation mechanisms./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongPerformance Optimization amp; Reporting/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in optimizing Snowflake performance for efficient querying and storage./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAbility to generate reports (CSV, JSON, XML) using Snowflake tasks and streams and ETL tools./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Integration amp; Scheduling/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in integrating and scheduling end-to-end data ingestion, profiling, and transformation flows in Snowflake./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands-on experience with Snowflake Data Sharing (inbound and outbound)./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongAdvanced Snowflake Features/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in creating and managing External Tables, Iceberg Tables, Dynamic Tables, UDFs, UDTFs, and Procedures./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptImplemented functionality for ServiceNow request generation in failure cases./span/li/ulp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongCloud amp; Orchestration Tools/strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands-on experience with AWS (S3, SQS, SNS, EC2, RDS, IAM) and Azure (Blob Storage, IAM)./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in workflow orchestration using Apache Airflow./span/li/ulp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongSkills and attributes for success/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif; an issue-based approach to deliver growth, market, and portfolio strategy engagements for corporates/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint./span/li/ulp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongTo qualify for the role, you must have/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif; with 10+ years of IT development experience/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExpertise on design, architecting, developing, and implementing data engineering solutions on any of the public cloud platform – Snowflake/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands on experience with Data Governance/Catalogue Tools such as EDC, IBM IGC, ASG, Alation, TMM etc/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptWorking knowledge on Data Governance Framework and compliance regulations such as BCBS, GDPR, HIPPA, ACCORD etc/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in producing Data Lineage Reports, Data Dictionaries, Business Glossary and Identifying the KBEs and CDE through Data Analysis/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif; years of experience on data lineage, data governance, data modelling, data integration solutions/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong exposure to real time data processing/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptShould be able to handle customers on any situations/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptKnowledge of Data Architecture, Data Modelling and adopting best practices and policies in the Data Management space/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in databases, data warehousing and high-performance computing environments./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience on Presales, RFP’s, customer presentations, etc.,/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptNice to have Insurance and Finance domain experience/span/li/ulpspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongIdeally, you’ll also have/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptClient management skills/span/li/ulp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongWhat we look for/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPeople with technical experience and enthusiasm to learn new things in this fast-moving environment/span/li/ulp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongWhat working at EY offers/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif; 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/ppspan style=font-family:arial, helvetica, sans-serif; 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/pp /pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptSupport, coaching and feedback from some of the most engaging colleagues around/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptOpportunities to develop new skills and progress your career/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif; freedom and flexibility to handle your role in a way that’s right for you/span/li/ulp /pp /ppspan style=font-family:Arial, Helvetica, sans-serifspan | Building a better working world /b/span/span/ppbrspan style=font-family:Arial, Helvetica, sans-serifspan  brEY 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/ppbrspan style=font-family:Arial, Helvetica, sans-serifspan  brEnabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. /span/span/ppbrspan style=font-family:Arial, Helvetica, sans-serifspan  brWorking 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