Senior Avaloq Data Migration & Integration Specialist

Project description

We are seeking an experienced Avaloq Data Migration & Integration Specialist to join the Data and API Management team, supporting the extraction, transformation and delivery of data from the Avaloq Core Banking platform into enterprise APIs and downstream applications. The successful candidate will have an in-depth understanding of Avaloq from a data modelling and database perspective, with strong experience in identifying, investigating and resolving complex data-related issues. This is a hands-on technical role focused on understanding how data is structured, stored, accessed and transferred within Avaloq. The individual will be responsible for investigating data inconsistencies, resolving extraction and connectivity issues, and ensuring that data can be efficiently and accurately made available to API services. The role is not focused on Avaloq parametrisation or functional configuration. Instead, it requires someone with strong technical curiosity, analytical problem-solving capabilities and the ability to navigate complex Avaloq data structures to identify and resolve issues.

Responsibilities

• 1. Avaloq Data Modelling & Architecture · Develop a deep understanding of Avaloq's underlying data model, database structures, relationships and dependencies. · Navigate complex Avaloq data structures to understand how banking information is stored, linked and retrieved. · Identify the appropriate data sources and structures required to extract information from Avaloq. · Understand relationships between key banking data entities, including clients, accounts, portfolios, securities, transactions and financial instruments. · Investigate how data is structured and exposed within Avaloq to support downstream integration requirements. · Identify data dependencies and potential limitations that could impact extraction, migration or API connectivity. 2. Data Migration, Extraction & Transformation · Design and implement data extraction and migration solutions from Avaloq. · Investigate and resolve data quality issues, inconsistencies, missing information and incorrect data relationships. · Develop and optimise SQL queries, PL/SQL procedures and other database-level extraction mechanisms. · Perform data mapping, transformation, validation and reconciliation between Avaloq and downstream systems. · Ensure extracted data is accurate, complete and structured appropriately for consumption by APIs. · Identify opportunities to improve data extraction efficiency and reduce unnecessary processing overhead. · Troubleshoot complex data migration challenges and recommend appropriate technical solutions. 3. Data Connectivity & API Integration · Investigate and resolve connectivity challenges between Avaloq and enterprise integration/API platforms. · Ensure data can be accessed and extracted efficiently from Avaloq for downstream API consumption. · Work closely with API developers and architects to understand data requirements and integration dependencies. · Support the transformation of Avaloq data into standardised formats such as JSON and XML. · Investigate and resolve issues affecting data flows, interfaces and integration processes. · Support the development of reliable and reusable mechanisms for making Avaloq data available to APIs. · Ensure data is delivered consistently, accurately and within agreed performance expectations. 4. Data Investigation & Problem Resolution · Take a proactive and investigative approach to understanding and resolving complex data-related problems. · Analyse unexpected data behaviour, inconsistencies and extraction failures to establish root causes. · Challenge existing data extraction approaches and investigate alternative solutions where required. · Work independently to navigate unfamiliar Avaloq data structures and identify potential solutions. · Collaborate with Avaloq technical specialists, data architects and API teams to resolve complex issues. · Document findings, data dependencies and recommended remediation approaches.

SKILLS

Must have

• · Extensive hands-on experience with the Avaloq Core Banking platform. · Deep understanding of Avaloq's underlying data model, database architecture and data relationships. · Strong experience in data migration, data extraction and data transformation within Avaloq environments. · Advanced SQL and PL/SQL skills, with the ability to investigate and query complex banking data structures. · Experience identifying, analysing and resolving data quality and data integrity issues. · Understanding of how data is accessed, extracted and transferred from Avaloq to external systems. · Experience with data mapping, reconciliation and validation. · Understanding of system connectivity, interfaces and integration mechanisms. · Strong analytical and investigative problem-solving capabilities.

Nice to have

· Previous experience supporting Avaloq data migration or platform transformation programmes. · Exposure to API integration and enterprise data delivery architectures. · Understanding of REST APIs, JSON and XML. · Experience with API Management or middleware platforms. · Knowledge of banking and wealth management data, including client, account, portfolio and transaction structures. · Experience working with complex financial services data environments.