Data Engineer - Data Warehousing at VAM Systems

Manama, Capital, Bahrain -

Full Time

Start Date

Immediate

Expiry Date

27 Jun, 26

Salary

0.0

Posted On

29 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Sql Scripting, Data Warehousing, Sql Server, Slowly Changing Dimensions, Scd Type 1, Scd Type 2, Scd Type 3, Index Optimization, Data Partitioning, Data Integrity, Etl, Financial Reporting, Risk Reporting, Core Banking, Sas Di, Sas Eg

Industry

IT Services and IT Consulting

Description

Job Description VAM Systems is currently looking for Data Engineer - Data Warehousing 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)

Responsibilities

The role involves strong SQL scripting and Data Warehousing expertise, focusing on designing and optimizing database structures within a financial banking context. Key responsibilities include implementing data change management techniques like SCDs and ensuring data integrity during ETL processes for financial transactions.