Data Modeler

Role Data Modeler Finance Domain

Seeking an experienced Data Modeler with strong expertise in the Finance domain to design and maintain conceptual logical and physical data models supporting financial reporting accounting risk treasury and regulatory initiatives

Primary Skill

Strong experience in Data Modeling Conceptual Logical Physical

Handson experience with Erwin ERStudio PowerDesigner or similar tools

Strong SQL and database design expertise

Experience with Oracle SQL Server Snowflake Azure SQL or PostgreSQL

Knowledge of Data Warehousing Data Vault and Dimensional Modeling

Understanding of Finance processes such as

General Ledger GL

Accounts Payable Receivable APAR

Financial Reporting

Treasury

Regulatory Risk Reporting

Secondary Nice To Have Skills NOT MANDATORY

Azure Databricks Azure Data Factory Synapse or Snowflake

Experience in Banking Capital Markets or Financial Services

Knowledge of IFRS US GAAP or Basel regulations

Soft Skills

Good communication collaboration and mentoring skills

3 Qualifying Questions

1 You are designing a Insurance Policy System Explain how you would create the Conceptual Logical and Physical Data Model from a business requirement document

2 A highly normalized Oracle OLTP application is experiencing slow response times How would you decide whether to denormalize the model Provide an example

3 Give an example of designing the data model from your past experience Draw the main entities keys and relationships Then explain any assumptions you made

Skills

Mandatory Skills : Dimensional Data Modeling