Data Intelligence Consultant

Role Overview: At EY, you will have the opportunity to join the Supply Chain Technology group as a Senior Supply Chain Data Integration Consultant. This role involves working closely with EY Partners and external clients to develop new business opportunities and drive initiatives to meet various business needs. You will be responsible for leveraging your expertise in Data Modelling, Data Integration, and Data Manipulation within the Supply Chain industry to deliver innovative solutions and provide technical leadership. Key Responsibilities: - Possess a minimum of 3 years of experience in BI/Data integration/ETL/DWH solutions on cloud and on-premises platforms such as Informatica, PC, IICS, Alteryx, Talend, Azure Data Factory (ADF), SSIS, SSAS, SSRS, and reporting tools like Power BI, Tableau, OBIEE, etc. - Perform Data Analysis and Data Manipulation based on client requirements. - Expertise in Data Modelling to simplify business concepts and create extensive ER Diagrams for decision-making. - Develop sophisticated workflows and macros in Alteryx, design ETL workflows, and datasets to be used by BI Reporting tools. - Conduct end-to-end Data validation to ensure data accuracy and support client needs by developing SSIS Packages in Visual Studio or Azure Data Factory. - Implement various integrations with third-party applications and work with large heterogeneous datasets to optimize data pipelines using data integration technologies. - Create dynamic packages in Visual Studio, handle error handling, archiving, configuration creation, and package deployment. - Analyze and translate business needs into long-term solution data models, evaluate existing Data Warehouses or Systems, and have a strong knowledge of database structure systems and data mining. Qualification Required: To qualify for this role, you must have: - 5 years of ETL experience as Lead/Architect with expertise in ETL Mappings and Data Warehouse concepts. - Proficiency in SQL, SSIS Batch Jobs, Alteryx workflows, Azure components (ADF, Azure Data Lake, Azure SQL DB, Snowflake, Databricks), and data modelling. - Experience in designing and developing complex mappings, process flows, ETL scripts, and database structures. - Strong knowledge of ELT/ETL concepts, data handling, SQL tuning, and optimization. - Ideally, candidates should also have experience with BI tools like Alteryx, SSAS, SSRS, Azure Analysis Services, Azure Power Apps, and strong communication skills. Additional Details: - The incumbent should be able to drive ETL Infrastructure related developments and have knowledge of complex source system data structures, preferably in the Financial Services industry. - An opportunity to work in a market-leading global team of professionals with diverse expertise. - EY offers support, coaching, feedback, opportunities for skill development, career progression, flexibility, and a focus on personal development in an interdisciplinary environment. (Note: This job description is based on the provided information and may be subject to change as per the company's requirements and policies.) Role Overview: At EY, you will have the opportunity to join the Supply Chain Technology group as a Senior Supply Chain Data Integration Consultant. This role involves working closely with EY Partners and external clients to develop new business opportunities and drive initiatives to meet various business needs. You will be responsible for leveraging your expertise in Data Modelling, Data Integration, and Data Manipulation within the Supply Chain industry to deliver innovative solutions and provide technical leadership. Key Responsibilities: - Possess a minimum of 3 years of experience in BI/Data integration/ETL/DWH solutions on cloud and on-premises platforms such as Informatica, PC, IICS, Alteryx, Talend, Azure Data Factory (ADF), SSIS, SSAS, SSRS, and reporting tools like Power BI, Tableau, OBIEE, etc. - Perform Data Analysis and Data Manipulation based on client requirements. - Expertise in Data Modelling to simplify business concepts and create extensive ER Diagrams for decision-making. - Develop sophisticated workflows and macros in Alteryx, design ETL workflows, and datasets to be used by BI Reporting tools. - Conduct end-to-end Data validation to ensure data accuracy and support client needs by developing SSIS Packages in Visual Studio or Azure Data Factory. - Implement various integrations with third-party applications and work with large heterogeneous datasets to optimize data pipelines using data integration technologies. - Create dynamic packages in Visual Studio, handle error handling, archiving, configuration creation, and package deployment. - Analyze and translate business needs into long-term solution data models, evaluate existing Data Warehouses or Systems, and have a strong knowledge of database structure systems and data mining. Qualification Required: To qualify for this role, you must have: - 5 years of ETL experience as Lead/Architect wi