Finance Data Modeler

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise data platforms and business applications.
• Translate business requirements and processes into scalable, reusable data structures.
• Develop relational, dimensional, star-schema, snowflake-schema, and domain-oriented data models as appropriate.
• Define entities, attributes, relationships, primary keys, foreign keys, business keys, hierarchies, and reference-data structures.
• Define and enforce naming conventions, modeling standards, data types, and modeling best practices.
• Partner with business and technical teams to establish consistent definitions for critical business data.
• Support master data, reference data, metadata, and data-governance initiatives.
• Maintain model documentation, business definitions, lineage, and metadata in enterprise modeling or cataloging tools.
• Participate in design reviews and ensure proposed database and analytics solutions comply with established architecture standards.
• Use data-modeling tools such as ER/Studio, ERwin, PowerDesigner, Visio, Lucidchart, or equivalent platforms.
• Ensure models appropriately support historical data, slowly changing dimensions, auditability, and data traceability where required.
• Contribute to data-quality controls by identifying required fields, valid relationships, integrity constraints, and business rules.
• Knowledge in unity catalog and databricks.