We are looking for a highly motivated Software Engineer to join our Output & Security team in the Platform Solution APAC & UK domain for our MNL office, with a specialized focus on data extraction using ACP (Avaloq Core Platform) and the generation of client-facing documents, such as advice and layout statements. This role is critical in ensuring that complex financial or operational data is accurately extracted, transformed, and presented in a clear, compliant, and client-friendly format.
Key Responsibilities
- Design, develop, and maintain PL/SQL stored procedures, functions, and packages to support data archiving, output management, and system integration requirements.
- Implement and maintain data archiving strategies to ensure long-term data accessibility, storage optimization, and compliance with retention requirements.
- Develop and maintain ETL processes for data migration, transformation, and integration across internal and external systems.
- Design, implement, and maintain data extraction pipelines using ACP to retrieve structured and unstructured data from internal systems.
- Develop and maintain automated processes for generating advice, reports, and layout statements for client communication management.
- Collaborate with business analysts, product owners, client service teams, and cross-functional technical teams to define output requirements and ensure alignment with business objectives.
- Ensure accurate, consistent, and timely delivery of client communications, including formatting, branding, localization, and data integrity.
- Optimize database and output generation performance through efficient query writing, indexing, scalability improvements, and maintainable design.
- Monitor, troubleshoot, and resolve database, ETL, ACP extraction, and output-related issues in a timely manner.
- Participate in code reviews and contribute to the continuous improvement of development standards, best practices, and technical documentation.
- Document technical specifications, workflows, processes, and best practices related to PL/SQL development, data archiving, ETL, ACP extraction, and output generation.
- Stay up to date with the latest trends, tools, and technologies in database management, data integration, and client communication management
