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 rapid, 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

📌 Fund Services Assistant Vice President (Hyderabad)
🏢 Citco
📍 Hyderabad