Job Description

Job Level: 7 – 10 years of relevant experience (L3)

Location: Philippines

Availability: Immediate to 2–3 weeks

Role Purpose:

Data SME to support a data engineering initiative built on Azure and Databricks. The ideal candidate has experience of SDLC and data warehouse, expertise in SQL/Python skills, awareness of common integration methods, and hands-on experience on a live data platform within a banking context.

Key Responsibilities:

Act as the subject matter expert for the data workstream during requirement analysis, design, build, and testing phases of the data engineering initiative.

Apply SDLC concepts to support requirement analysis, design, build, and testing activities for data workstreams

Support data warehouse design and development activities, including data modeling and data quality basics.

Work with Azure and Databricks components to support data pipeline build, testing, and troubleshooting.

Write and troubleshoot basic SQL and Python scripts for data validation, transformation, and analysis.

Support integration activities involving file transfer protocols (FTP/SFTP), MQ, and APIs between source and target systems.

Support source-to-target data mapping, migration validation, and reconciliation activities relevant to the data workstream.

Support SIT/UAT test planning and execution, triage data and integration defects, and drive resolution with the delivery teams.

Prepare and maintain data design and interface documentation, and drive review sign-off with upstream and downstream teams.

Manage stakeholders across business, technology, and vendor teams, and escalate risks/issues proactively.

Key Requirements:

7 to 10 years of overall IT experience, with hands-on experience on a live data platform.

Working knowledge of Azure and Databricks.

Experience of SQL and Python for data validation, transformation, and analysis.

Good understanding of data warehouse concepts (e.g., dimensional modeling, ETL/ELT basics).

Experience of SDLC phases: requirements, design, build, test, and deployment.

Working knowledge of integration, file transfer protocols (FTP/SFTP), MQ, and APIs.

Proven experience working as an individual contributor who can independently drive solutioning, documentation, and approvals; this is a hands-on role, not a purely supervisory one.

Good communication skills; comfortable presenting solution options to senior stakeholders and vendors. Should be in the Philippines for entire duration of the project.

Good to Have

Banking or financial services exposure.

Experience supporting data workstreams within a core banking transformation program.

Exposure to data quality frameworks, reconciliation controls, and data lineage.

Familiarity with Azure Data Factory, Azure Data Lake Storage, or Delta Lake.

Experience supporting production data pipelines, including monitoring and troubleshooting of job failures.

Technical Skills:

Cloud Platform: Microsoft Azure

Data Platform: Databricks

Languages: SQL, Python

Data Warehousing: Dimensional modeling, ETL/ELT basics, data modeling, data quality

Integration: FTP/SFTP, MQ, APIs