Senior Business Solution Specialist II - Data & Reporting (SQL/Python/AWS)

CITCO INTERNATIONAL SUPPORT SERVICES LIMITED-PHILIPPINE ROHQ; Makati; On-site; PHP 1,200,000 - 2,400,000; Full time

Job summary

Citco, a global leader in asset servicing, seeks a seasoned Data & Reporting professional in Metro Manila. You will develop queries, pipelines, and dashboards using SQL, Python, Power BI, and QLIK, integrating data across cloud platforms (Azure/AWS) for loan services analytics.

Strong experience in financial services, ETL, data warehousing, and API integrations is required. The role offers growth within Citco's Loan Services Data & Reporting team.

Qualifications

• Bachelor's degree in technology/related field or equivalent work experience.
• 5+ years in financial services/fintech with a focus on loans/credit products.
• 4+ years SQL and/or Python experience.
• Strong knowledge of data concepts, RDMS (MS SQL Server, Oracle).
• BI and Data Warehousing concepts; API knowledge (REST/SOAP).

Responsibilities

• Develop and execute database queries and conduct data analyses.
• Create scripts to analyze and modify data, import/export scripts and stored procedures.
• Model data with SQL/Python to support data integration and dashboards.
• Develop data pipelines for fast, robust end-to-end solutions.
• Design relational schemas for analytics and manage diverse data structures.
• Develop APIs to improve data integration pipelines.
• Prepare data: cleaning, normalization, deduplication, type conversion.
• ETL data from various sources and integrate into analytics platforms.
• Create tabular/matrix/parameterized reports in Power BI or QLIK.
• Embed and integrate PBI/QLIK reports into other apps.
• Build cloud apps using Azure/AWS cloud technologies.

Skills

SQL

Python

Power BI

Qlik

ETL

Data Modeling

Azure

AWS

REST APIs

Snowflake

Education

Bachelor's degree in technology/related field

Tools

MS SQL Server

Oracle

SSIS

Informatica

Talend

Azure Data Factory

Snowflake

Job description

Job Description

About Citco:

The 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 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.

Responsibilities

Your Role:

• 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 tabular reports, matrix reports, parameterized reports, visual reports/dashboards in a reporting application such as Power BI Desktop/Cloud 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

Qualifications

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+ 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 Simple Storage Service (S3)
  • Experience with serverless approaches using AWS Lambda, e.g. AWS (SAM)
  • Configuring Amazon Elastic Compute Cloud (EC2) Instances

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 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:

• 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

Our Benefits

Your well-being is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We embrace diversity, prioritizing the hiring of people from diverse backgrounds. Our inclusive culture is a source of pride and strength, fostering innovation and mutual respect.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.