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