Senior Data Engineer -Azure / Databricks Platform (Corporate Banking)

avensys consulting pte. ltd.; Singapore; On-site; SGD 150,000 - 210,000; Full time

Job summary

Avensys Consulting Pte. Ltd. is seeking a Senior Data SME to lead data engineering initiatives on Azure and Databricks within a Corporate Banking context. You will own data solutions end-to-end on a live banking platform, with Trade, Lending, or Payments domain exposure as a strong plus.

The role demands 10+ years in data with deep Databricks and SQL/Python expertise, a strong SDLC background, and proficiency in data warehousing concepts and integration methods.

Qualifications

• 10+ years of experience in data with exposure to Corporate Banking.
• Deep experience in data mapping, Databricks platform, pipeline development and performance tuning.
• Strong SDLC experience across requirements, design, build, test and deployment.
• Solid understanding of data warehouse concepts (dimensional modeling, ETL/ELT).
• Proficient with Azure and Databricks.
• Strong SQL and Python hands-on skills.
• Experience with integration methods: FTP/SFTP, MQ, APIs.

Responsibilities

• Lead requirement analysis, design, build and testing for data workstreams.
• Own data warehouse design and data mapping, ensuring quality and sign-off.
• Design, build and optimize pipelines on Azure and Databricks, with performance tuning.
• Define source-to-target data mappings with traceability across components.
• Write and troubleshoot SQL and Python scripts for validation and transformation.
• Drive integration design using FTP/SFTP, MQ and APIs between systems.
• Apply Corporate Banking context to data solutions, flagging domain considerations.

Skills

Databricks

Azure

SQL

Python

Data mapping

Data warehousing

SDLC

ETL/ELT

APIs

Banking domain

Tools

Azure Databricks

FTP/SFTP

MQ

APIs

Job description

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.

We are looking for a Senior Data SME to support a data engineering initiative built on Azure and Databricks within a Corporate Banking context. The ideal candidate brings deep, hands-on technical experience in data mapping and the Databricks platform, strong SDLC and data warehouse fundamentals, and is comfortable owning data solutions end-to-end on a live banking data platform. Trade, Lending, or Payments domain exposure is a strong plus

Requirements :

• At least 10 years of experience in the data space, with exposure to Corporate Banking.
• Technically strong in data mapping (source-to-target) and the Databricks platform — pipeline development, job/cluster management, and performance tuning.
• Strong experience across SDLC phases: requirements, design, build, test, and deployment.
• Strong understanding of data warehouse concepts (e.g., dimensional modeling, ETL/ELT).
• Strong working knowledge of Azure and Databricks.
• Strong hands-on SQL and Python skills.
• Working knowledge of integration methods: file transfer protocols (FTP/SFTP), MQ, and APIs.

Key Responsibilities:

• Apply SDLC concepts to lead requirement analysis, design, build, and testing activities for data workstreams.
• Own data warehouse design and data mapping activities, including data modeling and data quality standards.
• Design, build, and optimize data pipelines on Azure and Databricks, including performance tuning and troubleshooting.
• Design and own source-to-target data mapping specifications across platform components, ensuring traceability and sign-off.
• Write and troubleshoot advanced SQL and Python scripts for data validation, transformation, and analysis.
• Drive integration design and delivery involving file transfer protocols (FTP/SFTP), MQ, and APIs between source and target systems.
• Bring Corporate Banking context to data solutioning, flagging domain-specific considerations (e.g., Trade, Lending, or Payments data) where relevant.

WHAT’S ON OFFER

You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.

Your interest will be treated with strict confidentiality.