SCT-Tech Enablement-Data Integeration Consultant

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Supply Chain Data Integration Consultant – Senior The opportunity We’re looking for Senior Level Consultants with expertise in Data Modelling, Data Integration, Data Manipulation and analysis to join the Supply Chain Technology group of our GDS consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.   This role demands a highly technical, extremely hands-on Data Warehouse Modelling consultant who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on different business needs. The ideal candidate must have a good understanding of the value of data warehouse and ETL with Supply Chain industry knowledge and proven experience in delivering solutions to different lines of business and technical leadership.   Your key responsibilities

A minimum of 5+ years of experience into BI/Data integration/ETL/DWH solutions in cloud and on-premises platforms such as Informatica/ PC/IICS/Alteryx/Talend/ Azure Data Factory (ADF)/SSIS/SSAS/SSRS and experience on any reporting tool like Power BI, Tableau, OBIEE etc. Performing Data Analysis and Data Manipulation as per client requirements. Expert in Data Modelling to simplify business concepts. Create extensive ER Diagrams to help business in decision making. Working experience with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using data integration technologies Should be able to develop sophisticated workflows & macros (Batch, Iterative, etc.) in Alteryx with enterprise data. Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool Perform end-to-end Data validation to maintain accuracy of data sets. Support client needs by developing SSIS Packages in Visual Studio (version 2012 or higher) or Azure Data Factory (Extensive hands-on experience implementing data migration and data processing using Azure Data Factory). Support client needs by delivering Various Integrations with third party applications. Experience in pulling data from a variety of data source types using appropriate connection managers as per Client needs. Develop, Customize, Deploy, maintain SSIS packages as per client business requirements. Should have thorough knowledge in creating dynamic packages in Visual Studio with multiple concepts such as - reading multiple files, Error handling, Archiving, Configuration creation, Package Deployment etc. Experience working with clients throughout various parts of implementation lifecycle. Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements. Analysing and translating business needs into long-term solution data models. Evaluating existing Data Warehouses or Systems. Strong knowledge of database structure systems and data mining

Skills and attributes for success

Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of Informatica, SQL, PL/SQL, Alteryx , ADF, SSIS , Snowflake, Databricks knowledge and industry expertise to support delivery to clients. Demonstrate management and an ability to lead projects or teams individually. Experience in team management, communication, and presentation.

To qualify for the role, you must have

5+ years ETL experience as Lead / Architect Expertise in the ETL Mappings,