Job Description

This is us

At Avenga, we believe that human creativity empowers technology that matters. Operating globally, our 6000+ specialists provide a full spectrum of services, including business and tech advisory, enterprise solutions, CX, UX and Ul design, managed services, product development, and software development.

This is you

• We are looking for an experienced Data Architect to take ownership of the data architecture for the Intermediate Control System (ICS) within a regulated environment. This role focuses on designing robust, audit-ready, and scalable data models that support regulatory compliance, traceability, and long-term system stability.

  You will work closely with backend engineers, BI teams, and technical stakeholders to ensure data integrity and alignment with regulatory requirements.

This is your role

• Own and define the data architecture of the Intermediate Control System (ICS)

• Design and maintain canonical data models

• Define data lifecycle processes and regulatory data flows

• Design database schemas supporting:

  • Data capture

  • Data transformation and conversion

  • Batch processing

  • Auditability and traceability

• Ensure data integrity, immutability, and traceability in a regulated environment

• Define strategies for:

  • Schema evolution (XSD versioning)

  • Handling corrections and late-arriving data

  • Hot vs. cold data separation

• Collaborate with:

  • Backend (Java) team

  • BI / Reporting team

  • OPAP technical stakeholders

• Support technical decision-making during UAT, stabilization, and go-live phases

Required Technical Skills

• Strong background in data modeling and database architecture

• Experience with relational database design (SQL Server preferred)

• Canonical data modeling and normalization expertise

• Experience designing regulatory and audit-friendly data solutions

• Understanding of XML-based data processing concepts

• Knowledge of batch processing and data integrity mechanisms

• Experience with schema versioning and backward compatibility strategies

Technology Stack

• MS SQL Server (2022 / 2025 Enterprise)

• XML / XSD

• Stored procedures and database-side logic

• Partitioning and indexing concepts

• Data governance and audit frameworks
  
  At Avenga, everyone matters. We provide equal opportunities in recruitment, career development, and leadership, regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. We are committed to fostering a work environment where our diverse community of employees, candidates, and business partners actively shapes our growth. By bringing together people from different backgrounds and experiences, we build a workplace where everyone feels free to be themselves while honoring the boundaries of others.