GDS Consulting_D&A Snowflake Data Engineer - Senior
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.
We’re looking for candidates with strong technology and data understanding in 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 snowflake DW in a cloud environment on AWS or Azure
- Source System Analysis, Data Modelling, ETL development, and deployment to Cloud Service
- Interact with Onshore, understand their business goals, contribute to the delivery of the workstreams
- Contribute towards EY Snowflake competency building initiatives outside your project.
Skills and attributes for success
- 3 to 7 years of Hands-on experience 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
- 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.
- Basic understanding of AWS S3, Lambda, EMR, Glue
- Good understanding of different file format (ORC, Parquet, AVRO) to optimize queries/processing and compression techniques
- Familiar with DevOps. Preferable – having deployment knowledge
To qualify for the role, you must have
- Be a computer science graduate or equivalent with 3 to 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.
- 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 | 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.