Data Modeler

Location: New York City, NY

Salary: $ USD Annually – $ USD Annually

Job Title: Data Modeler

Location: Hybrid –

Employment-Fulltime

We are seeking a highly skilled Data Modeler with ER Studio expertise to join a Data Engineering team focused on designing, developing, and delivering data products leveraging Databricks on AWS
. This role involves creating robust data models at both enterprise and data product levels, ensuring alignment with business requirements and industry standards.

• Apply ER Studio and advanced data modeling techniques (Conceptual, Logical, Physical, 3NF, Dimensional) to support enterprise and product-level data architecture.
• Collaborate with Business Architects, Solution Architects, and Data Stewards to capture business requirements and translate them into conceptual and logical data models.
• Maintain and enhance data modeling standards and guidelines
  .
• Validate physical data models to ensure consistency with logical designs.
• Develop Databricks notebooks using Spark SQL and Py Spark for data engineering tasks.
• Support enterprise data catalog setup and enrichment (Unity Catalog).
• Contribute to building and testing data pipelines for data products.

• 4 years of hands-on data modeling experience with ER Studio.
• Strong expertise in Conceptual, Logical, Physical modeling
  , 3NF
  , and Dimensional modeling
  .
• Solid SQL skills for data analysis and transformation.
• Experience with Databricks and understanding of Medallion Architecture
  .
• Working knowledge of Unity Catalog
  .
• Familiarity with traditional DBMS (Oracle) and cloud DBMS (Redshift, Databricks).
• Background in data management and supporting data pipeline development.
• Experience in financial sector
  , especially market securities reference data and fixed income instruments (e.g., Treasuries).
• Strong communication skills (verbal, written, and presentation).

• Knowledge of AWS services related to data engineering.
• Exposure to data governance and metadata management
  .