TTT - Data Engineering - Senior
Ernst and Young10 days ago
Hyderābād, IndiaSenior
Responsibilities
- Design, develop, and implement data solutions, data warehouses, and data lakes using Snowflake.
- Implement data ingestion and integration solutions with Snowflake, Snowpipe, Streams, Tasks, Azure Data Factory, SSIS, or other ETL tools.
- Design and develop ETL workflows and automation for Snowflake and related data platforms.
- Develop complex SQL queries, stored procedures, views, triggers, cursors, and user-defined functions using SQL Server and Azure SQL.
- Develop, maintain, and optimize databases, stored procedures, ETL packages, and other data-layer components.
- Apply data modeling and data warehouse concepts, including Star, Snowflake, and Data Vault schemas.
- Analyze Snowflake queries using Query Profile and understand cache architecture and compute-storage separation.
- Collaborate with application developers, project managers, senior IT leaders, clients, and tax subject matter experts to define data solutions and address system changes.
- Support solution architecture, application development, testing, and maintenance for EY’s global Tax service line.
- Communicate program strategies and negotiate quality data solutions with IT stakeholders.
Requirements
- At least 5 years of combined experience with Snowflake, Azure SQL, or SQL Server, including database development, database design, and data modeling.
- Hands-on experience designing, developing, and implementing Snowflake data solutions, warehouses, or data lakes.
- Experience with Snowpipe, Azure Data Factory, SSIS, or other ETL tools.
- Strong database programming and backend development experience with complex SQL queries and database objects.
- Strong knowledge of data modeling and data warehouse concepts.
- Experience with Azure data platform offerings.
- Familiarity with Python for automation and scripting.
- Knowledge of CI/CD pipelines.
- Strong verbal and written communication skills.
- Ability to work independently as an individual contributor.
- Exposure to Power BI is preferred but not mandatory.
Tech Stack
Categories
Data Engineering
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.