Advent APX/Tradex Tech Consultant - SQL, ETL&Reports

SupportFinity™

Saudi ArabiaSAR 16,667-25,000/moToday

Saudi ArabiaFinance & AccountingFull Time

Skills Required

SqlAzureExcelData AnalysisAccountingCommunication

Job Description

<h3>Advent Investment Applications Technical Consultant</h3>Jari Solutions |Jari Solutions | Posted Oct 16Full-timeRiyadh RegionNegotiableUnknownPosition 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 <ul><li>Advent APX&Tradex Administration:</li><li>Install, configure, and maintain Advent APX and Tradex applications.</li><li>Perform upgrades, patches, and technical enhancements.</li><li>Manage user access, system performance, and application tuning. </li></ul>Technical Support&Issue Resolution <ul><li>Provide day-to-day production support for Advent APX and Tradex systems.</li><li>Troubleshoot and resolve system or data-related issues.</li><li>Collaborate with Advent support and internal IT teams for escalations. </li></ul>Database Management <ul><li>Utilize Microsoft SQL Server for data extraction, validation, and optimization.</li><li>Perform query tuning, indexing, and performance monitoring.</li><li>Manage database jobs and data reconciliation processes. </li></ul>Reporting&Data Analysis <ul><li>Develop and maintain reports using SSRS.</li><li>Create complex T-SQL queries for reporting and data validation.</li><li>Support users with custom and ad-hoc reporting needs. </li></ul>Integration&Automation <ul><li>Design and maintain data integration pipelines using SSIS or custom scripts (.NET, PowerShell).</li><li>Implement and support FIX/API integrations with external systems such as Bloomberg, Reuters, and EMSX.</li><li>Ensure data consistency and automation across trading, accounting, and reporting platforms. </li></ul>Documentation&Governance <ul><li>Maintain technical documentation, configuration standards, and operational procedures.</li><li>Ensure compliance with IT governance, audit, and security controls. </li></ul>Required Skills&Qualifications <ul><li>5+ years of proven hands-on experience with Advent APX and Tradex (installation, administration, support, enhancement).</li><li>Strong knowledge of Microsoft SQL Server, including T-SQL scripting, indexing, and performance tuning.</li><li>Experience developing and maintaining reports in SSRS.</li><li>Working experience with ETL tools such as SSIS, or custom automation using .NET or PowerShell.</li><li>Familiarity with FIX protocol and API integrations (Bloomberg, Reuters, EMSX).</li><li>Excellent analytical, problem-solving, and communication skills.</li><li>Ability to collaborate effectively with investment operations, IT, and vendor teams. </li></ul>Preferred Qualifications <ul><li>Experience in the investment or asset management domain.</li><li>Knowledge of Advent system architecture and data models.</li><li>Exposure to Azure / cloud environments for hosting or integration.</li></ul></ul>About the companyJari SolutionsBe vigilant about potential scams, phishing attempts, or fraudulent activities, and seek credible sources or reviews to assess the trustworthiness of the company. Remember, your personal and financial security is paramount, and taking preventive measures is crucial to safeguarding your information from potential risks and unauthorized use. SupportFinity is not responsible for any consequences that may arise from disclosing such information to unauthorized or fraudulent entities.#J-18808-Ljbffr