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 Data Engineer

We’re looking for candidates with strong technology and data understanding in data engineering space. The ideal candidate will be responsible for designing, developing, and maintaining data integration solutions using SQL Server Integration Services (SSIS) to support our business intelligence and data warehousing initiatives. 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

• Design and develop ETL processes using SSIS to extract data from various sources, transform the data according to business rules, and load it into the data warehouse.
• Work with business analysts and other stakeholders to understand data requirements and translate them into technical specifications.
• Implement data cleansing, deduplication, and data quality checks to ensure the accuracy and integrity of data.
• Source System Analysis, Data Modelling, ETL development, and deployment.
• Develop and maintain documentation for ETL processes, data models, and data flow diagrams.
• Troubleshoot and resolve issues related to data integration and data quality.
• Assist in the deployment of SSIS packages to production environments and provide post-deployment support.
• Contribute towards EY ETL competency building initiatives outside your project responsibilities.

Skills and attributes for success

• Minimum of 3 years of experience in data engineering with a focus on ETL development using SSIS.
• Strong understanding of relational databases and SQL, preferably with Microsoft SQL Server.
• Experience with data modelling, data warehousing, and working with large datasets.
• Proficiency in writing complex SQL queries and stored procedures.
• Ability to work independently and as part of a team in a fast-paced environment.
• Familiar with DevOps. Preferable – having deployment knowledge.
• Willingness to pickup new technologies as and when needed.

To qualify for the role, you must have

• Be a computer science graduate or equivalent with more than 5 years of industry experience.
• Experience with other ETL tools such as Informatica, Talend, or Azure Data Factory.
• Experience with reporting and visualization tools such as Power BI, Tableau, or SSRS.
• Certifications related to Microsoft SQL Server or data engineering.
• Have working experience in an Agile base delivery methodology (Preferable)
• Development experience in Snowflake (nice to have)
• 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).
• Knowledge of cloud platforms like Azure, AWS, or Google Cloud (Preferable)

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.