EY - GDS Consulting - AI and DATA - Snowflake DE - Senior

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

EY-Advisory - Data and Analytics – Snowflake Data Engineer - Senior

EY's Advisory Services is a unique, industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EY’s financial services practice provides integrated advisory services to financial institutions and other capital markets participants, including commercial banks, retail banks, investment banks, broker-dealers & asset management firms, and insurance firms from leading Fortune 500 Companies. Within EY’s Advisory Practice, Data and Analytics team solves big, complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses, now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of client’s decision-making.

The opportunity

We’re looking for a candidate with overall 3 – 7 years of experience and he/she should have strong expertise into cloud data engineering using Snowflake.

Key skills required for the role (Primary):

• Expertise in designing and implementing a fully operational solution on Snowflake Data Warehouse in Snowflake on AWS/Azure
• Monitoring health, tuning, and growth of such on-premises and cloud databases
• Experience in managing security and maintenance of snowflake databases
• Manage and monitor user access to the snowflake database
• Hands on exposure to ETL using Snowflake native services
• Hands on exposure to SQL & scripting
• Good understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
• Design and Develop ETL pipelines in and out of data warehouse using Snowflakes Snow SQL
• Deep understanding of relational as well as NoSQL data stores methods and approaches star and snowflake dimensional modelling
• Experience in designing and deploying virtual warehouse, schema, views, zero-copy clone in Snowflake cloud data warehouse
• Good to have experience working with AWS services like – Lambda, S3, DynamoDB, Glue, etc.
• Good to have experience working with Azure services like – Azure Functions, Blob, ADF, DevOps, etc.
• Good to have experience working with PL-SQL & ETL tools like Informatica or DataStage
• Strong Communication skills
• Work experience with banking clients is an added advantage
• Hands on experience with Mattilion, Python, DBT preffered
  
  

Your role:

• Perform business/data analysis to investigate various business problems and propose the solution working closely with clients and team
• Get involved in business development activities like creating proof of concepts (POCs), point of views (POVs)
• Interface and communicate with the onsite teams directly to understand the requirement and determine the optimum solutions
• Provide product and design level functional and technical expertise along with best practices
• Ability to think clearly, plan effectively, organize and develop action plans leading to resolving problems and achieving specific goals
  
  

Skills And Attributes For Success

• Strong communication, presentation and team building skills and experience in producing high quality deliverables.
  
  

What We Look For

• A Team of people with 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 1400 + professionals
• Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries
  
  

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
  
  

EY | Building a better working world

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.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

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