EY EY - GDS Consulting AI DATA Snowflake Manager 

India, Tamil Nadu, Chennai 

899968498

As part of our EY-DnA team, you will help clients in developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. Working with latest tools available in the market you will help clients by acquiring data from primary or secondary data sources and maintain databases/data systems and help to identify, analyse, and interpret trends or patterns in complex data sets.

Using your expertise in data analytics you will help our clients to view data in context and make smarter business decisions to achieve improved products and services.

Your key responsibilities

• Provide product and design level technical best practices
• Must have experience at least two end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on Oracle.
• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Must have expertise in AWS or Azure Platform as a Service (PAAS).
• Certified Snowflake cloud data warehouse Architect (Desirable).
• Should be able to troubleshoot problems across infrastructure, platform and application domains.
• Must have experience of Agile development methodologies
• Strong written communication skills. Is effective and persuasive in both written and oral communication

Skills and attributes for success

• Strong communication, presentation and team building.
• Strong analytical skills.
• Strong knowledge on data warehousing /data modelling best practices.
• Ability to translate the client requirement to a visual story
• Willingness to learn new skills

To qualify for the role, you must have

• BE/BTech/MCA/MBA with adequate industry experience
• Should be at least around 8-10 years of experience in Enterprise intelligence
• Strong SQL skills
• Experience in writing Stored Proc to handle Data transformation
• ETL/ Data Integration using Informatica or any standard tool,
• Good understanding DWH concepts, SQL and AWS cloud exposure ( S3/ EMR / Lambda/ Glue etc) would be good.
• Experience in using Data stage developer .
• Certification would be good to have.
• Experience using Clone, Time travel etc.

Ideally, you’ll also have

• Project management skills
• Familiar with Agile project delivery.
• Exposure to cloud technologies such as Azure, AWS is preferred.

What we look for

• A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
• An opportunity to be a part of market-leading, multi-disciplinary team of 550 + professionals, in the only integrated global advisory business worldwide.
• Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries

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

EY 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.