EY-Advisory - Data and Analytics Snowflake Data Engineer
    EYs 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 9 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.  
 
  
   -   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