Your key responsibilities
- Design, Develop & deploy Snowflake CDW in a cloud environment on AWS or Azure
- Source System Analysis, Data Modelling, ETL development, and deployment to Cloud Service
- Interact with stakeholders, understand their business goals, contribute to the delivery of the workstreams
- Contribute towards EY Snowflake competency building initiatives outside your project responsibilities.
- Experience in Architecting and leading Data Strategy, Data platform build out, Enterprise wider Data & Analytics solutions on Snowflake.
- Manage program work and resources to enable successful and timely completion of the project.
- Delivery of program aligned to overall business and technology strategies and architecture.
Skills and attributes for success
- 10 to 12 years of Hands-on experience in the field of data warehousing, ETL
- Hands on development experience in developing solutions in Snowflake.
- Experience in Snowflake modelling - roles, schema, databases.
- Experience in Integrating with third-party tools, ETL, DBT
- Experience in Snowflake advanced concepts like setting up resource monitors and performance tuning
- Strong programming knowledge in SQL
- Applying object-oriented and functional programming styles to real-world problems using Scala/Python
- Strong knowledge in implementing Snowflake core features such as Cloning, Sharing, Streams, Tasks and Pipes.
- Develop data pipelines to perform batch and Real - Time/Stream analytics on structured and unstructured data.
- Functional understanding of Azure and/or AWS landscape
- Good understanding of different file format (ORC, Parquet, AVRO) to optimize queries/processing and compression techniques
- Familiar with DevOps. Preferable – having deployment knowledge.
- Willingness to pickup new technologies as and when needed.
To qualify for the role, you must have
- Exposure to other cloud technologies other than Snowflake such as AWS/Azure/Databricks
- Be a computer science graduate or equivalent with 10 to 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.
- Good analytical skills and enjoys solving complex technical problems
- Proficiency in Software Development Best Practices
- Good debugging and optimization skills
- Good communicator (written and verbal formal and informal).
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.