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) – SSIS Developer - Staff

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

• Minimum of 1 to 3 years of industry experience in SSIS
• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems.
• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
• Design, implement and maintain database objects (tables, views, indexes, ) and database security
• Experience working with SSIS packages
• Analyse and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
• Test and prepare ETL processes for deployment to production and non-production environments.

To qualify for the role, you must have

• 1 - 3 Years of hands-on Experience in SSIS development, with a focus on SSIS and SQL.
• Strong understanding of Data Warehouse & ETL principles and practical experience.
• Understanding of SSIS packages
• Experience working on Cloud Environment
• Proficiency in SQL tuning, data analysis, and data profiling techniques.
• Experience with Python coding for automation tasks.
• Ability to learn new technologies quickly and adapt to a fast-paced development environment.
• Excellent problem-solving skills and logical thought process.
• Ability to work independently and collaborate effectively in a team environment.
• Strong communication skills, both verbal and written

Primary Skills:

• SSIS
• SQL 
• ETL

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.

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.