Data Architect

About the Position

Your journey matters – start it with 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 UI 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.

Responsibilities

• 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

Requirements

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

We Offer

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.

About the Company

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 UI design, managed services, product development, and software development.

Application Process

APPLICATION

Send us your application, we are ready to hear your story and explore how we can grow together.

REVIEW

Our team carefully reviews every application with curiosity and care. If your profile isn’t the right fit today, we will keep it in mind for future opportunities that match your skills and ambitions.

TALENT ACQUISITION INTERVIEW

You will meet our Talent team to talk about your goals and learn more about who we are, what we offer, and how we support our people.

TECHNICAL INTERVIEW

Our tech interview is all about diving deeper into your expertise and understanding your strengths, how you solve problems, and how you think – no trick questions, just a meaningful conversation.

CUSTOMER INTERVIEW

For some roles, especially when our clients are closely involved, you might also have a conversation with them – it’s a chance for everyone to align and get to know each other better.

JOB OFFER

If we both feel it’s the right match, we will send you an offer to join us. And even if it’s not the time just yet, you’ll always hear back from us.

WELCOME!

Your new team is excited to meet you, support you, and build something great together. Let’s make your first day the start of a journey that shapes a career that matters.

Already working at Avenga?

Let’s recruit together and find your next colleague.