Funds and Accounting Data Testing Specialist

Funds & Accounting Data Tester | Advent Geneva, Reconciliation, Regulatory Compliance & Automation Expertise

Job Summary
Synechron is seeking a highly skilled RSL Specialist with extensive experience in Advent Geneva to lead the design, development, and optimization of complex reporting and data integration layers. This role serves as a technical bridge between fund accounting requirements and their implementation, utilizing Report Scripting Language (RSL) to deliver accurate, reliable, and regulatory-compliant financial reports. The expert will collaborate closely with fund accountants, portfolio managers, and cross-functional teams to support enterprise data flows, system performance, and operational efficiency.

Software Requirements

Required Software Proficiency:

• Advent Geneva (version 15.0 or higher) — deep expertise in report development, system architecture, and data integration (5–8 years of experience)

• Report Scripting Language (RSL) — advanced proficiency in writing, troubleshooting, and optimizing reports

• SQL (T-SQL or PL/SQL) — strong command for data validation, reconciliation, and database queries

• SSRS (SQL Server Reporting Services) — experience in designing and managing enterprise reports supporting fund accounting

• Unix/Linux commands and shell scripting (Bash/Korn) — strong experience automating processes and managing backend environments

• Data loading and extraction tools: Geneva Loaders, RSL extractors, AGA (Advent Geneva Advantage) — comprehensive knowledge of data extract and load procedures

Preferred Software Skills:

• Version control tools: Git, Bitbucket — support for code management and versioning

• Automation and scripting: PowerShell, Python — optional enhancement for automation support

• Cloud environments supporting Geneva (supports, but not mandatory)

Overall Responsibilities

• Lead the design, development, and maintenance of complex RSL scripts for fund reporting (P&L, Trial Balance, regulatory reports) including data validation, reconciliation, and extracts

• Develop and optimize data integration components such as Geneva Loaders, AGA, and extractors to ensure seamless data flow across systems

• Collaborate with fund accountants, data teams, and technical stakeholders to translate financial requirements into effective reports and data solutions

• Conduct impact assessments, feasibility analysis, and solution assessments for system upgrades and migrations

• Manage end-to-end testing of reports, data loads, and system interfaces, ensuring accuracy and compliance with scheme rules (Visa, Mastercard, etc.)

• Troubleshoot and resolve complex report errors, performance bottlenecks, or data discrepancies quickly and effectively

• Support system and process automation through scripting, job scheduling, and optimized workflows

• Maintain comprehensive documentation of report designs, data flows, configuration settings, and operational procedures

• Support compliance, audit activities, and regulatory reporting standards such as PCI DSS and industry-specific guidelines

• Drive continuous improvement processes, automation, and best practices for report development and data integration

Technical Skills (By Category)

• Languages & Data Extraction Tools (Essential):

  • RSL: expert-level proficiency in writing, debugging, and optimizing complex reports and extractors

  • SQL (T-SQL, PL/SQL): strong query writing, data validation, and reconciliation skills

  • Shell scripting (Bash/Korn): automation of routine tasks and backend processes

• Databases & Data Management:

  • Advent Geneva system, supporting schema design, data extraction, and reconciliation workflows

  • Data validation and migration support for fund master data, transaction details, and balances

• System & Messaging Standards:

  • Knowledge of schema rules supporting scheme compliance (Visa, Mastercard)

  • Experience validating and supporting messaging flows such as ISO 8583, ISO 20022, or similar standards

• Automation & Job Scheduling:

  • Geneva Loaders, AGA (Advent Geneva Advantage), job scheduling tools supporting batch and real-time data loads

• Version Control/Deployment:

  • Git, Bitbucket — for code management, change tracking, and collaborative development support

• Security & Regulatory Compliance:

  • Understanding of data security, encryption, user access controls, and audit trails supporting financial industry standards

Experience Requirements

• 5–8 years supporting fund accounting, financial systems, or enterprise data management in investment or banking environments

• Proven experience designing, developing, and deploying complex reports and data integration workflows in Advent Geneva systems

• Hands-on support of scheme compliance, scheme simulator validation, and financial data reconciliation

• Experience supporting large fund portfolios, reconciliation, and regulatory reporting cycles

• Alternative pathways include extensive experience supporting financial data systems with a focus on transaction processing and regulatory standards

Day-to-Day Activities

• Develop, test, and support complex RSL scripts for fund reports and data extracts supporting P&L, TB, and regulatory submissions

• Manage and optimize data loads using Geneva Loaders, AGA, and extractors, improving throughput and accuracy

• Troubleshoot and resolve report generation issues, data discrepancies, and system errors efficiently

• Collaborate with fund accountants, data architects, and technical teams to refine reporting processes and data flows

• Support system upgrades, schema migrations, and compliance audits

• Conduct impact analysis and feasibility assessments for new system features or upgrades

• Document report designs, data flows, and operational procedures for audit and support readiness

• Lead root-cause analysis for report errors, data mismatches, or system performance issues

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Finance, Information Technology, or related fields

• 5+ years of experience supporting or developing reports and data integration for fund accounting or financial systems, preferably working with Advent Geneva systems

• Certifications related to fund accounting systems or enterprise reporting (preferred)

• Proven expertise supporting large portfolio transaction data, regulatory reporting, and compliance standards

Professional Competencies

• Strong analytical and troubleshooting skills for complex fund data and report issues

• Leadership abilities to guide junior team members and coordinate testing activities

• Effective communication to liaise with fund accountants, compliance, and technical teams

• Adaptability to evolving regulatory requirements and system upgrades

• Focus on data accuracy, security, and process improvement

• Time management and organizational skills to handle multiple reporting cycles and system changes efficiently

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

Experience Level

Senior Level