Senior Data & Reporting Engineer: SQL, Python & Cloud Analytics

CITCO INTERNATIONAL SUPPORT SERVICES LIMITED-PHILIPPINE ROHQ; Manila; On-site; PHP 900,000 - 1,800,000; Full time

Benefits offered by this job

Flexible working arrangements

Training and education support

Disability accommodations

Job summary

Citco is seeking a data & analytics professional to join the Loan Services Data and Reporting team. You will develop data queries, build analytics pipelines, and design scalable data models to support dashboards and reporting across loan products.

Required are 4+ years in data services, strong SQL/Python skills, and experience with MS SQL Server, Oracle, and BI tools like Power BI, Qlik, or Tableau. Cloud experience (Azure/AWS) and ETL proficiency are key assets.

Qualifications

• Bachelor’s degree in technology or a related field.
• Minimum 4+ years of SQL and/or Python experience.
• Experience with RDMS (MS SQL Server, Oracle) and data warehousing concepts.
• Strong knowledge of BI tools (Power BI, Qlik, Tableau) and data visualization.
• Hands-on experience with ETL tools (SSIS, Informatica, Talend, Glue, Azure Data Factory).
• Familiarity with REST/SOAP APIs and cloud data integrations (AWS/Azure).
• Experience with cloud platforms and serverless approaches is desirable.

Responsibilities

• Develop and execute database queries and data analyses.
• Create scripts to analyze and modify data and to support ETL processes.
• Model data and build data pipelines for analytics and dashboards.
• Design and optimize relational database schemas for analytics.
• Integrate PBI/QLIK reports into applications via embedded analytics.
• Build APIs to improve data integration pipelines.
• Prepare data through cleaning, normalization, and deduplication.
• Work with cloud tech (Azure/AWS) for data solutions.

Skills

SQL

Python

Data analysis

BI concepts

Data warehousing

API knowledge

ETL

REST APIs

SOAP APIs

Education

Bachelor’s Degree in technology/related field

Tools

MS SQL Server

Oracle

Power BI

Qlik

Tableau

SSIS

Informatica

Talend

Azure Data Factory

Azure ML

Job description

Citco is seeking a data & analytics professional to join the Loan Services Data and Reporting team. You will develop data queries, build analytics pipelines, and design scalable data models to support dashboards and reporting across loan products.

Required are 4+ years in data services, strong SQL/Python skills, and experience with MS SQL Server, Oracle, and BI tools like Power BI, Qlik, or Tableau. Cloud experience (Azure/AWS) and ETL proficiency are key assets.