Job Summary
Job SummaryWe are looking for an experienced ETL SCM Functional Consultant to design, architect, and optimize supply chain data pipelines and enterprise data warehouse solutions. In this role, you will define the functional mapping requirements for complex supply chain data (e.g., procurement, inventory, manufacturing, and order management) and collaborate with data engineers to build reliable, high-performance ETL/ELT processes.Key ResponsibilitiesData Architecture & MappingTranslate functional supply chain requirements into technical data mapping specifications (Source-to-Target Mappings).Define business logic, data cleansing rules, and transformation rules for core supply chain domains (Procure-to-Pay, Order-to-Cash, Inventory Valuation, Logistics/Shipping).Partner with enterprise architects to design data warehouse schemas (star/snowflake schemas, dimensional modeling) tailored to supply chain metrics.ETL/ELT Design & ValidationCollaborate with data engineering teams to review and oversee the development of data pipelines using modern ETL tools (e.g., Informatica, Talend, AWS Glue, dbt) or cloud platforms (Snowflake, BigQuery).Conduct rigorous data validation and functional testing to verify that transformations match underlying ERP logic (e.g., Oracle SCM, SAP S/4HANA).Troubleshoot data discrepancies, pipeline failures, and reconciliation issues between source systems and analytical reports.Analytics & Reporting EnablementEnsure loaded data supports business intelligence (BI) requirements, enabling dashboards for inventory turnover, supplier performance, order fulfillment lead times, and demand forecasting.Partner with business stakeholders to define KPIs and metrics that track supply chain efficiency.
Key Responsibilities
Job SummaryWe are looking for an experienced ETL SCM Functional Consultant to design, architect, and optimize supply chain data pipelines and enterprise data warehouse solutions. In this role, you will define the functional mapping requirements for complex supply chain data (e.g., procurement, inventory, manufacturing, and order management) and collaborate with data engineers to build reliable, high-performance ETL/ELT processes.Key ResponsibilitiesData Architecture & MappingTranslate functional supply chain requirements into technical data mapping specifications (Source-to-Target Mappings).Define business logic, data cleansing rules, and transformation rules for core supply chain domains (Procure-to-Pay, Order-to-Cash, Inventory Valuation, Logistics/Shipping).Partner with enterprise architects to design data warehouse schemas (star/snowflake schemas, dimensional modeling) tailored to supply chain metrics.ETL/ELT Design & ValidationCollaborate with data engineering teams to review and oversee the development of data pipelines using modern ETL tools (e.g., Informatica, Talend, AWS Glue, dbt) or cloud platforms (Snowflake, BigQuery).Conduct rigorous data validation and functional testing to verify that transformations match underlying ERP logic (e.g., Oracle SCM, SAP S/4HANA).Troubleshoot data discrepancies, pipeline failures, and reconciliation issues between source systems and analytical reports.Analytics & Reporting EnablementEnsure loaded data supports business intelligence (BI) requirements, enabling dashboards for inventory turnover, supplier performance, order fulfillment lead times, and demand forecasting.Partner with business stakeholders to define KPIs and metrics that track supply chain efficiency.