Oliver James Associates - Data Functional Analyst

ictjob.be; Brussel; On-site; EUR 60,000 - 90,000; Full time

Job summary

Oliver James, partnering with a leading enterprise in Brussels, seeks a Data Functional Analyst to bridge legacy Adabas mainframe logic with PostgreSQL architecture. You will define data mappings, data dictionaries and data lineage, guiding ETL/ELT pipelines and schema design alongside Data Engineers and DBAs.

Join a high-integrity migration project, establishing data quality strategies, reconciliation checks, and clear functional specifications for cross-team delivery throughout the migration

Qualifications

• Experience migrating data from mainframe systems (Adabas) to PostgreSQL.
• Ability to write clear functional specifications for ETL/ELT pipelines and schema design.
• Experience ensuring data quality and reconciliation across databases.

Responsibilities

• Legacy Data Analysis & Mapping: analyze Mainframe data structures and define mappings to PostgreSQL.
• Technical & Functional Guidance: act as the functional advisor for Data Engineers and DBAs, writing specs to guide ETL/ELT development and schema design.
• Data Quality & Reconciliation: design validation strategies, define test scenarios, and perform cross-database checks to ensure data integrity.
• Data Lineage & Documentation: maintain data dictionaries, mapping rulebooks, and lineage documentation throughout the migration.
• Cross-Functional Collaboration: serve as the functional contact to resolve legacy data ambiguities for the delivery team.

Skills

Data analysis

Data mapping

ETL/ELT design

Data quality

Data reconciliation

Functional specs

Cross-functional collaboration

Mainframe to PostgreSQL

Tools

PostgreSQL

ETL tools

Job description

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