Barcelona
⚡We are your Energy Technology Partner. We electrify, automate, and digitalize every industry, business, and home, driving efficiency and sustainability for all. At Schneider Electric, our values – IMPACT (Inclusion, Mastery, Purpose, Action, Curiosity, Teamwork) – are the foundation of everything we do. Becoming an Impact Maker means turning sustainability ambitions into actions at the intersection of automation, electrification, and digitization. Are you ready to lead the digital transformation to create a more sustainable world?🌳 If you are up to challenge your creativity and make an impact, we are excited to welcome you! Schneider Digital is the digital department of Schneider Electric, leading the digital transformation in the company by giving support globally to our internal teams and our clients. Schneider Digital consists of 6 Digital Hubs worldwide which are strategically located to ensure a 24/7 support across the company (France, China, India, USA, Mexico and Spain). Our Digital Hub in Barcelona is formed by +450 employees working in strategic projects and different roles such as Data, Cybersecurity, ERP, Cloud, Infrastructures, IT Project Management or Digital Marketing. Barcelona Digital Technology Center is part of Schneider Digital: enabling Schneider-Electric digital transformation by delivering Business Requirements. We are looking for a skilled Data Integration & Data Warehousing Engineer to design, build, and manage scalable data pipelines and enterprise data warehouse solutions using AWS Glue , AWS Lambda and Informatica. This role will focus on enabling reliable data ingestion, transformation, modelling, and delivery across the organization while ensuring performance, quality, governance, and scalability. The ideal candidate should have strong experience in ETL/ELT frameworks, data warehousing design, advanced SQL development, and cloud-based data engineering. Key Responsibilities: Data Integration & Pipeline Development • Design, develop, and maintain scalable data pipelines using Python, AWS Glue, and Informatica PowerCenter, • Build robust ETL/ELT workflows for ingesting structured data from multiple sources (databases, APIs, files, SaaS systems), • Develop and maintain dimensional models (fact/dimension tables, SCD handling), • Develop and manage AWS Glue jobs using PySpark / Python, • Build and orchestrate workflows across AWS ecosystem (Redshift, Lambda), • Monitor ETL pipelines and job performance, • Troubleshoot data failures and performance bottlenecks, • Build scalable data processing solutions using Spark and distributed computing techniques, • Perform data profiling, reverse engineering, and ad-hoc analysis, • Support downstream systems by delivering clean, reliable, and optimised datasets What qualifications will make you successful for this role? Experience & Qualifications • Bachelor’s or Master’s degree in Engineering, Computer Science, or related field, • Typically 5 years of experience in data engineering, ETL, or data warehousing roles, • Experience working in enterprise-scale data environments, • Strong hands-on experience in Python / PySpark, • Strong proficiency in SQL (querying, optimization, transformations), • Experience in building and maintaining data pipelines (ETL/ELT), • Experience with AWS services (AWS Glue, AWS Lambda, S3), • Version control using GIT Good to Have • Hands-on experience with Informatica PowerCenter, • Experience with workflow orchestration tools (Airflow / Step Functions), • Strong understanding of data warehousing concepts (EDW, ODS, staging layers), • Knowledge of CI/CD pipelines for data engineering, • Exposure to cloud-based data lake architectures, • Knowledge of BI tools like Oracle Analytics Cloud and ThoughtSpot Key Competencies • Strong analytical and problem-solving skills, • Deep understanding of data structures and relationships, • Attention to data quality and accuracy, • Ability to work in cross-functional teams, • Ownership mindset for delivery and operations What will you get? We adapt to you: 🕓 With our flexible schedule, you'll have the freedom to adjust your work hours to accommodate your personal needs and responsibilities. 💻 We know how great it is to work from home. With our hybrid work plan, you can enjoy working from the comfort of your home. 🏝 Need more time to relax and disconnect? With our Holy Pack, you can purchase additional vacation days to recharge when you need it most. 📅 Celebrate holidays your way! With Floating Holidays, you can exchange holidays for other days that better suit your plans and personal preferences. 🧘 Need additional time to explore new experiences or focus on personal projects? With the Sabbatical Pack, you can request up to 2 months of extra leave (unpaid). 💞 We value the importance of family and want to support you in all aspects of your life. Our Global Family Leave Policy provides flexible paid conditions for when you need it most, whether you're about to be a parent, need time to overcome a loss, or to care for a loved one. We take care of you: 📱 With access to the health and wellness platform Wellwo, you and up to 5 people of your choice can enjoy access to wellness content, nutrition counseling, fitness classes, and more! 🏄 From dance classes to booking a hotel spa, we offer an agreement with Wellhub so you can access a network of thousands of gyms and sports centers to keep your body active in the way you like best. 🩺 Your well-being is our priority. You will have medical service at your workplace for close attention to any medical needs. We empower you: 🎯 With Career Hub, our AI-driven professional development platform, you can connect with job opportunities, projects, and mentors at Schneider Electric globally. 🤑 We offer you the opportunity to be a shareholder of Schneider Electric and share in our achievements with our stock ownership program. 🙌 We celebrate everyone's talent and success with our recognition program, through which you can give and receive points for your achievements and redeem them for gift cards at your favorite stores. 💗 You will have life insurance for your protection. 💰 We offer you a Flexible Remuneration Plan in which you can choose from a variety of options, such as health insurance, meal vouchers, childcare vouchers, transportation vouchers, training, and more. 🎁 With Club Schneider, you will enjoy special discounts at your favorite stores, restaurants, travel agencies, and other external services. 💚 Participate in company-subsidized volunteer programs to contribute to our community and have a positive impact on your environment. Let us learn about you! Apply today.