Vice President - Loan Services, Data & Reporting

About CitcoThe market leader. The premier provider. The best in the business. At Citco, we’ve been the front-runner in our field since our incorporation in 1948 led to the evolution of the asset servicing sector itself. This pioneering spirit continues to guide us today as we innovate and expand, push beyond the boundaries of our industry, and shape its future. From working exclusively with hedge funds to serving all alternatives, corporations and private clients, our organization has grown immensely across asset classes and geographies. For us, this progress is a pattern that we’ll only maintain as we move forward, always prioritizing our performance. So for those who want to play at the top of their game and be at the vanguard of their space, we say: Welcome to Citco.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 LineAs 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.Job Duties in Brief:Your Role:Understand the role of Loan Services in generating reporting in support of NAV & Loan Servicing processes and actively liaise with various internal teams to meet monthly/quarterly NAV & Loan Servicing deliverablesSupport 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 systemsDevelop and execute database queries and conduct data analysesCreate scripts to analyze and modify data, import/export scripts and execute stored proceduresModel data by writing SQL queries/Python codes to support data integration and dashboard requirementsDevelop data pipelines that provide fast, optimized, and robust end-to-end solutionsLeverage 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 pipelinePerform 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 operationsCreate tabular reports, matrix reports, parameterized reports, visual reports/dashbords in a reporting application such as Power BI Desktop/Cloud or QLIKIntegrating PBI/QLIK reports into other applications using embedded analytics like Power BI service (SaaS)Building and Designing cloud applications using Microsoft Azure/AWS cloud technologiesAbout You:Background / Qualifications8+ Years in Financial Services / Financial Technology with a primary focus on loans/credit productsExperience of a range of debt product types including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans, total return swaps, letters of creditBachelor’s Degree in technology/related field or equivalent work experience4+ Years of SQL and/or Python experience is a mustStrong knowledge of data concepts and tools and experienced in RDMS such as MS SQL Server, Oracle etc.Well-versed with concepts and techniques of Business Intelligence and Data WarehousingStrong database designing and SQL skills. objects development, performance tuning and data analysisIn-depth understanding of database management systems, OLAP & ETL frameworksFamiliarity or hands on experience working with REST or SOAP APIsWell versed with concepts for API Management and Integration with various data sources in cloud platforms, to help with connecting to traditional SQL and new age data sources, such as SnowflakeFamiliarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantageHands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data factory) and associated data integration principles is an advantageMinimum 1+ year experience with Cloud platform technologies (AWS/Azure), including Azure Machine Learning is desirable. Following AWS experience is a plus:Implementing cloud storage using Amazon Simple Storage Service (S3)Experience with serverless approaches using AWS Lambda, e.g. AWS (SAM)Configuring Amazon Elastic Compute Cloud (EC2) InstancesPrevious Work Experience:Experience querying databases and strong programming skills: Python, SQL, PySpark etc.Prior experience supporting ETL production environments & web technologies such as XML is an advantagePrevious working experience on Azure Data Services including ADF, ADLS, Blob, Data Bricks, Hive, Python, Spark and/or features of Azure ML Studio, ML Services and ML Ops is an advantageExperience with dashboard and reporting applications like Qlik, Tableau, Power BIOther:Well rounded individual possessing a high degree of initiativeProactive person willing to accept responsibility with very little hand-holdingA strong analytical and logical mindsetDemonstrated proficiency in interpersonal and communication skills including oral and written EnglishAbility to learn new platforms and source information from numerous systemsAbility to work in fast paced, complex Business & IT environmentsKnowledge of Loan Servicing and/or Loan AdministrationUnderstanding of Agile/Scrum methodology as it relates to the software development lifecycleWhat We Offer:A rewarding and challenging environment that spans multiple geographies and multiple business linesGreat working environment, competitive salary and benefits, and opportunities for educational supportBe part of an industry leading global organisation, renowned for excellenceOpportunities for personal and professional career developmentOur BenefitsYour well-being is of paramount importance and central to our success here at Citco. Citco offers a comprehensive and competitive total rewards package to support your career success and personal needs. Your base salary will be determined by several factors such as the role, experience, skillset, market conditions, etc. Furthermore, qualifying positions can participate in an annual discretionary bonus pool based on company profitability and individual contributions. Our comprehensive benefits package includes medical, dental, and vision coverage, short and long-term disability benefits, a retirement savings plan, tuition reimbursement, mental health and wellness support, parental leave, and more. Additional details about our total rewards package will be shared during the hiring process.At Citco, we take pride in fostering an inclusive culture by prioritizing the hiring of people from diverse backgrounds. Our culture is a source of pride and strength, fostering innovation, mutual respect, and collaboration. We warmly welcome and encourage applications from people with disabilities. If you require any accommodations to make our recruitment process more accessible for you, please let your recruiter know.As an equal opportunity employer, Citco adheres to making all employment and personnel decisions without discriminating based on race, color, creed, religion, sex, physical disability, mental disability, age, marital status, sexual orientation, citizenship status, national or ethnic origin, or any other protected status. We believe that an inclusive workforce not only enriches our company but also drives us towards greater success.Please note that this job description is not intended to be all-inclusive. Our employees may perform other job-related duties as needed to meet the ongoing needs of our organization.#LI-MY1 #J-18808-Ljbffr

Created: 2025-09-17