Data Transformation & Automation Engineer

Schneider Electric; Monterrey; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

Schneider Electric is seeking a Data Transformation & Automation Engineer in Monterrey to design, develop, and maintain scalable data solutions across Global Supply Chain. You will own end-to-end data lifecycle, implement ETL/ELT processes, and drive automation to improve data reliability and operational efficiency.

Collaborating with regional stakeholders, you will optimize data models, ensure data quality, and enable dashboards and analytics with Power BI/Tableau.

Formación

• 3+ years of experience in Data Engineering, Data Analytics, BI, or related fields.
• Hands-on experience designing and supporting ETL/ELT processes and data transformation solutions.
• Strong experience with relational databases and SQL for data extraction, manipulation, and analysis.

Responsabilidades

• Design, develop, maintain, and optimize ETL/ELT pipelines for data integration and delivery across systems.
• Develop SQL queries, stored procedures, and data models to support reporting and analytics.
• Lead data migration, harmonization, and master data alignment in global transformation projects.
• Collaborate with cross-functional teams to align business requirements with data solutions.
• Monitor data pipelines, ensure data quality, and implement validation frameworks.

Conocimientos

SQL

Python

ETL/ELT

Data Modeling

Data Governance

Data Integration

Business Intelligence

Cloud Data Platforms

Herramientas

SAP MDG

Informatica

PIM

ERP Systems

Power BI

Tableau

Descripción del empleo

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.

Qualifications

Required Experience

• 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

Technical Skills

• 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.

Analytical & Behavioral Competencies

• 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.

Preferred Qualifications

• 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.

What's in it for me?

• 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

Rewards designed for you

Our Total Rewards is our way of saying: We see you and we value you. It’s more than just pay and benefits—it’s a meaningful investment in you. It is designed to help you perform, grow, feel safe, and elevate your potential. The package helps you care for yourself and your family, plan your future, grow your skills and career, collaborate in an inclusive workplace, and contribute to your community. At Schneider Electric, we’re here for what matters most to you. Discover more at our Career Page.

Looking to make an IMPACT with your career?

When you are thinking about joining a new team, culture matters. At Schneider Electric, our values and behaviors are the foundation for creating a great culture to support business success. We believe that our IMPACT values – Inclusion, Mastery, Purpose, Action, Curiosity, Teamwork – starts with us.

IMPACT is also your invitation to join Schneider Electric where you can contribute to turning sustainability ambition into actions, no matter what role you play. It is a call to connect your career with the ambition of achieving a more resilient, efficient, and sustainable world.

We are looking for IMPACT Makers; exceptional people who turn sustainability ambitions into actions at the intersection of automation, electrification, and digitization. We celebrate IMPACT Makers and believe everyone has the potential to be one.

€40 billion global revenue
+9% organic growth
150 000+ employees in 100+ countries

Schneider Electric aspires to be the most inclusive and caring company in the world, by providing equitable opportunities to everyone, everywhere, and ensuring all employees feel uniquely valued and safe to contribute their best. We mirror the diversity of the communities in which we operate, and ‘inclusion’ is one of our core values. We believe our differences make us stronger as a company and as individuals and we are committed to championing inclusivity in everything we do.

At Schneider Electric, we uphold the highest standards of ethics and compliance, and we believe that trust is a foundational value. Our Trust Charter is our Code of Conduct and demonstrates our commitment to ethics, safety,