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

At EY, we’re all in to shape your future with confidence.

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.

EY- GDS - Data and Analytics –Snowflake Architect Manager – Cloud

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.

The opportunity

We’re looking for a candidate with 10+ years with strong architect expertise into Cloud Data Engineering Platforms and delivery lead

Roles & Responsibilities

• Snowflake Security & Integration
• Experience in configuring Snowflake Security integration services like OAuth, SAML.
• Expertise in configuring Snowflake API, Storage, and Notification integration services.
• Strong knowledge of Snowflake RBAC management, user management, and role management.
• Data Masking & Access Control
• Experience in configuring Dynamic Masking Policies and Tag-Based Masking Policies.
• Database & Warehouse Management
• Experience in creating and managing databases, schemas, and Snowflake warehouses.
• Data Migration & ETL
• Expertise in migrating SQL queries/DDLs from Oracle, MySQL, MS SQL, Cassandra to Snowflake SQL.
• Experience in automating file loading from AWS S3/Azure Blob using Snowpipe and Snowflake ingestion best practices.
• Strong background in transforming semi-structured data using Snowflake Stored Procedures.
• Experience in loading structured and semi-structured data into Snowflake from AWS S3/Azure Blob.
• Data Pipelines & Frameworks
• Experience in developing pipelines using a metadata-driven framework.
• Hands-on experience in database design & data modeling using Erwin tool.
• Data Governance & Validation
• Implemented data validation, error handling, auditing, and reconciliation mechanisms.
• Performance Optimization & Reporting
• Experience in optimizing Snowflake performance for efficient querying and storage.
• Ability to generate reports (CSV, JSON, XML) using Snowflake tasks and streams and ETL tools.
• Data Integration & Scheduling
• Experience in integrating and scheduling end-to-end data ingestion, profiling, and transformation flows in Snowflake.
• Hands-on experience with Snowflake Data Sharing (inbound and outbound).
• Advanced Snowflake Features
• Experience in creating and managing External Tables, Iceberg Tables, Dynamic Tables, UDFs, UDTFs, and Procedures.
• Implemented functionality for ServiceNow request generation in failure cases.
• Cloud & Orchestration Tools
• Hands-on experience with AWS (S3, SQS, SNS, EC2, RDS, IAM) and Azure (Blob Storage, IAM).
• Experience in workflow orchestration using Apache Airflow.

Skills and attributes for success

• Use an issue-based approach to deliver growth, market, and portfolio strategy engagements for corporates
• Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.
• Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint.

To qualify for the role, you must have

• BE/BTech/MCA with 10+ years of IT development experience
• Expertise on design, architecting, developing, and implementing data engineering solutions on any of the public cloud platform – Snowflake
• Hands on experience with Data Governance/Catalogue Tools such as EDC, IBM IGC, ASG, Alation, TMM etc
• Working knowledge on Data Governance Framework and compliance regulations such as BCBS, GDPR, HIPPA, ACCORD etc
• Experience in producing Data Lineage Reports, Data Dictionaries, Business Glossary and Identifying the KBEs and CDE through Data Analysis
• 5+ years of experience on data lineage, data governance, data modelling, data integration solutions
• Strong exposure to real time data processing
• Should be able to handle customers on any situations
• Knowledge of Data Architecture, Data Modelling and adopting best practices and policies in the Data Management space
• Experience in databases, data warehousing and high-performance computing environments.
• Experience on Presales, RFP’s, customer presentations, etc.,
• Nice to have Insurance and Finance domain experience

Ideally, you’ll also have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

What working at EY offers

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.

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:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you