EY GDS Consulting is seeking a Senior Snowflake Administrator / Data Engineer to enhance enterprise data platforms. This role blends platform administration and development, focusing on Snowflake administration, security, governance, performance, and operational support. The ideal candidate will also contribute to data engineering, including data ingestion, ETL/ELT development, pipeline automation, and modernizing cloud data platforms.

Join EY to build a unique career leveraging global scale and inclusive culture. We aim to build a better working world, creating long-term value for clients, people, and society. Enabled by data and technology, EY teams in over 150 countries provide trust through assurance and help clients grow and transform.

Administer and maintain Snowflake environments across all stages (Dev, QA, UAT, Prod). Manage users, roles, warehouses, databases, and access controls using RBAC. Monitor Snowflake performance, resource consumption, and query execution. Configure and manage security controls, including masking, row-level security, and network policies. Troubleshoot issues, perform root cause analysis, and implement solutions. Ensure data governance, retention, Time Travel, Fail-safe, and cloning strategies are in place. Support capacity planning, cost optimization, and warehouse sizing. Manage environment migrations and deployments. Support audit, compliance, and data security requirements.

Design and develop scalable ETL/ELT pipelines. Implement data ingestion using Snowpipe, Streams, Tasks, and Dynamic Tables. Build and optimize data transformations using SQL and Python. Support ingestion of various data formats. Create reusable data models, views, and stored procedures. Collaborate with stakeholders for solution delivery. Support CI/CD and automation. Participate in production support and operational excellence.

Requires 5-7 years of experience in Snowflake Administration and Data Engineering. Expertise in Snowflake Warehouses, Databases, Schemas, User & Role Management, RBAC, Snowpipe, Streams & Tasks, Dynamic Tables, Time Travel & Fail-safe, Data Sharing, Cloning, Performance Tuning, Cost Optimization, Monitoring & Governance. Strong SQL and Python skills are essential, along with experience in building enterprise-grade ETL/ELT pipelines and dimensional modeling. Understanding of structured and semi-structured data formats (CSV, JSON, Parquet, XML) is necessary.

Experience with cloud platforms like AWS (S3, IAM, Glue, Lambda, EC2) or Azure (ADLS, ADF, Azure Functions, Databricks). Familiarity with DevOps tools such as Git/GitHub/Azure DevOps, CI/CD pipelines, and infrastructure automation concepts. Experience with Agile delivery methodologies is expected. Preferred skills include SnowPro Core Certification, Databricks, PySpark, AWS Glue or Azure Data Factory, and knowledge of data governance frameworks. Soft skills include strong analytical and problem-solving abilities, excellent communication, stakeholder management, and the capacity to work independently in a fast-paced environment.