Data SME

Avensys Consulting is an expert in providing technology-enabled business solutions and services. Since inception, Avensys Consulting has helped clients Cyber-security, Data Analytics and Robotic Process Automation to improve their operations and profitability, focus on core competencies and achieve business results such as increased agility, innovation and profitable growth. Our in-depth technical knowledge, industry experience, and unique methodologies enable us to successfully deliver and meet our customer’s expectations.

We are currently looking to hire a Data SME. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance. More details as below.

Job Description:

Role Summary :

About the Role

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.

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.

Required Skills & Experience

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

Good to Have

• Trade, Lending, or Payments domain exposure.

• Prior experience on a core banking or banking transformation program.

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.

To submit your application, please apply online or submit your CV to [email protected], Your interest will be treated with strict confidentiality.

CONSULTANT DETAILS

Consultant Name : Sandeep Kumar

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.