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

pspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongEY- GDS - Data and Analytics –Snowflake Architect Manager – Cloud/strong/span/pp /ppspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongThe opportunity/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongRoles amp; Responsibilities/strong/span/pp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongSnowflake Security amp; Integration/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in configuring Snowflake Security integration services like OAuth, SAML./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExpertise in configuring Snowflake API, Storage, and Notification integration services./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Masking amp; Access Control/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongDatabase amp; Warehouse Management/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in creating and managing databases, schemas, and Snowflake warehouses./span/li/ulp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Migration amp; ETL/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong background in transforming semi-structured data using Snowflake Stored Procedures./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Pipelines amp; Frameworks/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in developing pipelines using a metadata-driven framework./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Governance amp; Validation/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptImplemented data validation, error handling, auditing, and reconciliation mechanisms./span/li/ulp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongPerformance Optimization amp; Reporting/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in optimizing Snowflake performance for efficient querying and storage./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongData Integration amp; Scheduling/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHands-on experience with Snowflake Data Sharing (inbound and outbound)./span/li/ulp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongAdvanced Snowflake Features/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptImplemented functionality for ServiceNow request generation in failure cases./span/li/ulp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongCloud amp; Orchestration Tools/strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in workflow orchestration using Apache Airflow./span/li/ulp /pp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongSkills and attributes for success/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif; an issue-based approach to deliver growth, market, and portfolio strategy engagements for corporates/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongTo qualify for the role, you must have/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif; with 10+ years of IT development experience/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif; years of experience on data lineage, data governance, data modelling, data integration solutions/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong exposure to real time data processing/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptShould be able to handle customers on any situations/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in databases, data warehousing and high-performance computing environments./span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience on Presales, RFP’s, customer presentations, etc.,/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptNice to have Insurance and Finance domain experience/span/li/ulpspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongIdeally, you’ll also have/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptClient management skills/span/li/ulp /pp /ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongWhat we look for/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongWhat working at EY offers/strong/span/ppspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan no-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 no-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 no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptSupport, coaching and feedback from some of the most engaging colleagues around/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptOpportunities to develop new skills and progress your career/span/lili no-style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan no-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 no-style=font-family:Arial, Helvetica, sans-serifspan | Building a better working world /b/span/span/ppbrspan no-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 no-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 no-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