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

Core skills you'll bring

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

The impact you'll create

• 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 (vendor-provided) for translation.
• AI/LLM layer for iterative SQL tuning and edge-case resolution.
• Automated data validation with feedback loop (error → AI → re-run → 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.

What supports your journey

• 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

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.