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

What will you do?

Key Responsibilities

Data Integration & Pipeline Development

• Design, develop, and maintain data pipelines using AWS Glue and Informatica (PowerCenter)
• Build scalable ETL/ELT workflows for structured data
• Implement data ingestion from multiple sources (databases, APIs, files, cloud storage, SaaS systems)

Data Warehousing & Data Modelling

• Design and implement enterprise data warehouse (EDW) structures
• Develop and maintain dimensional data models (Star / Snowflake schemas)
• Build staging, ODS, and presentation layers
• Optimize data models for reporting and analytics performance
• Support data mart design aligned to business domains

SQL Development & Performance Optimization

• Write complex SQL queries for transformation, validation, and reporting
• Develop stored procedures, views, and data transformation logic
• Perform query tuning and performance optimization
• Implement incremental load logic and data reconciliation checks
• Ensure efficient handling of large-volume datasets

Cloud Data Engineering

Develop AWS Glue jobs using PySpark / Spark SQL

Manage data workflows across AWS ecosystem (S3, Redshift, IAM, Lambda, etc.)

What skills and capabilities will make you successful?

• Strong experience with AWS Glue (ETL jobs, workflows, triggers)
• Hands-on experience with Informatica PowerCenter
• Strong expertise in SQL development and performance tuning
• Experience designing and managing data warehouse architectures
• Proficiency in Python / PySpark for data processing

What's in it for you?

• Warehousing Expertise
• Dimensional modelling (Star / Snowflake schema)
• Data warehouse lifecycle and architecture
• Data staging, transformation, and presentation layers
• Slowly Changing Dimensions (SCD)
• Fact and dimension design
• Data mart architecture

Who will you report to?

• General Manager

What qualifications will make you successful for this role?

• Bachelor's or Master's degree in Engineering, Computer Science, or related field
• Typically 5+ years experience in data engineering, ETL, or data warehousing roles
• Experience working in enterprise-scale data environments

Let us learn about you! Apply today.

You must submit an online application to be considered for any position with us. This position will be posted until filled.

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!

€36 billion global revenue
+13% organic growth
150 000+ employees in 100+ countries
#1 on the Global 100 World's most sustainable corporations

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.