Data Integration & Data Warehousing Engineer
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.

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 utilisation for performance and cost optimisation.

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.

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 p

📌 Senior, Data Engineer (Bellprat)
🏢 Schneider Electric
📍 Bellprat