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

To qualify for the role, you must have

Ideally, you'll also have

What We Look For

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 :

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

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.

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.

Skills Required

Performance Optimization, Data Modeling, Data Integration, Apache Airflow, Data Migration, snowflake , Data Governance, Azure, data masking , Etl, Aws