Back to jobs

Senior Data & Reporting Engineer (SQL/Python/AWS)

Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Develop and execute database queries and conduct data analyses

  • Build and maintain an AI-powered knowledge base enabling natural language querying of credit agreements, amendments, and internal procedures

  • Create scripts to analyze and modify data, import/export scripts and execute stored procedures

From the employer’s posting
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
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
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

What you’ll bring

All qualifications

Core experience

  • 3+ Years in Financial Services / Financial Technology with a primary focus on loans/credit products
  • Familiarity with Docker and containerization concepts
  • Familiarity with AI agent orchestration tools such as AutoGen or CrewAI
  • Experience querying databases and strong programming skills: Python, SQL, PySpark etc.
  • Demonstrated proficiency in interpersonal and communication skills including oral and written English
  • Bachelor’s Degree in technology/related field or equivalent work experience

Preferred experience

  • Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential
Qualification wording
3+ Years in Financial Services / Financial Technology with a primary focus on loans/credit products
Familiarity with Docker and containerization concepts
Familiarity with AI agent orchestration tools such as AutoGen or CrewAI
Experience querying databases and strong programming skills: Python, SQL, PySpark etc.
Demonstrated proficiency in interpersonal and communication skills including oral and written English
Bachelor’s Degree in technology/related field or equivalent work experience
Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential
Education & alternatives
- 3+ 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 - 3+ Years of SQL and/or Python experience is a must

About fa-euxc-saasfaprod1

Citco is a global leader in fund services, corporate governance and related asset services with staff across 80 offices worldwide.

In the employer’s words · Read in context

Apply at fa-euxc-saasfaprod1

Posting record

Report an error

Actively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 2026today
Recorded sightings
1
Employer says posted
Nov 12, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 9 and day 59.

From 40,474 similar postings that came down. Coming down is not always a hire.

fa-euxc-saasfaprod1 is hiring

21 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • Azure
  • Databricks
  • Docker
  • Hive
  • Informatica
  • Oracle
  • PostgreSQL
  • Power BI
  • Qlik
  • S3
  • Snowflake
  • Spark
  • SQL Server
  • SSIS
  • Tableau
  • Talend
  • PySpark
Where the posting names them
Fund Services – Senior Data & Reporting Engineer (SQL/Python/AWS) - Loan Services Manila
- 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
- Bachelor’s Degree in technology/related field or equivalent work experience - 3+ Years of SQL and/or Python experience is a must - Strong knowledge of data concepts and tools and experienced in RDMS such as MS SQL Server, Oracle etc.
Previous 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 advatange
- Prior experience supporting ETL production environments & web technologies such as XML is an advatange - Previous 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 advantage - Experience with dashboard and reporting applications like Qlik, Tableau, Power BI
- 3+ Years of SQL and/or Python experience is a must - Strong 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 Warehousing
- Well-versed with concepts and techniques of Business Intelligence and Data Warehousing - Strong database designing and SQL skills. objects development, performance tuning and data analysis - In-depth understanding of database management systems, OLAP & ETL frameworks
- Familiarity or hands on experience working with REST or SOAP APIs - Well 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 Snowflake - Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage
- 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
- 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
- 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:
- Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential - Minimum 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 S3
- Implementing cloud storage using Amazon S3 - Serverless approaches using AWS Lambda (e.g., AWS SAM) - Configuring Amazon EC2 instances
- Familiarity with AI agent orchestration tools such as AutoGen or CrewAI - Understanding of document intelligence tools, e.g. AWS Textract, Azure Document Intelligence - Awareness of vector databases (e.g., Pinecone, pgvector) for knowledge base and semantic search
- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage - Hands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data factory) and associated data integration principles is an advantage - Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential
- Configuring Amazon EC2 instances - Azure Machine Learning services - Familiarity with Docker and containerization concepts
- Advantageous to have below experience with AI and emerging technologies: - Exposure to LLM frameworks such as LangChain, LlamaIndex, or OpenAI/Azure OpenAI APIs - Familiarity with AI agent orchestration tools such as AutoGen or CrewAI
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:
- 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:
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
- Azure Machine Learning services - Familiarity with Docker and containerization concepts - Exposure to CI/CD pipelines using Jenkins or GitHub Actions
- 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)
- 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
- Well 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 Snowflake - Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage - Hands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data factory) and associated data integration principles is an advantage
- Previous 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 advantage - Experience with dashboard and reporting applications like Qlik, Tableau, Power BI Other:
- Minimum 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 S3 - Serverless approaches using AWS Lambda (e.g., AWS SAM)

Your next step

Complete your application on fa-euxc-saasfaprod1.fa.ocs.oraclecloud.com. The employer’s form will show what is required.

Applying through Oracle Recruiting

  • Applying starts by asking for your email address.
  • Each employer sets which files it accepts, so read the note beside the upload field.

Already applied? Track this application

Has fa-euxc-saasfaprod1 posted this job before?

Yes. We’ve followed one other Senior Data & Reporting Engineer (SQL/Python/AWS) job there since November 2026. It is still up.

  1. ManilaStill up after 0 days, first seen Nov 18
  2. This jobUp 0 days so far, first seen Nov 18

Job description

View original posting ↗

Fund Services – Senior Data & Reporting Engineer (SQL/Python/AWS) - Loan Services

Manila

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

  • 3+ 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

  • 3+ Years of SQL and/or Python experience is a must

  • Strong 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 Warehousing 

  • Strong database designing and SQL skills. objects development, performance tuning and data analysis

  • In-depth understanding of database management systems, OLAP & ETL frameworks

  • Familiarity or hands on experience working with REST or SOAP APIs

  • Well 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 Snowflake

  • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage

  • Hands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data factory) and associated data integration principles is an advantage

  • Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential

  • Minimum 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 S3

    • Serverless approaches using AWS Lambda (e.g., AWS SAM)

    • Configuring Amazon EC2 instances

    • Azure Machine Learning services

    • Familiarity with Docker and containerization concepts

    • Exposure to CI/CD pipelines using Jenkins or GitHub Actions

  • Advantageous to have below experience with AI and emerging technologies:

    • Exposure to LLM 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, e.g. AWS Textract, Azure Document Intelligence

    • Awareness of vector databases (e.g., Pinecone, pgvector) for knowledge base and semantic search 

    • Understanding of AI governance principles, e.g. auditability, explainability, human-in-loop review

 

Previous 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 advatange

  • Previous 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 advantage

  • Experience with dashboard and reporting applications like Qlik, Tableau, Power BI

 

Other:

  • Well rounded individual possessing a high degree of initiative

  • Proactive person willing to accept responsibility with very little hand-holding

  • A strong analytical and logical mindset

  • Demonstrated proficiency in interpersonal and communication skills including oral and written English

  • Ability to learn new platforms and source information from numerous systems 

  • Ability to work in fast paced, complex Business & IT environments

  • Knowledge of Loan Servicing and/or Loan Administration

  • Understanding of Agile/Scrum methodology as it relates to the software development lifecycle

 

What We Offer:

  • A rewarding and challenging environment that spans multiple geographies and multiple business lines

  • Great working environment, competitive salary and benefits, and opportunities for educational support

  • Be part of an industry leading global organisation, renowned for excellence

  • Opportunities for personal and professional career development

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Manila, Philippines

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.