EY - GDS Consulting - AI And DATA - SSIS - Senior

At EY, we're all in to shape your future with confidence.

We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

ETL - SSIS Developer – Senior

The opportunity

We're looking for Senior Level Consultants with expertise in ETL - SSIS to join the EA group of our GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

This role demands a highly technical, extremely hands-on Data Warehouse Modelling consultant who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on different business needs. The ideal candidate must have a good understanding of the value of data warehouse and ETL and proven experience in delivering solutions to different lines of business and technical leadership.

Your Key Responsibilities

• Working with the client team, perform development and provide L3 support to database integrations and data warehouse using SQL Server, SSIS, Azure, 3rd party tools, etc.
• Good research, analysis, and problem-solving skills
• Ability to estimate work items in a systemic manner
• Strong understanding of Software Development Life Cycle (including agile development methodology)
• Hands on development and maintenance of the SQL based systems and various associated components for data ingestion, transformation, and processing.
• Hands on development and maintenance of integrations with various (including bespoke) Financial (Applications and Management Information Systems), Underwriting and Claims Management Systems and other systems based on business requirements.
• Ensure data quality and accuracy by implementing business and technical reconciliations via scripts, profiling and data analysis; analyse and create data mappings.
• Develop and support objects and code for data profiling, extraction, load and updates.
• Provide and maintain documentation for all developed objects and processes, in strict timelines.
• Integration testing of deliverables.
• Develop and run test scripts to ensure the quality of code and integrity.
• Use source code control repository (using VSTS, GIT) – preferred GIT
• Following data / integration design patterns and architecture as prescribed by the Architects. Come up with suggestions and recommendations where required

Skills And Attributes For Success

To qualify for the role, you must have

Ideally, you'll also have

What We Look For

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 :

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

Skills Required

Ssrs, Sql Server, Pl Sql, Ssis, Sql, Data Mapping, Git, Ssas, Oracle, Azure, Etl