Senior Data & Reporting Engineer, SQL, Python, AWS

Jobtailor

Makati

On-site

PHP 900,000 - 1,500,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor in Metro Manila seeks a senior data professional to develop data pipelines, dashboards, and analytics across financial services platforms. You will design data models, implement ETL, and integrate APIs to streamline reporting and decision making.

Ideal candidates bring 5+ years in loans/credit sectors, strong SQL/Python skills, and hands-on BI tooling such as Power BI or Qlik, with cloud exposure on AWS or Azure. This is a full-time on-site role in Makati.

Qualifications

5+ years in Financial Services/FinTech 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 experience with RDMS such as MS SQL Server, Oracle.
BI and Data Warehousing concepts with practical ETL and data integration.
Experience with REST or SOAP APIs and cloud platforms (AWS/Azure).
Knowledge of BI tools like Power BI, Qlik; exposure to Snowflake is a plus.
Hands-on experience with ETL tools (SSIS, Informatica, Talend, Glue, Azure Data Factory).
Experience with various debt product types and Agile/Scrum methodologies.

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 end-to-end solutions.
Design/ build relational database schemas for analytics across data cube, data mart, data warehouse, and data lake.
Analyze, implement, and contribute to APIs to improve data integration pipelines.
Prepare data including cleaning, normalization, deduplication, and type conversion.
ETL data from various sources and integrate with cloud platforms (Azure/AWS).
Identify opportunities to improve processes and strategies with technology solutions.
Create tabular and matrix reports, dashboards in Power BI or QLIK; embed analytics in apps.

Skills

SQL

Python

ETL

Data Analysis

Database Design

Data Integration

APIs

Data Warehousing

Business Intelligence

Cloud Computing

Education

Bachelor's degree in technology/related field

Tools

Power BI

Qlik

AWS

Azure

SSIS

Informatica

Talend

Azure Data Factory

Snowflake

Oracle BI

Job description

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

Requirements

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

Core Competencies

Demonstrates expertise in SQL and Python for data analysis, database design, and ETL processes, with a strong focus on financial services and cloud technologies. Proficient in developing data pipelines, dashboards, and integrating APIs to enhance data management and reporting capabilities.

Highest-signal resume keywords