Join EY's GDS Tax Technology team as a Senior Data Engineer and contribute to developing innovative technology solutions that empower our clients and engagement teams. You'll gain deep expertise in tax technology, database management, data analytics, and programming.

In today's regulatory landscape, tax departments face the challenge of managing vast amounts of data from diverse sources. EY's GDS Tax Technology team collaborates closely with clients and subject matter experts to build cutting-edge technology solutions that drive efficiency and deliver significant value.

We work across various tax domains, including Federal Business Tax Services, Partnership and Corporate Compliance, Indirect Tax Services, Human Capital, and Internal Tax Services. Our team provides comprehensive support in solution architecture, application development, testing, and maintenance for the global TAX service line.

Design, develop, and implement robust data solutions, including data warehouses and data lakes, with a primary focus on Snowflake architecture. Analyze query performance using Query Profile and understand cache mechanisms.

Implement data integration strategies using Snowflake, facilitating data ingestion from multiple sources. Leverage experience with Streams, Tasks, Snowpipe, Azure Data Factory, or similar ETL tools for automated data ingestion and workflow management.

Develop and optimize complex SQL queries, stored procedures, views, and triggers for SQL Server/Azure SQL. Demonstrate strong knowledge of data modeling principles and data warehousing concepts.

Build and maintain all data layer components, including databases, stored procedures, ETL packages, and SQL queries for both new and existing systems. Gain experience with Azure data platform offerings and collaborate with application developers to manage system changes impacting SQL databases.

Define data solutions tailored to business needs by engaging directly with project managers, senior stakeholders, and clients. Effectively communicate program strategies and negotiate solutions with IT leadership. Possess experience in various data modeling techniques like Star schema, Snowflake schema, and Data Vault, and understand CI/CD pipeline principles.

A Bachelor's degree is required for this role.

We are seeking candidates with strong verbal and written communication skills, capable of working effectively as an individual contributor. A minimum of 5 years of combined experience is essential, encompassing Snowflake, Azure SQL/SQL Server, database construction, design, and data modeling.

Proficiency in Snowpipe, Azure Data Factory, SSIS, or other ETL tools is a key requirement. Familiarity with Python for automation and scripting is also necessary.

While not mandatory, exposure to visual analytics tools such as Power BI is considered a valuable asset.