Data Modeler

Job Title: Data Modeler

Key Responsibilities:

Design conceptual, logical and physical data models, data dictionaries, and metadata repositories.

Consult with business users to determine the requirements needed to guide the development of the data models.

Employ “Entity-Relationship” modeling to produce a design best suited for retrospective data analysis.

Determine the right set of facts and surrounding dimensions suited to perform the desired type of analysis or queries against the data.

Analyze existing business system data, data profiling, and source analysis.

Investigate and resolve the more complex data relationship issues.

Maintain data integrity by working to eliminate redundancy

Minimum Qualifications:

10+ years of experience in Data Modeling and Database Designing in Relational and Non-Relational Database, at least 5+ years in Financial Industries focused

Proficiency in SQL, data querying, and performance optimization techniques

Expert experience in building highly normalized data models for OLTP as well as developing Dimensional models.

Strong experience with data structures, data modeling, data lineage and data catalogs.

Understanding Metadata Management principles ( Data Dictionary activities ).

Hands-on experience with Creating the ETL Mapping.

Understanding the impacts of model changes on databases and validating that a model supports straightforward requirements.

Hands-on experience with 3NF Data Modeling and Normalized schema.

Should be able to analyze business requirements to develop data models with minimal oversight.

Desired Qualifications:

Knowledge on other Data Modeling tools like Power Designer, Visio, and ER studio.

Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimensions, multi-Star/ Snowflake Schema Modeling, and different types of Fact tables.

Implementing a virtual semantic layer (virtual star schema) using views on a multi-tiered normalized Integrated Operational Data Store is a huge plus. 3NF (Relational) Logical and Physical Modeling.

Knowledge of Core banking is good to have.