C

Citco

Global administrator and adviser for funds

Fund Services - Multiple Teams

Data EngineeringConfirmed live in the last 24 hours
Full-timeTelangana, IndiaNo salary listedIn-person

About the Job

Requirements

  • At least 5 years of experience in financial services or financial technology, primarily focused on loans or credit products.
  • A bachelor's degree in technology or a related field, or equivalent work experience.
  • At least 4 years of SQL and/or Python experience.
  • Strong knowledge of data concepts and tools, with experience in relational database management systems such as Microsoft SQL Server or Oracle.
  • Knowledge of business intelligence and data warehousing concepts and techniques.
  • Strong database design and SQL skills, including object development, performance tuning, and data analysis.
  • In-depth understanding of database management systems, online analytical processing, and extract, transform, and load frameworks.
  • Familiarity or hands-on experience with REST or SOAP application programming interfaces.
  • Knowledge of API management and integration with various data sources in cloud platforms, including traditional SQL and newer data sources such as Snowflake.
  • Ability to communicate orally and in writing in English.
  • Knowledge of loan servicing and/or loan administration.
  • Understanding of Agile/Scrum methodology as it relates to the software development lifecycle.

Responsibilities

  • Support daily operational workflows and asset servicing from a data and reporting perspective, facilitating operations in ensuring completeness and accuracy of position, accrual, and cash data in loan and accounting systems.
  • Develop and execute database queries and conduct data analyses.
  • Create scripts to analyze and modify data, import and export data, and execute stored procedures.
  • Model data by writing SQL queries and Python code to support data integration and dashboard requirements.
  • Develop fast, optimized, and robust end-to-end data pipelines.
  • Contribute to the design and development of relational database schemas for analytics, and handle and manipulate data in data cubes, data marts, data warehouses, and data lakes.
  • Analyze, implement, and contribute to APIs that improve data integration pipelines.
  • Perform data preparation, including cleaning, normalization, deduplication, and type conversion.
  • Integrate data from various sources using extract, transform, and load processes.
  • Identify opportunities to improve processes and strategies with technology solutions and identify development needs to streamline operations.
  • Create parameterized and visual reports or dashboards in reporting applications such as Power BI or Qlik.
  • Integrate Power BI or Qlik reports into other applications using embedded analytics such as Power BI service.
  • Build and design cloud applications using Microsoft Azure or AWS cloud technologies.
  • Contribute to the design, development, and evolution of the Citco Credit Portal, a client-facing web application for borrowers, lenders, fund clients, and internal teams.
  • Design and maintain PostgreSQL and Databricks backend data models for the portal, ensuring they are system-agnostic and can integrate data from multiple source systems such as Sentry and Investran.
  • Build and maintain REST APIs for portal features, including portfolio views, loan details, borrower and lender data, document management, self-service reporting, and workflow modules.
  • Collaborate with UI/UX, DevOps, and product teams to deliver portal features across a quarterly roadmap.
  • Integrate proprietary and external third-party platforms, including Power BI and Databricks, into the portal architecture.
  • Prototype and productionize AI-powered tools and agents to automate operational workflows across loan servicing and loan operations.
  • Develop AI agents for use cases including automated credit agreement data extraction, lifecycle event and settlement processing, reconciliation break identification and routing, complex accrual calculations, invoice and notice generation, and covenant tracking.
  • Build and maintain an AI-powered knowledge base for natural language querying of credit agreements, amendments, and internal procedures.
  • Implement large language model-based document parsing pipelines to extract structured data from PDFs, emails, spreadsheets, and XML, and stage it for straight-through processing into downstream systems.
  • Apply AI supervisory layers over existing data controls to distinguish timing differences from genuine errors and route actionable exceptions to operations teams.
  • Ensure AI-generated outputs in critical workflows have defined human review processes, auditability, and explainability in line with regulatory and compliance requirements.
  • Containerize and deploy applications and AI tools using Docker and Jenkins CI/CD pipelines.
  • Productionize prototypes on AWS, leveraging services including S3, Lambda, EC2, and managed services.
  • Contribute to cloud cost, performance, and security optimization across the team's AWS footprint.

Desired Qualifications

  • Experience with business intelligence technologies such as Microsoft Power BI or Oracle BI.
  • Hands-on experience with at least one ETL tool, such as SSIS, Informatica, Talend, AWS Glue, or Azure Data Factory, and associated data integration principles.
  • Experience with debt products such as syndicated loans (par and distressed), bilateral loans, direct lending originations, and commercial real estate loans.
  • At least 1 year of experience with cloud platform technologies (AWS/Azure), including Azure Machine Learning.
  • Experience implementing cloud storage using Amazon S3.
  • Experience with serverless approaches using AWS Lambda, such as AWS SAM.
  • Experience configuring Amazon EC2 instances.
  • Experience with Azure Machine Learning services.
  • Familiarity with Docker and containerization concepts.
  • Exposure to CI/CD pipelines using Jenkins or GitHub Actions.
  • Exposure to large language model frameworks such as LangChain, LlamaIndex, or OpenAI/Azure OpenAI APIs.
  • Familiarity with AI agent orchestration tools such as AutoGen or CrewAI.
  • Understanding of document intelligence tools such as AWS Textract or Azure Document Intelligence.
  • Awareness of vector databases such as Pinecone or pgvector for knowledge bases and semantic search.
  • Understanding of AI governance principles such as auditability, explainability, and human-in-the-loop review.
  • Experience querying databases and programming with Python, SQL, or PySpark.
  • Prior experience supporting ETL production environments and web technologies such as XML.
  • Experience with Azure Data Services, including Azure Data Factory, Azure Data Lake Storage, Blob Storage, Databricks, Hive, Python, Spark, Azure Machine Learning Studio, Machine Learning Services, or MLOps.
  • Experience with dashboard and reporting applications such as Qlik, Tableau, or Power BI.

About the Company

Citco

Global administrator and adviser for funds

Citco provides professional financial services for the alternative investment industry and related areas, including fund administration, fund accounting, NAV calculations, investor relations, governance services, and banking and custody. It delivers these services through a global network and proprietary technology across divisions such as Citco Fund Services & Investor Relations, Governance Services, Banking, Depositary & Custody, and Citco Technology Management. Citco differentiates itself by its size, long heritage, global coverage, and in-house technology development that supports secure, scalable administration. Its goal is to be a trusted advisor and the leading service provider in financial and professional services, helping clients navigate markets and make informed decisions.

Company size
10,001+
Company stage
Not listed
Total funding
Not listed
Headquarters
Cayman Islands
Founded
1998

Recently Posted Jobs

Explore more opportunities at Citco

See more jobs