Sr TTT - Data Engineering - Professional

Role overview

EY's GDS Tax Technology team's mission is to develop, implement and integrate technology solutions that better serve our clients and engagement teams. As a member of EY's core Tax practice, you'll develop a deep tax technical knowledge and outstanding database, data analytics and programming skills. EY's GDS Tax Technology team members work side-by-side with the firm's partners, clients and tax technical subject matter experts to develop and incorporate technology solutions that enhance value-add, improve efficiencies and enable our clients with disruptive and market leading tools supporting Tax. GDS Tax Technology works closely with clients and professionals in the following areas: Federal Business Tax Services, Partnership Compliance, Corporate Compliance, Indirect Tax Services, Human Capital, and Internal Tax Services. GDS Tax Technology provides solution architecture, application development, testing and maintenance support to the global TAX service line both on a pro-active basis and in response to specific requests.

Key Responsibilities

• Hands-on experience in designing, developing, and implementing data solutions, data warehouse/data Lake using Snowflake
• Has good knowledge on Snowflake Architecture (compute-storage separation, virtual warehouses)
• Analyzing Queries Using Query Profile, Cache architecture
• Implement data integration solutions using Snowflake, including data ingestion from various sources.
• Experience on Streams, Tasks, Snow pipe Azure Data Factory or any other ETL for data ingestion automation
• Design and Develop ETL workflows for Snowflake, Experience using different ETL Solutions.
• Strong database programming/ backend development experience using SQL Server/Azure SQL, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Strong knowledge in data modeling and Datawarehouse concepts.
• Develops, maintains, and optimizes all data layer components for new and existing systems, including databases, stored procedures, ETL packages, and SQL queries
• Experience on Azure data platform offerings.
• Interacts with application developers from various core systems to address changes in those systems and their impact on existing SQL databases
• Defines data solutions for business problems by working directly with project managers, seniors and clients
• Ability to effectively communicate with other senior leaders of IT on program strategies and plans and negotiate quality solutions
• Experience in Data modeling (Star, Snowflake schema, Data Vault)
• Has Knowledge of CI/CD pipelines

Qualification Experience Required

• Strong verbal and written communications skills
• Ability to work as an individual contributor.
• 5+ years of combined experience using Snowflake, Azure SQL/ SQL Server or including building Database, database designing and data modelling
• Experience on Snowpipe or Azure Data Factory or SSIS or any other ETL tools
• Exposure to visual analytics tool (Power BI) would be good to have but not mandatory
• Familiarity with Python for automation and scripting.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.