Data Architect

About the role

Data Architect position in S&EM Italy, based in Rome. The EM IS team delivers new solutions or system integration and support to simplify and automate the business’ daily activities. Currently the solutions are Microsoft‑based, but a strategic move to a Modern AWS Cloud Platform is underway to enable Real‑Time Analytics, AI Agents, and High‑Frequency Trading support. The role offers a permanent contract according to local labour law.

Responsibilities

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

Requirements

• 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

Qualifications

• 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