Senior AI and Data Consultant - Snowflake

Senior AI and Data Consultant - Snowflake at EY

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 GDS – Data and Analytics (D&A) – Senior AI and Data Consultant - Snowflake

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 candidates with strong technology and data understanding in the big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your Key Responsibilities

• Develop & deploy big data pipelines in a cloud environment using Snowflake cloud DWETL.
• Design, development and migration of existing on-prem ETL routines to Cloud Service.
• Interact with senior leaders, understand their business goals, contribute to the delivery of the workstreams.
• Design and optimize model codes for faster execution.

Skills And Attributes For Success

• Hands on developer in the field of data warehousing, ETL.
• Hands on development experience in Snowflake.
• Experience in Snowflake modelling - roles, schema, databases.
• Experience in Integrating with third-party tools, ETL, DBT tools.
• Experience in Snowflake advanced concepts like setting up resource monitors and performance tuning would be preferable.
• Applying object-oriented and functional programming styles to real-world Big Data Engineering problems using Java/Scala/Python.
• Develop data pipelines to perform batch and Real - Time/Stream analytics on structured and unstructured data.
• Data Ingress, Egress, Querying using Kafka, NiFi.
• Deep understanding of AWS S3, Lambda, EMR, Glue.
• Data processing patterns, distributed computing and in building applications for real-time and batch analytics.
• Handling large data sets and perform data wrangling, analysis, etc., using various SQL & NoSQL database technologies, and programming languages such as Java/Scala/Python.
• Good understanding of different file format (ORC, Parquet, AVRO) to optimize queries/processing and compression techniques.
• Have knowledge and skills in DevOps and containerization. Preferable – having deployment knowledge.

To qualify for the role, you must have

• Be a computer science graduate or equivalent with 3-7 years of industry experience.
• Have working experience in an Agile base delivery methodology (Preferable).
• Flexible and proactive/self-motivated working style with strong personal ownership of problem resolution.
• Excellent communicator (written and verbal formal and informal).
• Participate in all aspects of Big Data solution delivery life cycle including analysis, design, development, testing, production deployment, and support.

Ideally, you’ll also have

• Client management skills.

What We Look For

People with technical experience and enthusiasm to learn new things in this fast-moving environment.

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.

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

Key skills/competency

• Snowflake Development
• Big Data Engineering
• ETL & DWETL
• AWS Cloud Services
• Python/Java/Scala
• Data Pipelines
• Kafka/NiFi
• DevOps
• Data Modeling
• Performance Tuning