Data Transformation & Automation Engineer

Data Transformation & Automation Engineer
Position Summary

As a GSC Data Transformation & Automation Engineer, you will play a critical role in enabling data-driven decision making across Global Supply Chain operations by designing, developing, and maintaining scalable data solutions. You will be responsible for the end-to-end lifecycle of data, including data ingestion, ETL processes, transformation, automation, quality management, and delivery of trusted datasets for analytics and reporting.

In this role, you will partner with global and regional stakeholders to drive transformation initiatives involving data migration, harmonization, master data governance, and process standardization. You will leverage SQL, Python, ETL frameworks, automation technologies, and business intelligence tools to build sustainable solutions that improve data reliability, operational efficiency, and business performance.

As a subject matter expert in data engineering and automation, you will independently solve complex technical challenges, optimize existing data models and pipelines, and contribute to strategic digital transformation initiatives across the organization.
Key Responsibilities

• Design, develop, maintain, and optimize ETL/ELT pipelines to support data integration, transformation, and delivery across multiple business systems.
• Build and manage scalable data ingestion processes that ensure reliable and timely availability of data for operational and analytical use cases.
• Develop complex SQL queries, stored procedures, views, and data models to support reporting, analytics, and business intelligence requirements.
• Participate in global and regional transformation projects involving data migration, data harmonization, master data alignment, and process standardization.
• Collaborate with cross-functional and cross-cultural teams to align business requirements with data and automation solutions.
• Transform, cleanse, and standardize raw data from multiple sources into consistent, business-ready datasets.
• Implement data validation frameworks and quality controls to ensure data accuracy, completeness, consistency, and integrity.
• Monitor data pipelines and platform performance, identifying and resolving data integration, transformation, and migration issues.
• Develop proactive monitoring, alerting, and troubleshooting capabilities to improve system reliability and reduce operational support efforts.
• Identify and implement automation opportunities that eliminate manual activities and improve process efficiency across supply chain operations.
• Support the design and implementation of testing frameworks for data extraction, transformation, and loading processes.
• Lead root-cause analysis, bug fixes, data model enhancements, and performance optimization initiatives.
• Deliver trusted datasets and scalable data structures that support dashboards, reports, advanced analytics, and business insights.
• Manage priorities, timelines, risks, and deliverables to ensure successful project execution and stakeholder satisfaction.
• Contribute to the continuous improvement of data architecture, governance standards, and engineering best practices.

• 3+ years of experience in Data Engineering, Data Analytics, Business Intelligence, Data Management, or related fields.
• Hands-on experience designing and supporting ETL/ELT processes and data transformation solutions.
• Strong experience working with relational databases and SQL for data extraction, manipulation, optimization, and analysis.
• Experience supporting data initiatives within Supply Chain functions such as Plan, Source, Make, Deliver, or Logistics.
• Experience working in global organizations, shared service environments, or global business hubs is preferred.
• Experience with ERP platforms and master data management processes.
• english advanced

• Advanced proficiency in SQL and database concepts.
• Strong programming skills in Python for data engineering, automation, and analytics.
• Experience with ETL tools, data integration platforms, and workflow orchestration solutions.
• Knowledge of SAP, SAP MDG, Informatica, PIM, or similar master data management platforms.
• Experience developing automation solutions using RPA or comparable technologies.
• Proficiency with Business Intelligence and data visualization tools such as Power BI, Tableau, or similar platforms.
• Understanding of data quality management, data governance, and master data principles.
• Knowledge of cloud-based data platforms and modern data architectures is a plus.

• Strong analytical and problem-solving capabilities with the ability to identify patterns, root causes, and improvement opportunities.
• Ability to translate complex technical concepts into clear business recommendations and actionable insights.
• Strong stakeholder management and communication skills across global and regional teams.
• Ability to work independently while managing multiple priorities in a fast-paced environment.
• Continuous improvement mindset with a passion for automation, innovation, and operational excellence.

• Experience with data warehousing and dimensional modeling.
• Experience working with large-scale datasets and enterprise reporting environments.
• Familiarity with Agile methodologies and project delivery frameworks.
• Certification in SQL, Python, Data Engineering, Power BI, SAP, or cloud platforms is a plus.

• Hands-on experience with parallel and streaming processing tools for big data pipelines
• High-visibility role where your contributions directly enable data-driven decision-making
• Collaborative team culture that encourages innovation and technical growth
• Opportunities to expand your expertise in a dynamic, evolving technical environment