.EY-GDS- DnA Consulting – TPM Data Engineer AzureAs part of our EY- GDS-DnA Consulting team, you will help clients use various methods to transform raw data into useful data systems. You will align data systems with business goals. You must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The ideal candidate should have 3-5 years of experience in Data Engineering, AZURE Cloud, Advanced SQL, Advanced Python programming, ETL and ELT Process knowledge, Data structures knowledge, MPP Databases (Teradata, Snowflake), Blob Storage, Azure Data Lake Storage, and AZURE cloud. The Data Engineer will interact with different members of the team such as database architects, data analysts, and data scientists on data initiatives and ensure optimal data delivery architecture is consistent with business strategy. Our clients usually have their headquarters in the USA; however, they span across multiple industries, regions, and countries.The opportunityWe are looking for a Senior Data Engineer with expertise in developing and managing data pipelines, implementing complex stored procedures and best practices with data warehouse and ETL concepts, and deploying fully operational data warehouse solutions into production. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.Your key responsibilitiesDesign and develop batch and streaming data processing.Build data systems and pipelines.Evaluate business needs and objectives.Prepare data for prescriptive and predictive modeling.Build prototypes.Combine raw information from different sources.Explore ways to enhance data quality and reliability.Identify opportunities for data acquisition.Monitor and optimize data storage and data processing.Design and implement data security.Skills and attributes for successData Project Management / Tech Lead.5-7 years of experience on Azure Data Factory.5-7 years of experience on Databricks / Synapse.Experience on processing real-time data.Advanced knowledge of processing large amounts of data (billions of records).5-7 years of advanced knowledge in SQL, Python programming, ETL and ELT Process.Advanced knowledge of data structures, MPP Databases, Blob Storage.5-7 years of experience on AZURE storage (Blob, ADLS).Previous experience as a data engineer or in a similar role.Data engineering certification (AZURE Certified Data Engineer) is a plus.Flexible and adaptable; able to work in ambiguous situations.Able to work effectively at all levels in an organization.Must be a team player and able to work collaboratively with and through others.Must like to learn.To qualify for the role, you must haveBachelor's in technology or engineering or similar.Experience working with Azure, Snowflake technologies.Ideally, you'll also haveFamiliarity with agile methodologies.Familiarity with software such as Jira or ADO