Data Engineering Analyst - Banking

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

• 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

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