Data Engineering Analyst - Banking at VAM Systems

Manama, Capital, Bahrain -

Full Time

Start Date

Immediate

Expiry Date

25 Apr, 26

Salary

0.0

Posted On

25 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Scripting, Data Warehousing, Finance Knowledge, SAS DI, SAS EG, Slowly Changing Dimensions, Data Change Management, SQL Server Index Optimization, Data Partitioning, Data Integrity, ETL Processes, Financial Reporting, Risk Reporting, Balance Sheet Knowledge, Income Statement Interpretation

Industry

IT Services and IT Consulting

Description

Job Description VAM Systems is currently looking for Finance Data Engineering Analyst for our Bahrain operations with the following skillsets & terms and conditions: Qualifications : Bachelor’s Degree Engineer (B.E.)/ MCA Certification in SQL/SAS Experience: 5-8 years Must Have Strong SQL scripting experience Ideally in SQL Server. Strong Data Warehousing knowledge and experience. Good understanding of Finance in a Bank. Nice to SAS DI and SAS EG Experience required: Strong understanding of Slowly Changing Dimensions (SCD) and data change management, including hands-on experience with SCD Type 1 (data overwrite), Type 2 (historical record creation), and Type 3 (tracking previous attribute values through additional columns). Proficient in designing and optimizing SQL Server indexes to enhance query performance by enabling faster data retrieval through efficient lookup structures. Experienced in implementing data partitioning to divide large datasets into smaller, manageable segments, resulting in improved query performance, simplified maintenance, and efficient data archiving. Skilled in ensuring data integrity during ETL processes, particularly for financial transactions, by implementing checksums and row counts, applying transactional controls (commit/rollback), and validating data against source system totals. Strong understanding of Financial Reporting (Balance Sheet, Profit & Loss), Risk Reporting, and core banking domain concepts. Knowledgeable in Balance Sheet structure and components, including Assets (e.g., loans, investments, cash & reserves), Liabilities (e.g., customer deposits, inter-bank placements), and Equity (e.g., share capital, reserves). Well-versed in interpreting Income Statements/Profit & Loss (P&L) reports, including key components such as Interest Income, Interest Expense, and Operating Expense. Joining time frame: (15 - 30 days) The selected candidates shall join VAM Systems – Bahrain and shall be deputed to one of the leading banks in Bahrain.

Responsibilities

The Data Engineering Analyst will be responsible for managing financial data, ensuring data integrity during ETL processes, and optimizing SQL queries for performance. They will also work with financial reporting and risk reporting within the banking domain.