Join EY's GDS consulting team as a Senior Supply Chain Data Integration Consultant. This role offers a unique opportunity to contribute to a growing service offering within a leading global firm. You will leverage your expertise in data modeling, integration, manipulation, and analysis to develop innovative solutions for our clients.

We are seeking a highly technical and hands-on consultant to collaborate with EY Partners and clients. Your responsibilities will include developing new business and driving initiatives to meet diverse business needs. A strong understanding of data warehousing, ETL processes, and supply chain industry knowledge is essential, coupled with proven experience in delivering solutions and providing technical leadership.

Engage in data analysis and manipulation to meet client requirements. Master data modeling to simplify complex business concepts. Develop extensive ER Diagrams to aid business decision-making. Work with large, heterogeneous datasets to build and optimize data pipelines, architectures, and integrated datasets using data integration technologies. Create sophisticated workflows and macros in Alteryx for enterprise data processing. Design and develop ETL workflows and datasets in Alteryx for BI reporting tools. Conduct end-to-end data validation to ensure accuracy. Develop SSIS Packages or Azure Data Factory solutions for client needs, including data migration and processing. Deliver various integrations with third-party applications. Pull data from diverse sources using appropriate connection managers. Develop, customize, deploy, and maintain SSIS packages. Create dynamic packages in Visual Studio with robust error handling and deployment strategies. Collaborate with clients throughout the implementation lifecycle. Maintain a proactive, solution-oriented mindset, embracing new technologies.

A minimum of 5 years of experience in BI, data integration, ETL, or DWH solutions across cloud and on-premises platforms such as Informatica, PC, IICS, Alteryx, Talend, Azure Data Factory (ADF), SSIS, SSAS, and SSRS. Proficiency in reporting tools like Power BI, Tableau, or OBIEE is required. Demonstrate expert-level knowledge in Informatica, SQL, PL/SQL, Alteryx, ADF, SSIS, Snowflake, and Databricks. Possess strong consulting skills and the ability to lead projects or teams independently. Experience in team management, communication, and presentation is crucial. Exhibit a deep understanding of data warehouse concepts and data engineering tools like Databricks, Snowflake, Azure, AWS, and MS Fabric. Proficiency in Structured Query Language (SQL), including SQL tuning and optimization. Experience in developing and deploying SSIS batch jobs. Familiarity with Azure components such as ADF, Azure Data Lake, and Azure SQL DB. Solid knowledge of data modeling and ETL design principles. In-depth experience in database design and data modeling. Strong analytical and problem-solving abilities are essential.