Data Intelligence Consultant

As a Supply Chain Data Integration Consultant Senior at EY, you will have the opportunity to utilize your expertise in Data Modelling, Data Integration, Data Manipulation, and analysis to contribute to the growth of the Supply Chain Technology group within the GDS consulting Team. Your role will involve working closely with EY Partners and external clients to develop new business opportunities and drive initiatives to meet various business needs within the Supply Chain industry. **Key Responsibilities:** - Utilize your expertise in BI/Data integration/ETL/DWH solutions using platforms such as Informatica/ PC/IICS/Alteryx/Talend/ Azure Data Factory (ADF)/SSIS/SSAS/SSRS and experience in reporting tools like Power BI, Tableau, OBIEE etc. - Perform Data Analysis and Data Manipulation to meet client requirements. - Demonstrate proficiency in Data Modelling to simplify complex business concepts. - Create extensive ER Diagrams to facilitate decision-making processes. - Work with large, heterogeneous datasets to build and optimize data pipelines using data integration technologies. - Develop sophisticated workflows & macros in Alteryx for enterprise data. - Design and develop ETL workflows and datasets in Alteryx for use by BI Reporting tools. - Perform end-to-end Data validation to ensure the accuracy of data sets. - Support client needs by developing SSIS Packages in Visual Studio or Azure Data Factory. - Deliver Various Integrations with third-party applications. - Pull data from various sources using appropriate connection managers. - Develop, Customize, Deploy, and maintain SSIS packages as per client business requirements. - Create dynamic packages in Visual Studio with multiple concepts such as reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment, etc. - Collaborate with clients throughout various parts of the implementation lifecycle. - Analyze and translate business needs into long-term solution data models. - Evaluate existing Data Warehouses or Systems. - Demonstrate a proactive and solution-oriented mindset, with a willingness to learn new technologies to meet client requirements. - Strong knowledge of database structure systems and data mining. **Skills And Attributes For Success:** - Deliver large/medium DWH programmes and demonstrate expertise in core consulting skills and technologies such as Informatica, SQL, PL/SQL, Alteryx, ADF, SSIS, Snowflake, and Databricks. - Exhibit management skills and the ability to lead projects or teams. - Experience in team management, communication, and presentation. **Qualifications Required:** - 5+ years of ETL experience as Lead/Architect. - Expertise in ETL Mappings and Data Warehouse concepts. - Proficiency in Structured Query Language (SQL) and experience with SQL Server. - Experience in developing SSIS Batch Jobs and Alteryx workflows. - Knowledge of Azure components like ADF, Azure Data Lake, Azure SQL DB, Snowflake, and Databricks. - Strong understanding of data modelling and ETL design. At EY, you will have the opportunity to drive ETL Infrastructure related developments and work with complex source system data structures, especially in the Financial services industry. You will be part of a market-leading team with opportunities to collaborate with leading businesses globally across various industries. Join EY to be a part of building a better working world, where you can contribute to creating long-term value for clients, people, and society. You will have access to diverse teams, advanced technology, and opportunities for personal and professional growth in a supportive and engaging environment. As a Supply Chain Data Integration Consultant Senior at EY, you will have the opportunity to utilize your expertise in Data Modelling, Data Integration, Data Manipulation, and analysis to contribute to the growth of the Supply Chain Technology group within the GDS consulting Team. Your role will involve working closely with EY Partners and external clients to develop new business opportunities and drive initiatives to meet various business needs within the Supply Chain industry. **Key Responsibilities:** - Utilize your expertise in BI/Data integration/ETL/DWH solutions using platforms such as Informatica/ PC/IICS/Alteryx/Talend/ Azure Data Factory (ADF)/SSIS/SSAS/SSRS and experience in reporting tools like Power BI, Tableau, OBIEE etc. - Perform Data Analysis and Data Manipulation to meet client requirements. - Demonstrate proficiency in Data Modelling to simplify complex business concepts. - Create extensive ER Diagrams to facilitate decision-making processes. - Work with large, heterogeneous datasets to build and optimize data pipelines using data integration technologies. - Develop sophisticated workflows & macros in Alteryx for enterprise data. - Design and develop ETL workflows and datasets in Alteryx for use by BI Reporting tools. - Perform end-to-end Data validation to ensure the accuracy of data sets. - Su