Position Overview
We are hiring an Advent Investment Applications Technical Consultant for our client in the Investment domain in Riyadh. The ideal candidate will have deep hands-on expertise in Advent Portfolio Exchange (APX) and Tradex, with a strong technical foundation in SQL Server, ETL integrations, and reporting solutions.
This role involves supporting, enhancing, and integrating Advent systems within a complex investment environment, ensuring stability, performance, and seamless data connectivity across platforms.
Key Responsibilities
- Advent APX & Tradex Administration:
- Install, configure, and maintain Advent APX and Tradex applications.
- Perform upgrades, patches, and technical enhancements.
- Manage user access, system performance, and application tuning.
Technical Support & Issue Resolution
- Provide day-to-day production support for Advent APX and Tradex systems.
- Troubleshoot and resolve system or data-related issues.
- Collaborate with Advent support and internal IT teams for escalations.
Database Management
- Utilize Microsoft SQL Server for data extraction, validation, and optimization.
- Perform query tuning, indexing, and performance monitoring.
- Manage database jobs and data reconciliation processes.
Reporting & Data Analysis
- Develop and maintain reports using SSRS.
- Create complex T-SQL queries for reporting and data validation.
- Support users with custom and ad-hoc reporting needs.
Integration & Automation
- Design and maintain data integration pipelines using SSIS or custom scripts (.NET, PowerShell).
- Implement and support FIX/API integrations with external systems such as Bloomberg, Reuters, and EMSX.
- Ensure data consistency and automation across trading, accounting, and reporting platforms.
Documentation & Governance
- Maintain technical documentation, configuration standards, and operational procedures.
- Ensure compliance with IT governance, audit, and security controls.
Required Skills & Qualifications
- 5+ years of proven hands-on experience with Advent APX and Tradex (installation, administration, support, enhancement).
- Strong knowledge of Microsoft SQL Server, including T-SQL scripting, indexing, and performance tuning.
- Experience developing and maintaining reports in SSRS.
- Working experience with ETL tools such as SSIS, or custom automation using .NET or PowerShell.
- Familiarity with FIX protocol and API integrations (Bloomberg, Reuters, EMSX).
- Excellent analytical, problem-solving, and communication skills.
- Ability to collaborate effectively with investment operations, IT, and vendor teams.
Preferred Qualifications
- Experience in the investment or asset management domain.
- Knowledge of Advent system architecture and data models.
- Exposure to Azure / cloud environments for hosting or integration.
