EY-GDS Consulting-AI And DATA-ETL Developer-Staff

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 And A) – ETL 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 are looking for an experienced ETL professional with strong hands-on expertise in SSIS, Azure cloud data services, and Guidewire ClaimCenter migration. This is an excellent opportunity to join a leading organization and contribute to a growing Data & Analytics team. The ideal candidate will bring strong technical skills, end-to-end delivery experience, and the ability to work in a high-impact, fast-paced environment.

Job Description: ETL Developer

We are seeking a skilled Staff ETL Developer with deep knowledge of SSIS, Azure cloud data platforms, and Guidewire ClaimCenter migration processes. The ideal candidate will be responsible for designing, developing, and optimizing ETL workflows, ensuring data quality, and enabling seamless migration and integration across enterprise systems. This role requires a strong analytical mindset, attention to detail, and the ability to collaborate with cross-functional teams. 

Key Responsibilities:

• Overall experience must 1 - 3 years.
• Design, develop, and maintain SSIS packages, data pipelines, and ETL workflows to support business and system integration requirements.
• Lead and execute data migration initiatives, especially migrations involving Guidewire ClaimCenter, including mapping, transformation, validation, and reconciliation.
• Work with business analysts and domain teams to translate requirements into scalable and maintainable ETL solutions.
• Implement data extraction, transformation, and loading strategies for complex datasets across on-prem and cloud platforms.
• Develop and optimize Azure-based data solutions, including Azure Data Factory (ADF), Azure SQL Database, Azure Storage, and related services.
• Perform data profiling, quality checks, reconciliation, and root-cause analysis to ensure accuracy and completeness of migrated or transformed data.
• Troubleshoot ETL performance issues, optimize workflows, and ensure best practices for scalability and maintainability.
• Collaborate with architects and cloud engineering teams to ensure solution alignment with enterprise standards.
• Maintain documentation, version control, deployment scripts, and ETL operational procedures.
• Stay updated with emerging Azure data engineering capabilities, ETL tools, and industry best practices.
• Experience with JIRA, Git, and Agile methodologies is preferred.

What we look for

• Strong technical expertise in SSIS, ETL development, and SQL programming.
• Hands-on experience delivering Azure cloud-based data pipelines.
• Proven experience in Guidewire ClaimCenter data migration or integration projects.
• Strong analytical, problem-solving, and communication skills.
• Ability to lead development tasks, mentor junior team members, and deliver complex solutions with minimal supervision.
• Enthusiasm to learn new technologies and adapt in a rapidly evolving data landscape.

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.