Data & Reporting Solutions Architect (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

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.