VAM Systems is seeking a highly skilled Financial Data Warehousing Analyst to join our team in Bahrain. As a Financial Data Warehousing Analyst, you will be instrumental in developing and maintaining robust data warehousing solutions for one of the leading banks in Bahrain.

Responsibilities of a Financial Data Warehousing Analyst

• Develop and maintain data warehousing solutions using SQL Server.
• Design and implement Slowly Changing Dimensions (SCD) for data change management.
• Optimize SQL Server indexes for enhanced query performance.
• Implement data partitioning for improved data management.
• Ensure data integrity during ETL processes for financial transactions.
• Apply transactional controls (commit/rollback) and validate data against source system totals.
• Work with Financial Reporting (Balance Sheet, Profit & Loss), Risk Reporting, and core banking domain concepts.

Essential Skills for a Financial Data Warehousing Analyst

To succeed in this role, the Financial Data Warehousing Analyst must possess the following skills:

• Strong SQL scripting experience, ideally in SQL Server.
• Solid Data Warehousing knowledge and experience.
• Good understanding of Finance in a Bank.
• Experience with Slowly Changing Dimensions (SCD) and data change management.
• Proficiency in SQL Server index design and optimization.
• Experience in implementing data partitioning.
• Knowledge of Financial Reporting (Balance Sheet, Profit & Loss).

Additional Nice-to-Have Skills

• SAS DI and SAS EG experience are a plus.

Understanding Financial Data Warehousing Concepts

A key aspect of this role involves a strong grasp of financial reporting and core banking concepts. The successful Financial Data Warehousing Analyst will be knowledgeable in:

• Balance Sheet structure and components (Assets, Liabilities, Equity).
• Interpreting Income Statements/Profit & Loss (P&L) reports.
• Risk Reporting concepts.

We encourage you to learn more about data warehousing and its importance in the banking sector.

Joining timeframe: 15 – 30 days.

The selected candidates shall join VAM Systems – Bahrain and shall be deputed to one of the leading banks in Bahrain.

This position offers a unique opportunity to work on cutting-edge data warehousing projects within the finance sector. If you are a skilled Financial Data Warehousing Analyst with a passion for data and finance, we encourage you to apply.

Explore resources on cloud data warehousing to stay ahead in the field.