Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Amaris Consulting | Part of Mantu

NewBe an early applicant

Data Architect

Posted

Description

ABOUT THE ROLE

We are looking for a hands-on data architect to lead the data migration of a platform replacement project, from Oracle to PostgreSQL. If you enjoy making sense of a legacy database, designing where the data should live next, and seeing a migration through to production with proof that nothing was lost along the way, we would love to hear from you.


WHAT WE ARE LOOKING FOR


* Experience in at least one large-volume Oracle-to-PostgreSQL migration, ideally from discovery to production.

* Confidence analyzing an Oracle database through its data dictionary: tables, keys, relationships, and indexes, including schemas with little documentation.

* Experience preparing a single-cutover migration, with rehearsal cycles, rollback planning, and production go-live.

* Advanced SQL for analysis, reconciliation, and migration validation across Oracle and PostgreSQL.

* Fluent Spanish, as you will lead workshops with business users and agree the migration rules with them.


IT WOULD BE A PLUS


* Experience with data protection topics, including anonymization of sensitive personal data.

* Exposure to data governance, business glossaries, model change control, Snowflake, or Azure managed databases.

* English, to collaborate with the part of the project team based outside Spain.


Don't tick every box? Apply anyway. Research consistently shows that women are less likely to apply for a role unless they meet 100% of the listed requirements. If this role resonates with you and you meet most of the criteria, we encourage you to apply. At Amaris Consulting, part of Mantu, we hire for drive, mindset, and potential as much as for credentials.


WHY THIS ROLE


* You will join a critical platform replacement project involving around 20 years of data and more than 19 million records.

* You will own the migration scope and help shape the migration strategy from the start.

* You will join at the launch phase, when your decisions have the most impact.


WHAT YOU'LL DO


* Discover and document the existing Oracle data model using the data dictionary and database objects.

* Read PL/SQL procedures, packages, and triggers to identify the business rules embedded in them.

* Design the PostgreSQL target model, including indexing and partitioning strategies for very large tables.

* Build repeatable, resumable high-volume loading programs in Python or Java.

* Automate data profiling checks covering nulls, duplicates, invalid values, and orphan records.

* Define the reconciliation rules and evidence packs that demonstrate the migration is complete.


GOOD TO KNOW BEFORE YOU APPLY


* Hands-on experience in a large Oracle migration is the one requirement we cannot be flexible on.

* This is a data architecture and migration role, rather than an analytics, reporting, or artificial intelligence position.

* The legacy environment is only partly documented, so a good share of the work is investigative. You will enjoy it if you like uncovering the model and the quality rules yourself.

* Day-to-day sessions with business users are held in Spanish.


THE EMPLOYER

Amaris Consulting, part of Mantu, is an independent consulting company deploying technical and engineering expertise across 60+ countries. We work on the projects that challenge and move things forward.


WHAT WE OFFER


* International mobility across 60+ countries.

* AI training from day one: from Fundamentals to Agentic AI.

* 75% of our leaders started at entry level, your starting point does not define your ceiling.

* A culture of intrapreneurship: your ideas can become real initiatives.

* WeCare Together: community impact program active in 13 countries.


OUR PROCESS

Our process typically starts with a brief virtual conversation. You'll meet your future manager and key stakeholders across 2–3 interviews. Depending on the role, we may ask for a case study, a role play, or a technical assessment. We always put ourselves in the candidate's shoes to ensure the best possible experience.


Amaris Consulting, part of Mantu, is proud to be an equal opportunity workplace. We are committed to promoting diversity within the workforce and creating an inclusive working environment. For this purpose, we welcome applications from all qualified candidates regardless of gender, sexual orientation, race, ethnicity, beliefs, age, marital status, disability, or other characteristics.


By applying, you agree to the processing of your personal data for recruitment purposes, in accordance with our Privacy Policy. Your data is stored securely and never sold. mantu.com/privacy-policy

Skills

What Junior Architecture jobs ask for — and how much of it you have →
Apply

See also

Architecture jobs by country — openings, pay and top skills →