Sr.consultant

Sr. Snowflake Consultant
No. of Positions: Sr. Snowflake Consultants –5
EY GDS – Data and Analytics (D&A) – 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 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 DW
ETL 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
Primary:
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.
Good knowledge in any of Cloud storage AWS S3, Azure Blob
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.
Secondary:
Data Ingress, Egress, Querying using Kafka, Ni Fi
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 & No SQL 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 Dev Ops and containerization. Preferable – having deployment knowledge
To qualify for the role, you must have
Be a computer science graduate or equivalent with 12 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.

---