HoneyBook
Senior Data Engineer – SQL & Informatica
Job Description
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.
The opportunity
As part of our EY-DnA team, you will help clients in developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. Working with latest tools available in the market you will help clients by acquiring data from primary or secondary data sources and maintain databases/data systems and help to identify, analyse, and interpret trends or patterns in complex data sets.
Using your expertise in data analytics you will help our clients to view data in context and make smarter business decisions to achieve improved products and services.
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 role and responsibilities
- Hands on role on data models, data storage, cleansing, validation integration and transformation and data migration to manage data within the organization, for a small to medium-sized project
- Responsible to building pipeline, perform data profiling, implement data quality rules
- Need to work as a team member to contribute in various technical streams of project implementation
- Interface and communicate with the onsite coordinators
- Completion of assigned tasks on time and regular status reporting to the lead
Skills and attributes for success
- In-depth cloud domain experience with focus on Microsoft Azure / Microsoft Azure Stack solutions
- Experience building on Azure using Databricks, ADF
- Good to have Synapse experience
- Sound programming, debugging/troubleshooting and problem-solving skills with familiarity in Scala/ Java / Python on Spark/ Pyspark
- Strong knowledge in Pyspark/ Spark SQL
- Strong data warehousing concepts
- Good analytical skills
- 3+ years of work experience with very large data warehousing environment
- 3+ years of experience with detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools.
- Specialization in a specific sector/domain will be an added advantage
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.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role
with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:
- 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.