Description

You will design conceptual, logical, and physical data models, data dictionaries, and metadata repositories for financial systems.

Responsibilities

• Design Entity-Relationship models to support retrospective data analysis.
• Consult with business users to translate requirements into functional data models.
• Determine appropriate facts and dimensions to support specific analytical queries.
• Perform data profiling and source analysis on existing business systems.
• Resolve complex data relationship issues and eliminate redundancy to maintain integrity.

Required Skills

• 10+ years of experience in Data Modeling and Database Design for both Relational and Non-Relational databases.
• 5+ years of experience within the Financial Industries.
• Expertise in building highly normalized 3NF data models for OLTP and dimensional models.
• Proficiency in SQL, data querying, and performance optimization.
• Strong experience with data structures, data lineage, and data catalogs.
• Hands-on experience creating ETL mappings.
• Solid understanding of Metadata Management principles and Data Dictionary activities.

Preferred Skills

• Experience with Power Designer, Visio, or ER Studio.
• Knowledge of Ralph Kimball’s Data Modeling Concepts, including star/snowflake schemas and slowly changing dimensions.
• Experience implementing a virtual semantic layer using views on a multi-tiered normalized Integrated Operational Data Store.

Key Skills

Education

Any Gradute