Data Architect

WHO IS ENGIE? ENGIE puts sustainable development at the center of its activities (electricity, natural gas, energy efficiency, and services) to meet the challenges of the energy transition to a low-carbon economy: access to a sustainable economy, climate change mitigation and adaptation, and resource optimization.

WHO ARE WE LOOKING FOR? We are currently searching for Data Architect in S&EM Italy, based in Rome.

The EM IS team provides new solutions or system integration and support to simplify and automize the business’ daily activities. The solutions are currently Microsoft-based, but a strategic move to a Modern AWS Cloud Platform is in progress. This transformation aims to enable Real-Time Analytics, AI Agents, and High-Frequency Trading support.

ENGIE Supply & Energy Management (S&EM) provides energy supply solutions and risk management services to support its clients through their decarbonization journey, while optimizing ENGIE’s assets and contributing to value creation.

ENGIE is a global reference in low-carbon energy and services with a leading energy management business piloted by its Global Business Unit Supply & Energy Management (S&EM) who built its savoir-faire managing the Group’s large and diverse asset portfolio over 20+ years.

7,500 employees around the world develop our solutions, through 19 countries. We cover the full energy mix: renewable and thermal power, natural gas & LNG, biomass, environmental products. Our experts provide tailor made solutions based on a wide range of savoir-faire in energy management with a strong focus on decarbonation and decentralization.

Our clients span the entire value chain: producers, asset developers, financial players, utilities, distributors and industrials. Our global reach and strong local presence enable us to offer these diverse clients tailor-made services and respond to rapid changes in mature or emerging markets alike.

Our 3 expertise:

• Asset management
• Energy supply , providing green energy & innovative solutions

At S&EM we encourage breakthrough results, team spirit, curiosity and innovation while preserving the right work/life balance for you.

WHAT WILL YOU DO? :

The Data Architect will drive the migration from the legacy ecosystem (Azure SQL/SSIS) to a new AWS-based architecture. Responsibilities include:

• Architectural Design: Design and deploy the new Centralized Data Platform on AWS, defining a modern architecture for real-time data acquisition (Streaming/Batch) and timeseries management using AWS services. Ability to manage the Infrastructure As Code processes.
• Migration Strategy: Lead the reverse engineering of legacy SSIS packages and Stored Procedures, guiding the refactoring into modern Python/AWS Glue pipelines.
• Data Lake Implementation: Design the Data Lake storage layers on Amazon S3 (Bronze/Silver/Gold) to replace rigid Tabular Cubes, ensuring scalability and flexibility.
• AI Enablement: Design the data foundation to support AI Agents and predictive models, integrating Amazon SageMaker and Athena for advanced analytics.
• Hybrid Connectivity: Implement a secure Hybrid Cloud strategy to ensure data synchronization between the legacy Azure environment and the new AWS Landing Zone during the transition.
• Technical Leadership: Mentor the internal team in the transition from SQL-centric development to Cloud-Native Data Engineering

The candidate will act as the technical reference point for the migration project, working in collaboration with different teams, both Italian and French/Belgian. They will have autonomy in defining technical standards and architectural patterns

ABOUT YOU:

• Bachelor's degree in STEM disciplines (Computer Science, Engineering, Mathematics, Physics, Statistics, or related fields)
• At least 5 years of experience in Data Architecture and Data Engineering roles.
• Deep expertise in AWS Data Stack: specifically Glue, Lambda, Kinesis/Kafka, S3, DynamoDB, Athena and other services.
• Excellent knowledge of Python and SQL for modern pipeline development.
• Experience in designing Event-Driven Architectures and managing Timeseries Data at scale.
• Experience with Infrastructure as Code (Terraform or CloudFormation).
• Experience in developing RESTful APIs for data exposure.
• Knowledge of energy market dynamics (MGP/MI/Gas) and trading processes.
• Experience with Amazon SageMaker and MLOps pipelines for AI model deployment.
• Proven experience with the Microsoft Data Stack (SQL Server, SSIS, SSAS Tabular), essential for understanding and migrating the legacy system.

Therefore, skills needed are

• Excellent command of written and spoken English fo