Senior Data Solutions Engineer - SQL, ETL & BI

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

Benefits offered by this job

Flexible working arrangements

Training support

Disability accommodations

Diversity & inclusion

Job summary

Citco seeks a Senior Data & Analytics Engineer in Manila to join its Loan Services Data and Reporting team. You will develop data pipelines, write SQL and Python queries, and build dashboards with Power BI/QLIK to support loan servicing analytics.

You will work with cloud technologies (Azure/AWS), APIs, and various data stores (data warehouse/lake). A strong BI/ETL background and financial services experience are required.

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.

Responsibilities

• 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.
• 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 ETL from various sources.
• Identify opportunities to improve processes and strategies with technology solutions and identify development needs 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.
• Integrate 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

Skills

SQL

Python

Data analysis

BI/ dashboards

REST APIs

SOAP APIs

Cloud platforms

Power BI

Qlik

Tableau

Spark

Hive

Education

Bachelor's Degree in technology/related field

Tools

MS SQL Server

Oracle

Azure Data Factory

Azure Data Lake

Data Bricks

Snowflake

Power BI

Qlik

Tableau

Job description

Citco seeks a Senior Data & Analytics Engineer in Manila to join its Loan Services Data and Reporting team. You will develop data pipelines, write SQL and Python queries, and build dashboards with Power BI/QLIK to support loan servicing analytics.

You will work with cloud technologies (Azure/AWS), APIs, and various data stores (data warehouse/lake). A strong BI/ETL background and financial services experience are required.