Business Analyst (DWH & BI)

We are seeking an experienced Business Analyst with deep expertise in Data Warehousing and Business Intelligence, specializing in Teradata technologies within a banking authority or central bank environment.

This role requires someone who understands both the technical landscape of enterprise data warehousing and the regulatory mandate of a banking authority such as SAMA, CBUAE, CBK, or equivalent central banks.

This is a fully on-site position in Riyadh, and it is a 6-month extendable contract.

Responsibilities:

• Elicit, document, and validate business requirements from departments across the banking authority, including Supervision, Financial Stability, Statistics, Monetary Policy, Payments, and AML/CFT Compliance.
• Translate regulatory and supervisory data needs into detailed functional specifications, logical data models, and BI solution designs on the Teradata Vantage platform.
• Analyze and map data flows from licensed financial institutions' regulatory submissions (e.g., XBRL, Excel, API-based returns) into Teradata Data Warehouse layers — staging, ODS, DWH, and subject-area data marts.
• Support design and review of Teradata SQL queries, stored procedures, macros, and BTEQ scripts in collaboration with data engineers and DWH architects.

Requirements:

• Bachelor's degree in Computer Science, Information Systems, Statistics, Economics, Finance, or a related field. Master's degree is an advantage.
• Minimum 5 years of Business Analysis experience, with at least 3 years in Data Warehouse and BI projects.
• Hands-on experience with Teradata Vantage (SQL, BTEQ, FastLoad/MultiLoad/TPT, Teradata Studio or Vantage Editor).
• Strong knowledge of dimensional modeling — star schema, snowflake, fact and dimension tables, slowly changing dimensions (SCD Types 1/2/3).
• Proven experience in a regulatory, central bank, or financial authority environment, or in a regulatory reporting function within a financial institution.