TTT - Data Engineering - Senior
Ernst and Young6 days ago
Bengaluru, IndiaSenior
Responsibilities
- Design, develop, and implement data warehouse and data lake solutions using Snowflake.
- Implement data integration and ingestion solutions using Snowflake, Snowpipe, Streams, Tasks, Azure Data Factory, or other ETL tools.
- Design and develop ETL workflows and optimize Snowflake queries using Query Profile and cache architecture.
- Develop and maintain databases, stored procedures, ETL packages, SQL queries, views, triggers, cursors, and user-defined functions.
- Apply data modeling and data warehouse concepts, including Star, Snowflake schema, and Data Vault models.
- Develop, maintain, and optimize data-layer components for new and existing systems.
- Work with application developers to address core-system changes and their effects on SQL databases.
- Define data solutions for business problems with project managers, senior colleagues, and clients.
- Communicate and negotiate quality solutions with senior IT leaders regarding program strategies and plans.
- Support CI/CD pipelines and use Python for automation and scripting.
Requirements
- 5+ years of combined experience with Snowflake, Azure SQL, or SQL Server, including database building, database design, and data modeling.
- Hands-on experience designing, developing, and implementing data solutions, data warehouses, and data lakes using Snowflake.
- Strong database programming and backend development experience with SQL Server or Azure SQL, including complex queries and database objects.
- Experience with Snowpipe, Azure Data Factory, SSIS, or another ETL tool.
- Knowledge of Snowflake architecture, including compute-storage separation, virtual warehouses, query profiling, and caching.
- Knowledge of data modeling, data warehouse concepts, and Star, Snowflake schema, and Data Vault models.
- Familiarity with Python for automation and scripting.
- Strong verbal and written communication skills and the ability to work 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.