Senior, Data Engineer

⚡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 reusable ingestion frameworks to support data migration from on-prem to cloud

Data Warehousing & Modelling

• Develop and maintain dimensional models (fact/dimension tables, SCD handling)

• Optimize data models for analytics and reporting performance

Cloud Data Engineering

• Develop and manage AWS Glue jobs using PySpark / Python

• Build and orchestrate workflows across AWS ecosystem (Redshift, Lambda)

• Ensure efficient compute and storage utilization for performance and cost optimization

Monitoring & Operations

• Monitor ETL pipelines and job performance

• Troubleshoot data failures and performance bottlenecks

• Implement logging, alerting, and recovery mechanisms

Data Engineering & Processing

• 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. DIGDATA24 Let us learn about you! Apply today.

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. Become an IMPACT Maker with Schneider Electric – apply today!

• €40 billion global revenue

• +9% organic growth

• 150 000+ employees in 100+ countries

You must submit an online application to be considered for any position with us. This position will be posted until filled. 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, sustainability, quality and cybersecurity, underpinning every aspect of our business and our willingness to behave and respond respectfully and in good faith to all our stakeholders. You can find out more about our Trust Charter here Schneider Electric is an Equal Opportunity Employer. It is our policy to provide equal employment and advancement opportunities in the areas of recruiting, hiring, training, transferring, and promoting all qualified individuals regardless of race, religion, color, gender, disability, national origin, ancestry, age, military status, sexual orientation, marital status, or any other legally protected characteristic or conduct.