Fund Services – Assistant Vice President - Loan Services, Data & Reporting (SQL/Python/AWS)

Fund Services – Assistant Vice President - Loan Services, Data & Reporting (SQL/Python/AWS)

Telangana, India (Hybrid)

TRENDING

JOB DESCRIPTION

About Citco

Citco is a global leader in fund services, corporate governance and related asset services with staff across 80 offices worldwide. With more than $1.7 trillion in assets under administration, we deliver end-to-end solutions and exceptional service to meet our clients’ needs. For more information about Citco, please visit www.citco.com

About the Team & Business Line

Citco Fund Services is a division of the Citco Group of Companies and is the largest independent administrator of Hedge Funds in the world. Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience. This position reports in to the Loan Services Business Line

As a core member of our Loan Services Data and Reporting team, you will be working with some of the industry’s most accomplished professionals to deliver award-winning services for complex fund structures that our clients can depend upon.

The team is at the forefront of a significant transformation in how Citco delivers credit services. We are building a unified, single-point-of-entry portal for all loan data and credit products — and driving an ambitious AI roadmap that spans intelligent data ingestion, agentic workflow automation, reconciliation, and client-facing AI tools. Team members work across the full stack: from data modelling and backend API development to AI agent prototyping and cloud deployment, using tools including Amazon Q, Kiro, Claude, Docker, Jenkins, Databricks, and PostgreSQL.

Job Duties in Brief

Your Role

Data and Reporting

• Support daily operational workflows and asset servicing from a data and reporting perspective – facilitate Ops in ensuring completeness and accuracy of position, accruals and cash data in loan/accounting systems
• Develop and execute database queries and conduct data analyses
• Create scripts to analyze and modify data, import/export scripts and execute stored procedures
• Model data by writing SQL queries/Python codes to support data integration and dashboard requirements
• Develop data pipelines that provide fast, optimized, and robust end-to-end solutions
• Leverage and contribute to design/building relational database schemas for analytics. Handle and manipulate data in various structures and repositories (data cube, data mart, data warehouse, data lake)
• Analyze, implement and contribute to building of APIs to improve data integration pipeline
• Perform data preparation tasks including data cleaning, normalization, deduplication, type conversion etc.
• Perform data integration through extracting, transforming and loading (ETL) data from various sources.
• Identify opportunities to improve processes and strategies with technology solutions and identify development needs in order to improve and streamline operations
• Create parameterized reports, visual reports/dashbords in a reporting application such as Power BI or QLIK
• Integrating PBI/QLIK reports into other applications using embedded analytics like Power BI service (SaaS)
• Building and Designing cloud applications using Microsoft Azure/AWS cloud technologies

Web Application Development, Backend Architecture & Data Integration

• Contribute to the design, development, and evolution of the Citco Credit Portal — a client-facing web application serving borrowers, lenders, fund clients, and internal Citco teams
• Design and maintain the PostgreSQL/Databricks backend data models that power the portal, ensuring they are system-agnostic and capable of integrating data from multiple source systems (Sentry, Investran etc.)
• Build and maintain REST APIs that serve portal front-end features including portfolio views, loan details, borrower/lender data, document management, self-service reporting, and workflow modules
• Collaborate with UI/UX, DevOps, and product teams to ship portal features across a quarterly roadmap
• Integrate proprietary and external third-party platforms (PowerBI, Databricks) into the portal architecture

AI & Agentic Workflow Development

• Rapidly prototype and productionize AI-powered tools and agents that automate operational workflows across loan servicing and loan operations
• Develop AI agents for a broad range of use cases including (but not limited to): automated credit agreement data extraction, lifecycle event and settlement processing, reconciliation break identification and routing, complex accrual calculations, invoice/notice generation, and covenant tracking
• Build and maintain an AI-powered knowledge base enabling natural language querying of credit agreements, amendments, and internal procedures
• Implement LLM-based document parsing pipelines to extract structured data from unstructured sources — PDFs, emails, spreadsheets, XML — and stage for straight-through processing into downstream systems
• Apply AI supervisory layers over existing data controls to add interpretive context — distinguishing timing differences from genuine errors, and routing only actionable exceptions to operations teams
• Ensure all AI-generated outputs in critical workflows have defined human review processes, auditability, and explainability in line with regulatory and compliance requirements

DevOps / Cloud / Deployment

• Containerise and deploy applications and AI tools using Docker and Jenkins CI/CD pipelines
• Productionise prototypes on AWS, leveraging services including S3, Lambda, EC2, and managed services
• Contribute to cloud cost, performance, and security optimisation across the team's AWS footprint

About You

Background / Qualifications

• 5+ Years in Financial Services / Financial Technology with a primary focus on loans/credit products
• Bachelor’s Degree in technology/related field or equivalent work experience
• 4+ Y