Data Migration Architect

About the Position

Data Migration Architect

Avenga is an international engineering firm helping businesses operate with AI at the core. With 6,000+ experts worldwide, we combine engineering expertise with AI-native thinking to turn ambitious ideas into real-world impact across industries, technologies, and markets.

At the core of the role

In Prague, we are actively seeking a Senior Data Migration Architect to strengthen our team dedicated to designing and implementing a migration framework for SQL and data structures from Teradata to Google BigQuery. This role is critical for the New Data Platform project, which involves modernizing the organization’s data warehouse ecosystem with cutting-edge technologies, including AI/LLM agents.

Responsibilities

• Design the overall concept of a migration tool for translating SQL transformations and data structures from Teradata to BigQuery.
• Design an agent-based approach combining deterministic migration tools, AI/LLM layer for iterative SQL tuning, and automated data validation.
• Collaborate on the selection of appropriate tools and technologies, including experimental evaluation.
• Define framework operating modes: batch and on-demand, including variants usable by business users.
• Implement the framework with workflow orchestration.
• Integrate key components: SQL translation tools, data validation tools, and Git-based workflow for change detection, branching, and auditability.
• Design and implement batch and on-demand launch modes.
• Optimize the deterministic translation component before applying AI to increase translation accuracy.
• Collaborate with BI and NDP architectural teams to align the framework with the target platform architecture.
• Document all decisions, configurations, and create an operational manual for handover.

Requirements

• Proven practical experience with the design and implementation of migration frameworks or complex data tools.
• Agentic/orchestrated approach to the solution, including AI/LLM agents, managed workflow, and iterative processing.
• Ability to design the architecture and implement it hands-on.
• Strong knowledge of SQL (different dialects) – ability to analyze and translate complex SQL transformations.
• Scripting experience in Python and/or Bash at production implementation level.
• Experience with Git workflows, including branching, PR workflow, and auditability of changes.
• Active knowledge of Czech or Slovak for everyday communication.

Nice to Have

• Experience with AI/LLM agents in data migration projects.
• Familiarity with Google BigQuery and Teradata.

We Offer

• Pleasant working environment and stable background in one of the largest software development companies.
• Space to work independently and creatively with the possibility to implement your own ideas and opportunities to learn new things and approaches.
• You have the opportunity to influence your direction in the company.
• High-quality hardware and software, access to the latest technologies and specific projects.
• Opportunities to improve your language skills, we are a major global player.
• At Avenga, you'll get quality support in your development thanks to a wide range of internal and external training courses, so you can push the boundaries of your competences.
• We offer you benefits such as life insurance and pension contribution, EN/DE/ES lessons, MultiSport card, sick days, meal allowance, lots of company events, offices in Prague Palmovka with quality amenities for lovers of sport, food and coffee, hybrid remote work after mutual agreement, and more.

About the Company

People are at the core of Avenga. We provide equal opportunities regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. We are committed to a respectful environment where everyone can be themselves, share their ideas, and feel that they belong.

Application Process

1. APPLICATION: Send your CV to tell us about your core skills and what you're looking for next.
2. TALENT CALL: Meet our Talent team to talk about your goals and experience while exploring our culture and the way we work.
3. TECHNICAL INTERVIEW: We'll explore your experience, strengths, and approach to work to see what we can build together.
4. CUSTOMER INTERVIEW: For some roles, you'll meet our customers to understand the outcomes your expertise can help create.
5. WELCOME TO AVENGA: An offer is just the beginning. We welcome you to put your expertise into action and shape what's next together.