Data Functional Analyst

Editx; Brussel; On-site; EUR 55,000 - 90,000; Full time

Job summary

Editx is collaborating with a leading Brussels-based enterprise to migrate its core data from Adabas mainframe to PostgreSQL. We seek a Data Functional Analyst to bridge legacy business logic with modern database architecture, working alongside Data Engineers and DBAs.

You will define data mappings, write functional specifications for ETL/ELT flows, ensure data quality, and document lineage and mappings throughout the migration lifecycle, guaranteeing data integrity and cross-functional

Qualifications

• Legacy data analysis and mapping to PostgreSQL
• Strong collaboration with data engineers and DBAs
• Data quality and reconciliation planning
• Documentation of data lineage and mappings

Responsibilities

• Analyze legacy mainframe data structures and define functional mappings to PostgreSQL schema
• Provide functional guidance to data engineers and DBAs; write clear specifications for ETL/ELT pipelines
• Design and implement data validation strategies and reconciliation checks across databases
• Maintain data dictionaries, mapping rulebooks, and lineage documentation throughout the migration
• Serve as the functional contact to translate business rules for technical delivery teams

Job description

About the Role

Oliver James is partnering with a leading enterprise organization migrating its core legacy systems from Adabas (Mainframe) to PostgreSQL.

We are seeking a Data Functional Analyst to bridge the gap between legacy business logic and modern database architecture. Working directly alongside Data Engineers and DBAs, you will define data mappings and ensure a seamless, high-integrity migration.

Key Responsibilities

• Legacy Data Analysis & Mapping: Deep-dive into Mainframe data structures and define accurate functional target mappings to PostgreSQL relational schemaq.
• Technical & Functional Guidance: Act as the primary functional advisor for Data Engineers and DBAs, writing clear functional specifications to guide ETL/ELT pipeline development and schema design.
• Data Quality & Reconciliation: Design data validation strategies, define test scenarios, and execute cross-database reconciliation checks (Mainframe legacy vs. PostgreSQL) to guarantee 100% data integrity and consistency.
• Data Lineage & Documentation: Maintain comprehensive data dictionaries, mapping rulebooks, and lineage documentation throughout the migration lifecycle.
• Cross-Functional Collaboration: Serve as the functional point of contact for resolving legacy data ambiguities and translating complex business rules for the technical delivery team.